php访问sqlite数据库的例子

3. $dbconn = sqlite_open('phpdb');

4. if ($dbconn) {

5. sqlite_query($dbconn, "CREATE TABLE animal(Name VARCHAR(255), MaxAge INT);");
6. sqlite_query($dbconn, "INSERT INTO animal VALUES ('A', 15)");
7. $result = sqlite_query($dbconn, "SELECT Name FROM animal");
8. var_dump(sqlite_fetch_array($result, SQLITE_ASSOC));
9. } else {
10. print "Connection to database failed!\n";
11. }

复制代码

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

3. $rows = array();

4. while($row = sqlite_fetch_array($result, $res_type, $decode)) {

5. $rows[] = $row;
6. }
7. ?>

复制代码

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