<?php
$dbconn = sqlite_open('phpdb');
if ($dbconn) {
sqlite_query($dbconn, "CREATE TABLE animal(Name VARCHAR(255), MaxAge INT);");
sqlite_query($dbconn, "INSERT INTO animal VALUES ('A', 15)");
$result = sqlite_query($dbconn, "SELECT Name FROM animal");
var_dump(sqlite_fetch_array($result, SQLITE_ASSOC));
} else {
print "Connection to database failed!n";
}
<?php
$rows = array();
while($row = sqlite_fetch_array($result, $res_type, $decode)) {
$rows[] = $row;
}
?>
SQLITE_OK No error occurred.
SQLITE_ERROR SQLite error (or database not found).
SQLITE_INTERNAL An internal SQLite error.
SQLITE_PERM Access permission denied.
SQLITE_ABORT Callback routine aborted.
SQLITE_BUSY The database file is currently locked.
SQLITE_LOCKED A table within the database is locked.
SQLITE_NOMEM SQLite memory allocation error.
SQLITE_
readonly An attempt to write to a read-only database.
SQLITE_INTERRUPT Interrupted operation.
SQLITE_IOERR A file I/O error has occurred.
SQLITE_CORRUPT The specified database is corrupted.
SQLITE_FULL Database is full.
SQLITE_CANTOPEN Could not open database file.
SQLITE_PROTOCOL Database lock protocol error.
SQLITE_SCHEMA The database schema changed.
SQLITE_TOOBIG Too much data for a single row.
SQLITE_CONSTRAINT Abort due to constraint violation.
SQLITE_MISMATCH Data type mismatch.
SQLITE_AUTH Authorization denied.
SQLITE_ROW sqlite_step() has another row ready.
SQLITE_DONE sqlite_step() has finished executing.
