PHP sqlite database operation examples (create/open/insert/retrieve), sqlite examples

The examples in this article describe the methods of PHP sqlite database operations. Share it with everyone for your reference, the details are as follows:

SQLite is a lightweight database. Its design target is embedded, and it has been used in many embedded products. It occupies very low resources. In embedded devices, it may only require a few One hundred K of memory is enough. It can support mainstream operating systems such as Windows/Linux/Unix, and can be combined with many programming languages, such as Tcl, PHP, Java, etc., as well as ODBC interfaces. It is also compared to MySQL and PostgreSQL, two world-famous open source software. In terms of database management systems, its processing speed is faster than them all.

PHP 5 no longer supports Mysql by default, but supports SQLite by default. This shows how influential it is, so if you want to do PHP development of SQLite, it is recommended that you use PHP 5.0.0 or above.

The following is an example using sqlite

First, you can create a new empty file upload.db in the directory

<&#63;php
define("LN", __LINE__);//行號
define("FL", __FILE__);//當前文件
define("DEBUG", 0);//調(diào)試開關(guān)
$db_name = "upload.db";
//創(chuàng)建數(shù)據(jù)庫文件,文件內(nèi)容為空
if (!file_exists($db_name)) {
 if (!($fp = fopen($db_name, "w+"))) {
 exit(error_code(-1, LN));
 }
 fclose($fp);
}
//打開數(shù)據(jù)庫文件
if (!($db = sqlite_open($db_name))) {
 exit(error_code(-2, LN));
}
//產(chǎn)生數(shù)據(jù)表結(jié)構(gòu)
if (!sqlite_query($db, "DROP TABLE uploads")) {
 exit(error_code(-3, LN));
}
if (!sqlite_query($db, "CREATE TABLE uploads (id integer primary key, file_name varchar(200) UNIQUE, make_time integer)")) {
 exit(error_code(-3, LN));
}
//插入一條數(shù)據(jù)
if (!sqlite_query($db, " INSERT INTO uploads (file_name, make_time) VALUES ('upload/111.data','".time()."') ")) {
 exit(error_code(-4, LN));
}
//把數(shù)據(jù)檢索出來
if (!($result = sqlite_query($db, "SELECT * FROM uploads"))) {
 exit(error_code(-5, LN));
}
//獲取檢索數(shù)據(jù)并顯示
while ($array = sqlite_fetch_array($result)) {
 echo "ID: ". $array[file_name] ."<br>: ". $array[make_time] ;
}
/* 錯誤信息代碼函數(shù) */
function error_code($code, $line_num, $debug=DEBUG)
{
 if ($code<-6 || $code>-1) {
 return false;
 }
 switch($code) {
 case -1: $errmsg = "Create database file error.";
  break;
 case -2: $errmsg = "Open sqlite database file failed.";
  break;
 case -3: $errmsg = "Create table failed, table already exist.";
  break;
 case -4: $errmsg = "Insert data failed.";
  break;
 case -5: $errmsg = "Query database data failed.";
  break;
 case -6: $errmsg = "Fetch data failed.";
  break;
 case -7: $errmsg = "";
  break;
 default: $errmsg = "Unknown error.";
 }
 $m = "<b>[ Error ]</b><br>File: ". basename(FL) ." <br>Line: ". LN ."<br>Mesg: ". $errmsg ."";
 if (!$debug) {
 ($m = $errmsg);
 }
 return $m;
}
&#63;>

Readers who are interested in more PHP-related content can check out the special topics of this site: "Summary of PHP database operation skills based on pdo", "PHP MongoDB database operation skills collection", "php object-oriented programming introductory tutorial", "php Summary of String Usage", "Introduction Tutorial on PHP MySQL Database Operation" and "Summary of PHP Common Database Operation Skills"

I hope this article will be helpful to everyone in PHP programming.