PHP access to the SQLite database example

$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"; } Copy Code Example 2, saving the result set to an array $rows = Array (); while ($row = Sqlite_fetch_array ($result, $res _type, $decode)) { $rows [] = $row; } ?> Copy Code Attached, SQLite Error Constants 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 a 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.

