For bug reports, feature requests, suggestions, driver submissions please write to .

Project Goal:
The goal is to provide a simple class for fast , secure and powerfull database manipulations. This class eases the development of dynamic database based web applications, by making the code more shorter and simpler.

For proof of concept and demonstrations of usage I provide an example database and a normal procedural PHP example and an example with this class.

This is made possible by comparing PHP SQL class`s code with procedural PHP code, those who just want to learn how to use this class, please ignore the "classical PHP example"-s.

host: "localhost"
user: "foo"
password: "bar"
database name: "shop"
database type: "MYSQL"

id name price qty
3 beer 1 100
7 CD 0.5 0
9 shoe 20 3

1. Connecting to database:

classical PHP example:
$host = "localhost";
$user = "foo";
$password = "bar";
$database = "shop";
$link = mysql_connect($host,$user,$password);

PHP SQL Class example:

$Sql = new SQL("MYSQL_DRIVER","localhost","foo","bar","shop");

2. Getting the whole table into one arrary

classical PHP example:
$tmp = array();
$mat = array();
$res = mysql_query("SELECT * FROM `prods`");
while ($tmp = mysql_fetch_array($res,MYSQL_ASSOC))
    $mat[] = $tmp;

PHP SQL Class example:

$mat = $Sql->getQuery("SELECT * FROM `prods`");

3. Getting the number of results

classical PHP example:
$res = mysql_query("SELECT * FROM `prods`");
$count = mysql_num_rows($res);

PHP SQL Class example:

$count= $Sql->countQueryResults("SELECT * FROM `prods`");

More examples are to come.