I have once again cleared out my schedule for some PHP scripting work. If you need anythign done PHP wise, please don't be afraid to let me know !

I have experience with Admin scripts, User Managements, extensive experience working with MySQL. If you have something you need done, let me know and we can work something out. I only take a few projects at a time so get to me asap !

Small illustration of my work, I have put together a small script for anyone to use. It fetches multiple records from a MySQL database, and displays them as a record set on a page. Multiple pages and has the feature to retain any variables sent to the script via the URL. ( This has been a problem I run across in a few of the record set classes out there, not being able to have any GET information translated to the multiple page links. )

The class can be downloaed here.

Results.Cls.Php (http://www.vellocinet.com/results.cls.zip)

And it can easily be used via ...




<?

require("results.cls.php");

$dbcnx = mysql_connect("localhost", "username", "password");
mysql_select_db("database");
$query = "SELECT * FROM `table`";

$tmplHead = "
<table width=100% cellpadding=0 cellspacing=0 border=1>
";

$tmplBody = "
<tr><td><| row0 |></td><td><| row1 |></td><td><| row2 |></td><td><| row3 |></td></tr>
";

$tmplFoot = "
</table>
";

$multiRes = new multiRes($dbcnx, $query, "10", $tmplHead, $tmplBody, $tmplFoot);
echo $multiRes->showRes();

?>


Note, the <| row |> is a special tag that is parsed from the class, each number represents a value in the row from your database.

Example:
---------------------------
| Id | Fname | Lname|
| 1 | John | Curtis |
| 2 | William | Knock |
---------------------------

<| row0 |> = ID
<| row1 |> = Fname
<| row2 |> = Lname

This can be expanded into many ways. The $multiRes->showRes(); is simpley a variable for the entire results in a table. Also, you can take the template variables and put them into a settings file, and this way you can create a central location for all your HTML and layout. And you can edit the $query to make a more restrictive search. Especially usefull when using forms !

Any questions, if something doesn't work right, or your having some troubles, lemme know at support@vellocinet.com

If you need some scripting, please email me at novicane@vellocinet.com or ICQ me at 1716464 or AIM me at DeimusMorte.

Thanks !!

I recommend Novicane, he has great support and a key thing that I like was that I told him what I wanted and he gave me all these exciting and better idea's for it. He's just great.