example3.php

我收集的Sqlite的PHP模块

<?php

/*
 * you may need this line, depending on how you compile
 * this extension.
 */

dl('sqlite3.so');


/*
 * create a callback function.
 *
 * It will be called by sqlite3_exec() for each row in the result
 * set.
 */

function my_callback($data, $columns)
{

	echo "my_callback called !\n";
  echo "1st argument: " . implode($data, ',')    ."\n";
  echo "2nd argument: " . implode($columns, ',') ."\n";
  
  return 0;
}


/*
 * create a SQLite3 handle. 
 *
 * Note: in-memory database are created by the magic keyword ":memory:"
 *
 */

$db = sqlite3_open(":memory:");
if (!$db) die ("Could not create in-memory database..");

/*
 * create a simple test and insert some values..
 */

$ret = sqlite3_exec ($db, "CREATE TABLE test (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER);");
if (!$ret) die (sqlite3_error($db));

sqlite3_exec($db, "INSERT INTO test (name,age) VALUES ('michael',32)");
sqlite3_exec($db, "INSERT INTO test (name,age) VALUES ('bob',27)");
sqlite3_exec($db, "INSERT INTO test (name,age) VALUES ('martin',12)");


/*
 * Note the 3rd argument to this function ...
 *
 */

$res = sqlite3_exec($db, "SELECT * from test ORDER BY name", "my_callback");


sqlite3_close($db);

?>