For a while now, I’ve been working on a PHP DB wrapper class. The whole point of it is to make writing the same old queries over and over again a little bit easier to manage. I’ve noticed that I haven’t had to edit it over the past few months, and I’ve implemented it at work without issue on many occasions, so I figure it’s time to share it with the world.

To use it, first create an instance of the object:

$db = new db("user", "pass", "db", "host");

And once you have it, you can perform various types of queries.

For selects that will return multiple rows, use the following syntax:

$rows = $db->q("SELECT * FROM tbSomeTable;");

$rows will then either be false (which means the record had an error or returned 0 records) or an array of row objects:

foreach($rows as $row){
    print($row->someField);
}

For single-row queries (such as those with LIMIT 1 or using a COUNT or similar function), use sq:

$row = $db->sq("SELECT COUNT(*) AS intCount FROM tbSomeTable;");

$row is then an object representing a single row of the resultset. If the query returns multiple rows, only the first row is used.

For insert, update, delete, and other queries, $db->q is used.

An advantage to my wrapper is the printf-like auto-escaping, allowing you to easily use user input:

$rows = $db->q("SELECT * FROM tbUsers WHERE User='%s' AND Pass='%s';", $_POST["user"], $_POST["pass"]);

The %s are then replaced with the corresponding argument and automatically stripped using mysqli’s strip function.

Here’s a short snippet tying everything together showing how quick and easy it is to write a DB resultset iteration:
if(($rows = $db->q("SELECT * FROM tbUsers WHERE intUserType='%s';", $_GET["intUserType"])) !== false){
    foreach($rows as $row){
        print($row->strUsername . “<br />”);
    }
}else{
    print(”No records found!”);
}

Debugging can be achieved via $db->messages();

It also has support for transactions (commit, rollback), documented in the readme

If you want to give it a try, you can download it here

If you have any questions or suggestions, leave them in my comments!