PHP reads sqlite database entry example code_javascript skills-JS Tutorial-php.cn

PHP reads sqlite database entry example code_javascript skills

WBOY

Release： 2016-05-16 16:43:14

Original

2458 people have browsed it

Introduction to SQLite

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 takes up very low resources. In embedded devices, 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 compared to Mysql and PostgreSQL. For the world-famous open source database management system, its processing speed is faster than them all.

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 add the following extension:

Copy code The code is as follows:

extension=php_pdo.dll

extension=php_pdo_sqlite.dll

extension=php_sqlite.dll

The sqlite_open command opens a database file.
Create the file if it does not exist.

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
The temporary database file that stores the temporary table cannot be opened. In a Windows environment, if the above error occurs,
Please use putenv("TMP=C:/temp"); to specify the temporary folder.

Please see the code for details:

<&#63;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, '名字')";
 
//执行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;
}
&#63;>

Copy after login

PHP SQLite database operation tutorials and examples

<&#63;php
    //设置脚本最大执行时间
    set_time_limit(0);
    //sqlite数据库文件名
    $db_name = 'md5.db';
    //打开sqlite数据库
    $db = sqlite_open($db_name);
    //异常处理
    if( !$db ) {
        echo '不能连接SQlite文件：',$db_name,'<br />';
    }else{
        echo '成功连接SQlite文件：',$db_name,'<br />';
    }
    //创建数据表：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,'{$d}')");
        $s++;
    }
    //检索所有记录
    $result = sqlite_query($db, 'SELECT * FROM md5');
    echo '<pre class="brush:php;toolbar:false">';
    while ($row = sqlite_fetch_array($result, SQLITE_BOTH)) {
        echo 'Md5:',$row['d'],' Src:',$row['s'], '<br />';
    }
    echo '

'; //关闭SQLite连接 sqlite_close($db); ?>

Copy after login

php reads sqlite entry version

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

Copy after login