Found an ODBC driver [1] for SQLite today. It works perfectly with PHP.
<?php
// via ODBC
$db = odbc_connect(\”DSN=SQLite.1;UID=;PWD=\”, \”\”, \”\”, SQL_CUR_USE_DRIVER);
$result = odbc_exec($db, \”SELECT * from tbl1;\”) or die(\”Error: \” . odbc_errormsg());
if (odbc_fetch_row($result))
{
for($i=1; $i<=odbc_num_fields($result); $i++)
{
$key = odbc_field_name($result, $i);
$val = odbc_result($result, $key);
$stack[$i-1] = array($key => $val);
}
}
print_r($stack);
?>
This could be used alternatively to the new PECL extension [2] reported earlier:
<?php
// via PECL SQLite extension
$database = \”./var/testdb\”;
$db = sqlite_open($database);
$r = sqlite_query(\”SELECT * from tbl1;\”, $db);
$stack = sqlite_fetch_array($r, SQLITE_NUM);
sqlite_close($GLOBALS[\’db\’]);
print_r($stack);
?>
[1] http://www.ch-werner.de/sqliteodbc/
[2] http://pear.php.net/package-info.php?pacid=193
