Home > Backend Development > PHP Tutorial > Code sharing for php operating SQLite class

Code sharing for php operating SQLite class

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-07-25 08:57:22
Original
1029 people have browsed it
This article introduces a class that operates SQLite data in PHP programming. The code is shared here for reference by friends in need.

Provides a PHP operation SQLite class:

<?php
/*
* 操作sqlite的类
* edit by bbs.it-home.org
//应用举例

require_once('cls_sqlite.php');

//创建实例
$DB=new SQLite('blog.db'); //这个数据库" title="数据库" >数据库文件名字任意

//创建数据库" title="数据库" >数据库表。
$DB->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('sjolzy')");

//读取数据
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();
    }
}
?>
Copy after login

Attached, related PHP configuration instructions:

1. First test whether PHP can connect to the sqlite database" title="Database" >Database: Create a php file

<?php
$conn  =  sqlite_open('test.db');
?>
Copy after login

Test whether the file can run normally.

If the sqlite module fails to load normally, the following error may occur: Fatal error: Call to undefined function sqlite_open() in C:ApacheApache2htdocstest.php on line 2

Solution: Open the php.ini file and remove the semicolons before the following three lines, that is, remove the comments, to make the configuration section take effect:

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

Restart apache or nginx to make the configuration take effect.



Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template