sqlite_close($dbhandle); if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror)) { sqlite_query($db, 'CREATE TABLE foo (bar varchar(10))'); sqlite_query($db, "INSERT INTO foo VALUES ('fnord')"); $result = sqlite_query($db, 'select bar from foo'); var_dump(sqlite_fetch_array($result)); } else { die($sqliteerror); } $db = sqlite_open('mysqlitedb'); $result = sqlite_query($db, "SELECT * FROM mytable WHERE name='John Doe'"); $rows = sqlite_num_rows($result); echo "Number of rows: {$rows}"; $db = new SQLiteDatabase('mysqlitedb'); $result = $db->query("SELECT * FROM mytable WHERE name='John Doe'"); $rows = $result->numRows(); echo "Number of rows: {$rows}"; $dbhandle = sqlite_open('mysqlitedb'); $query = sqlite_exec($dbhandle, "UPDATE users SET email='*****@*****.**' WHERE username='******'", $error); if (!$query) { exit("Error in query: '{$error}'"); } else { echo 'Number of rows modified: ', sqlite_changes($dbhandle); } $dbhandle = new SQLiteDatabase('mysqlitedb'); $query = $dbhandle->queryExec("UPDATE users SET email='*****@*****.**' WHERE username='******'", $error); if (!$query) { exit("Error in query: '{$error}'"); } else { echo 'Number of rows modified: ', $dbhandle->changes(); }
<?php $db = new SQLiteDatabase(":memory:"); $db->query("CREATE TABLE foobar (misc CHAR(10))"); $db->query("INSERT INTO foobar (misc) VALUES('Tall')"); $db->query("\n\tINSERT INTO foobar (misc) VALUES('Wez');\n\tINSERT INTO foobar (misc) VALUES('Marcus');\n\tINSERT INTO foobar (misc) VALUES('Ilia');\n\tUPDATE foobar SET misc='Tal' WHERE misc='Tall';\n"); /* When chained queries are used rows changed returns the * cumulative of all rows affected by executed queries. */ echo $db->changes() . "rows affected by chained query.";