Home  >  Article  >  Backend Development  >  PHP reads sqlite database (basic)

PHP reads sqlite database (basic)

怪我咯
怪我咯Original
2017-07-04 14:14:474177browse

This article introduces a simple example of php reading sqlite database, and an introductory example of operating sqlite in php programming. Friends in need can refer to it

SQLite introduction

SQLite is a lightweight database and a relational database management system that complies with ACID. Its design goal is to be embedded, and it has been used in many embedded products. It occupies very low resources and is widely used in embedded applications. In the device, only a few hundred K of memory may be 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, C++, .Net, etc., as well as the ODBC interface. It is also better than Mysql, For PostgreSQL, two world-famous open source database management systems, its processing speed is faster than both of them.

Simply use PHP to connect to SQLite to create a table, and use INSERT and SELECT statements to operate the SQLITE database.

Before using SQLite, we must ensure that sqlite and pdo configuration have been enabled in php.ini

Open the PHP.INI file and type the following extension:

Code As follows:

extension=php_pdo.dll
extension=php_pdo_sqlite.dll
extension=php_sqlite.dll

The sqlite_open command opens a database file.
Create if there is no file.

sqlite_query can execute SQL statements.
Create a table and insert data.

sqlite_unbuffered_query issues a SELECT statement.

Loop and display the results.

unable to open a temporary database file for storing temporary tables
Unable to open a temporary database file for storing temporary tables. In Windows environment, if the above error occurs,
please Use putenv("TMP=C:/temp"); to specify the temporary folder.

Please see the code for details:

<?php
 
//临时目录 在Windows环境中,如果出现上述错误,请使用putenv("TMP=C:/temp");指定临时文件夹。
//putenv("TMP=C:/temp");
 
//打开数据库
if ($db = sqlite_open("test.db",0666,$sqliteerror)) {
 
//创建表
sqlite_query($db, "create table user(id integer primary key,name text);");
 
//INSERT语句
$sql = "insert into user values(NULL, &#39;名字&#39;)";
 
//执行SQL语句
$res = sqlite_query($db, $sql);
 
//SELECT语句
$sql = "select * from user order by id desc limit 20";
 
//执行SQL语句
$res = sqlite_unbuffered_query($db, $sql);
 
//显示结果
while ($item = sqlite_fetch_array($res, SQLITE_ASSOC)) {
print "ID:".$item["id"] ."NAME:".$item["name"];
print "<BR>";
};
 
//关闭数据库
sqlite_close($db);
 
} else {
print $sqliteerror;
}
?>

PHP+SQLiteDatabase operationTutorials and examples

<?php
    //设置脚本最大执行时间
    set_time_limit(0);
    //sqlite数据库文件名
    $db_name = &#39;md5.db&#39;;
    //打开sqlite数据库
    $db = sqlite_open($db_name);
    //异常处理
    if( !$db ) {
        echo &#39;不能连接SQlite文件:&#39;,$db_name,&#39;<br />&#39;;
    }else{
        echo &#39;成功连接SQlite文件:&#39;,$db_name,&#39;<br />&#39;;
    }
    //创建数据表:MD5密码表
    sqlite_query($db, "CREATE TABLE md5 (s int(4) PRIMARY KEY,d varchar(32))");
    //插入记录
    $s = 0;
    while($s <= 999999){
        $d = md5($s);
        sqlite_query($db, "INSERT INTO md5 VALUES ($s,&#39;{$d}&#39;)");
        $s++;
    }
    //检索所有记录
    $result = sqlite_query($db, &#39;SELECT * FROM md5&#39;);
    echo &#39;<pre class="brush:php;toolbar:false">&#39;;
    while ($row = sqlite_fetch_array($result, SQLITE_BOTH)) {
        echo &#39;Md5:&#39;,$row[&#39;d&#39;],&#39; Src:&#39;,$row[&#39;s&#39;], &#39;<br />&#39;;
    }
    echo &#39;
'; //关闭SQLite连接 sqlite_close($db); ?>

php reading Get sqlite entry version

<?php
//打开sqlite数据库
//$db = @sqlite_open("MM.sqlite", 0666, $error); // 不支持
//$db = new PDO(&#39;sqlite:MM.sqlite&#39;);
//异常处理
if (!$db) die("Connection Sqlite failed.\n");
//添加一个叫做foo的数据库
//@sqlite_query($db, "CREATE TABLE foo (bar varchar(10))");
//插入一条记录
//@sqlite_query($db, "INSERT INTO foo VALUES (&#39;fnord&#39;)");
//检索所有记录
$result = $db->query(&#39;select BottleEncryptUsrName from BottleTable4&#39;);
//打印获取的结果
foreach($result as $row){
	echo $row[0];
	echo "<br>";
}
?>

The above is the detailed content of PHP reads sqlite database (basic). For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn