php访问sqlite数据库的例子
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Lepaskan: 2016-07-25 08:57:43
asal
1714 orang telah melayarinya
-
-
$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. |
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Artikel terbaru oleh pengarang
-
2025-02-26 03:58:14
-
2025-02-26 03:38:10
-
2025-02-26 03:17:10
-
2025-02-26 02:49:09
-
2025-02-26 01:08:13
-
2025-02-26 00:46:10
-
2025-02-25 23:42:08
-
2025-02-25 22:50:13
-
2025-02-25 21:54:11
-
2025-02-25 20:45:11
Topik-topik yang berkaitan
Lagi>