Home  >  Article  >  Backend Development  >  Detailed explanation of SQLite database classes and usage with PHP

Detailed explanation of SQLite database classes and usage with PHP

墨辰丷
墨辰丷Original
2018-05-21 14:14:411854browse

This article mainly introduces the simple operation SQLite database classes and usage implemented by PHP. It analyzes the operation skills and usage methods of adding, deleting, modifying and checking related to SQLite database encapsulated in PHP based on specific examples. Friends in need can refer to it

SQLite is a lightweight database, 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, 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.

Here is a simple PHP operation SQLite class for everyone:

query("create table test(id integer primary key,title varchar(50))");
//接下来添加数据
$DB->query("insert into test(title) values('泡菜')");
$DB->query("insert into test(title) values('蓝雨')");
$DB->query("insert into test(title) values('Ajan')");
$DB->query("insert into test(title) values('傲雪蓝天')");
//读取数据
print_r($DB->getlist('select * from test order by id desc'));
//更新数据
$DB->query('update test set title = "三大" where id = 9');
***/
class SQLite
{
 function __construct($file)
 {
  try
  {
   $this->connection=new PDO('sqlite:'.$file);
  }
  catch(PDOException $e)
  {
   try
   {
    $this->connection=new PDO('sqlite2:'.$file);
   }
   catch(PDOException $e)
   {
    exit('error!');
   }
  }
 }
 function __destruct()
 {
  $this->connection=null;
 }
 function query($sql) //直接运行SQL,可用于更新、删除数据
 {
  return $this->connection->query($sql);
 }
 function getlist($sql) //取得记录列表
 {
  $recordlist=array();
  foreach($this->query($sql) as $rstmp)
  {
   $recordlist[]=$rstmp;
  }
  return $recordlist;
 }
 function Execute($sql)
 {
  return $this->query($sql)->fetch();
 }
 function RecordArray($sql)
 {
  return $this->query($sql)->fetchAll();
 }
 function RecordCount($sql)
 {
  return count($this->RecordArray($sql));
 }
 function RecordLastID()
 {
  return $this->connection->lastInsertId();
 }
}
?>

Related PHP configuration instructions:

1. First test whether PHP can connect to the sqlite database:

Create a php file

Test whether this file can run normally.

If the sqlite module cannot be loaded normally, an error like this may occur:

Fatal error: Call to undefined function sqlite_open() in C:\Apache\Apache2\htdocs\ test.php on line 2

The solution is as follows:

2. Open the php.ini file and delete the semicolons in front of the following three lines:

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

Restart the web server

Related recommendations:

PHP based on PDO implementationSQLiteMethods of operation classes

##SQLite Detailed explanation of PHP interface

php is based on SQLiteMethod to implement paging function

The above is the detailed content of Detailed explanation of SQLite database classes and usage with PHP. 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