$dbconn = sqlite_open('phpdb');
if ($dbconn) {
script!
sqlite_query($dbconn, "INSERT INTO animal VALUES('a', 14)");
sqlite_query($dbconn, "INSERT INTO animal VALUES('b', 16)");
sqlite_query($dbconn, "INSERT INTO animal VALUES('c', 13)");
var_dump(sqlite_array_query($dbconn, "SELECT * FROM animal", SQLITE_ASSOC));
} else {
print "Connection to database failed!\n";
}
|