SQLite PHP介面詳解

本文主要和大家分享SQLite PHP介面知識，希望能協助到大家，首先我們來看一下PHP 介面 API的相關知識。

PHP 介面 API

串連資料庫

<?php   class MyDB extends SQLite3   {      function __construct()      {         $this->open('test.db');      }   }   $db = new MyDB();   if(!$db){      echo $db->lastErrorMsg();   } else {      echo "Opened database successfully\n";   }?>

建立表

<?php   class MyDB extends SQLite3   {      function __construct()      {         $this->open('test.db');      }   }   $db = new MyDB();   if(!$db){      echo $db->lastErrorMsg();   } else {      echo "Opened database successfully\n";   }   $sql =<<<EOF      CREATE TABLE COMPANY      (ID INT PRIMARY KEY     NOT NULL,      NAME           TEXT    NOT NULL,      AGE            INT     NOT NULL,      ADDRESS        CHAR(50),      SALARY         REAL);EOF;   $ret = $db->exec($sql);   if(!$ret){      echo $db->lastErrorMsg();   } else {      echo "Table created successfully\n";   }   $db->close();?>

INSERT 操作

<?php   class MyDB extends SQLite3   {      function __construct()      {         $this->open('test.db');      }   }   $db = new MyDB();   if(!$db){      echo $db->lastErrorMsg();   } else {      echo "Opened database successfully\n";   }   $sql =<<<EOF      INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)      VALUES (1, 'Paul', 32, 'California', 20000.00 );      INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)      VALUES (2, 'Allen', 25, 'Texas', 15000.00 );      INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)      VALUES (3, 'Teddy', 23, 'Norway', 20000.00 );      INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)      VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 );EOF;   $ret = $db->exec($sql);   if(!$ret){      echo $db->lastErrorMsg();   } else {      echo "Records created successfully\n";   }   $db->close();?>

SELECT 操作

<?php   class MyDB extends SQLite3   {      function __construct()      {         $this->open('test.db');      }   }   $db = new MyDB();   if(!$db){      echo $db->lastErrorMsg();   } else {      echo "Opened database successfully\n";   }   $sql =<<<EOF      SELECT * from COMPANY;EOF;   $ret = $db->query($sql);   while($row = $ret->fetchArray(SQLITE3_ASSOC) ){      echo "ID = ". $row['ID'] . "\n";      echo "NAME = ". $row['NAME'] ."\n";      echo "ADDRESS = ". $row['ADDRESS'] ."\n";      echo "SALARY =  ".$row['SALARY'] ."\n\n";   }   echo "Operation done successfully\n";   $db->close();?>

UPDATE 操作

<?php   class MyDB extends SQLite3   {      function __construct()      {         $this->open('test.db');      }   }   $db = new MyDB();   if(!$db){      echo $db->lastErrorMsg();   } else {      echo "Opened database successfully\n";   }   $sql =<<<EOF      UPDATE COMPANY set SALARY = 25000.00 where ID=1;EOF;   $ret = $db->exec($sql);   if(!$ret){      echo $db->lastErrorMsg();   } else {      echo $db->changes(), " Record updated successfully\n";   }   $sql =<<<EOF      SELECT * from COMPANY;EOF;   $ret = $db->query($sql);   while($row = $ret->fetchArray(SQLITE3_ASSOC) ){      echo "ID = ". $row['ID'] . "\n";      echo "NAME = ". $row['NAME'] ."\n";      echo "ADDRESS = ". $row['ADDRESS'] ."\n";      echo "SALARY =  ".$row['SALARY'] ."\n\n";   }   echo "Operation done successfully\n";   $db->close();?>

DELETE 操作

<?php   class MyDB extends SQLite3   {      function __construct()      {         $this->open('test.db');      }   }   $db = new MyDB();   if(!$db){      echo $db->lastErrorMsg();   } else {      echo "Opened database successfully\n";   }   $sql =<<<EOF      DELETE from COMPANY where ID=2;EOF;   $ret = $db->exec($sql);   if(!$ret){     echo $db->lastErrorMsg();   } else {      echo $db->changes(), " Record deleted successfully\n";   }   $sql =<<<EOF      SELECT * from COMPANY;EOF;   $ret = $db->query($sql);   while($row = $ret->fetchArray(SQLITE3_ASSOC) ){      echo "ID = ". $row['ID'] . "\n";      echo "NAME = ". $row['NAME'] ."\n";      echo "ADDRESS = ". $row['ADDRESS'] ."\n";      echo "SALARY =  ".$row['SALARY'] ."\n\n";   }   echo "Operation done successfully\n";   $db->close();?>