// Connect to the database
$sqli = new sqli(["127.0.0.1", "", "", "test"]);
// Insert three rows to have some data to play with
$insert1 = $sqli->push("insert into test (msg) VALUES (?)", "s", "Just a test");
echo "Insert id:" . $insert1->id . "\n";
$insert2 = $sqli->push("insert into test (msg) VALUES (?)", "s", "Just a test");
echo "Insert id:" . $insert2->id . "\n";
$insert3 = $sqli->push("insert into test (msg) VALUES (?)", "s", "Just a test");
echo "Insert id:" . $insert3->id . "\n\n";
// Show the data form the array
foreach ($sqli->pull_multiple("SELECT id, msg as message FROM test")->data as $row) {
echo $row['id'] . " : " . $row['message'] . "\n";
}
echo "\n";
// Show one row
echo "First insert row: " . $sqli->pull_once("SELECT msg as message FROM test WHERE id=?", "i", $insert1->id)->data['message'] . "\n";
// Clere the table
echo "Deleted rows:" . $sqli->push("DELETE FROM test")->affected_rows . "\n";
// Some rows left?
echo "Rows left: " . $sqli->pull_multiple("SELECT * FROM test")->count;
/* HERES MY OUTPUT
Insert id:1
Insert id:2
Insert id:3
1 : Just a test
2 : Just a test
3 : Just a test
First insert row: Just a test
Deleted rows:3
