php存取sqlite資料庫的例子

$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";
    }

例2，将结果集保存到数组中

     $rows = array();
     while($row = sqlite_fetch_array($result, $res_type, $decode)) {
        $rows[] = $row;
     }
?>

附，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 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.