<?PHP

/*

* Project: Absynthe sql4array

* File: sql4array.example.php5

* Author: Absynthe <[email protected]>

* Webste: http://absynthe.is.free.fr/sql4array/

* Version: alpha 1

* Date: 30/04/2007

* License: LGPL

*/

header("Content-type: text");

require "./sql4array.class.php";

for ($i = 0; $i < 20; $i++)

{

$array[$i][id] = rand(0, 20);

$array[$i][foo] = md5(rand(0, 10000));

}

$sql = new sql4array();

$a = $sql->query("SELECT id, foo FROM array");

$b = $sql->query("SELECT id, foo FROM array WHERE id > 10");

$c = $sql->query("SELECT id AS i, foo AS f FROM array WHERE i > 10");

$d = $sql->query("SELECT id AS i, foo AS f FROM array WHERE i > 10 AND f LIKE '%a%'");

$e = $sql->query("SELECT id AS iiiiii, foo AS fooooooooo FROM array WHERE iiiiii != 10");

var_dump($a);

var_dump($b);

var_dump($c);

var_dump($d);

var_dump($e);

?>