PHP若何毗連的SQLite數據庫－苗栗網頁設計

sqlite3的名擴展在PHP 5.3.0+以上都邑默許啟用。在可以compile-時利用--without-sqlite3來禁用它。
視窗柯林斯用戶通過啟用php_sqlite3.dll才能利用此擴大。php_sqlite3.dll默許所有遊戲在PHP 5.3.0以後的PHP發行版中。
有關具體的安裝申明，請查看PHP教程及其官方網站。
毗鄰到的SQLite數據庫以下PHP代碼顯示若何毗鄰到SQLite數據庫。若是數據庫不存在，那麼它將建立一個新的數據庫，最後將返回一個數據庫對象。

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

複製代碼

現在，運行上面的法式在當前目錄中建立指定命據庫：phpdb.db。可以根據需要更改路徑。假如數據庫成功建立，則會供給以下新聞：

PHP若何毗連的SQLite數據庫
在履行上面語句後，應當也會在相同的目次下自動創建一個名稱為：phpdb.db的數據庫文件。如下所示 -

PHP若何毗連的SQLite數據庫

創建表以下PHP法式將用於在上面建立的數據庫（phpdb.db）中建立一個表：

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, 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 "Yes, Table created successfully \n";
}
$db->close();

複製代碼

當執行上述法式時，它將在數據庫（phpdb.db）中創建一個名稱為：company的表，並顯示以下動靜：

PHP若何毗連的SQLite數據庫

插入數據操作以下PHP顯示法式若何了上述在示例中建立³³的company表中插入數據記實：

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully \n";
}
// 先删除后创建表
$sql = "DROP table company";
$ret = $db->exec($sql);
// 创建表语句
$sql =<<<EOF
CREATE TABLE if not exists 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 "Yes, Table created successfully \n";
}
// $db->close();
$sql =<<<EOF
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Maxsu', 26, 'Haikou', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Allen', 25, 'Guangzhou', 15000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'Tenny', 23, 'Shanghai', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (4, 'Weiwang', 25, 'Beijing ', 65000.00 );
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Some Records has Inserted successfully \n";
}
$db->close();

複製代碼

當執行上述法式時，將向company表中插入給定的記錄，並顯示以下：
PHP若何毗連的SQLite數據庫

選擇操作以下PHP顯示程序若何了上述從示例中創建³³的company表中並電子雜誌數據顯示記錄：

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully \n";
}
// 先删除后创建表
$sql = "DROP table company";
$ret = $db->exec($sql);
// 创建表
$sql =<<<EOF
CREATE TABLE if not exists 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 "Yes, Table created successfully \n";
}
// $db->close();
$sql =<<<EOF
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Maxsu', 26, 'Haikou', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Allen', 25, 'Guangzhou', 15000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'Tenny', 23, 'Shanghai', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (4, 'Weiwang', 25, 'Beijing ', 65000.00 );
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Some Records has Inserted successfully \n";
}
// 查询表中的数据
echo " Select Data from company table :<hr/>";
$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 '---------------------------------- ';
}
echo "Operation done successfully\n";
$db->close();

複製代碼

執行上述法式時，會產生以下了局：
PHP若何毗連的SQLite數據庫

更新操作以下PHP顯示代碼若何了利用UPDATE語句來更新記錄，從然後company表中並電子雜誌更新顯示的記實：

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully \n";
}
// 先删除后创建表
$sql = "DROP table company";
$ret = $db->exec($sql);
// 创建表
$sql =<<<EOF
CREATE TABLE if not exists 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 "Yes, Table created successfully \n";
}
// $db->close();
$sql =<<<EOF
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Maxsu', 26, 'Haikou', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Allen', 25, 'Guangzhou', 15000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'Tenny', 23, 'Shanghai', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (4, 'Weiwang', 25, 'Beijing ', 65000.00 );
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Some Records has Inserted successfully \n";
}
// 更新ID=1的薪水为：29999
$sql = 'UPDATE COMPANY set SALARY = 29999.00 where ID=1';
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo $db->changes(), " Record(ID=1) updated successfully \n";
}
// 查询表中的数据
echo " Select Data from company table :<hr/>";
$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 '---------------------------------- ';
}
echo "Operation done successfully\n";
$db->close();

複製代碼

執行上述法式時，會產生以下效果：
PHP若何毗連的SQLite數據庫

刪除操作以下PHP顯示代碼若何了利用DELETE語句刪除任何紀錄，從然後company表中並電子雜誌剩餘顯示的記錄：

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully \n";
}
// 先删除后创建表
$sql = "DROP table company";
$ret = $db->exec($sql);
// 创建表
$sql =<<<EOF
CREATE TABLE if not exists 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 "Yes, Table created successfully \n";
}
// $db->close();
$sql =<<<EOF
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Maxsu', 26, 'Haikou', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Allen', 25, 'Guangzhou', 15000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'Tenny', 23, 'Shanghai', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (4, 'Weiwang', 25, 'Beijing ', 65000.00 );
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Some Records has Inserted successfully \n";
}
// 更新ID小于等于2的数据记录
$sql =<<<EOF
DELETE from COMPANY where ID<=2;
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo $db->changes(), " Record(ID<=2) deleted successfully \n";
}
// 查询表中的数据
echo " Select Data from company table :<hr/>";
$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 '---------------------------------- ';
}
echo "Operation done successfully\n";
$db->close();

複製代碼

執行上述法式時，會產生以下了局：
PHP若何毗連的SQLite數據庫

最後如要列出資料庫內有幾何Table name

<?php
$db = new SQLite3('db/chinhook.db');
$tablesquery = $db->query("SELECT name FROM sqlite_master WHERE type='table';");
while ($table = $tablesquery->fetchArray(SQLITE3_ASSOC)) {
echo $table['name'] . ' ';
}
?>

複製代碼

參考文章
https://www.yiibai.com/sqlite/php-with-sqlite.html
https://stackoverflow.com/questions/17997722/sqlite3-query-to-list-all-tables-in-database-only-shows-one-table

http://www.sqlitetutorial.net/sqlite-tutorial/sqlite-show-tables/

引用自: