1，新建sqliteManager管理

<?php
class ZYSqliteManager
{

}  

2，設(shè)置數(shù)據(jù)庫屬性及創(chuàng)建單例

 //數(shù)據(jù)庫
private $db;
//單例
static private $zysqlmanger;
//判斷實(shí)例初始化次數(shù)
private  function __construct()
{

}
//單例初始化

/**
 * @return ZYSqliteManager
 */
static  public function  installSql(){
//        var_dump(isset(self::$zysqlmanger));

    //判斷實(shí)例是否初始化
    if (!isset(self::$zysqlmanger)) {

        self::$zysqlmanger = new self();

        $sqlManager = ZYSqliteManager::installSql();
        $sqlManager ->openDataBase();
    }
    return self::$zysqlmanger;

}

//防止被重寫
private  function  __clone()
{
    // TODO: Implement __clone() method.
}

3，打開數(shù)據(jù)庫，默認(rèn)在創(chuàng)建初始化單例時(shí)打開數(shù)據(jù)庫

 //打開數(shù)據(jù)庫
private  function openDataBase(){
    $this->db =  new SQLite3("/Users/xianhongzhang/Desktop/BRServiceDB.db");
    if ($this->db){

    }else{
        echo "fail";
    }
}

4，查詢數(shù)據(jù)庫

//查詢數(shù)據(jù)庫
/*
sqlstr  sql語句
keysArr 字段數(shù)據(jù)
 */
public  function zymanagerquery($sqlStr, $keysArr){

    $searchResult = $this->db->query($sqlStr);

    $arr = array();

//遍歷查詢結(jié)果
    while ($item = $searchResult->fetchArray()){

        $dataDic = array();
        for ($i = 0; $i < count($keysArr); $i ++){
            $key = $keysArr[$i];
            $dataDic[$key] = $item[$key];
        }
        $arr[] = $dataDic;
    };
    return $arr;

}

5，添加刪除修改數(shù)據(jù)庫

//添加 修改 刪除 數(shù)據(jù)
public function zymanagerInserUpDelData($sqlStr){
    //添加數(shù)據(jù)  刪除更新同樣

    $result = $this->db->exec($sqlStr);
    return $result;
}

6，調(diào)用實(shí)例，新建一個(gè)php file作為接口類

  <?php

require_once "../ZYSql/ZYSqlmanager.php";
include "response.php";
$phone = $_GET["phone"];
$password = $_GET["password"];
$resultArr = array();
header('Content-Type:application/json');//這個(gè)類型聲明非常關(guān)鍵
if (!$phone || !$password){
    $resultArr["code"] = 201;
   $resultArr["message"] = "phone or password is nil";
    echo json_encode($resultArr);
  return;
}
$sqlManager = ZYSqliteManager::installSql();
$keysArr = ["id","name","phone","nickname","sign","addr"];
$dataArr = $sqlManager->zymanagerquery("select *from     UserList",$keysArr);
$resultArr["data"] = $dataArr;
$resultArr["code"] = 200;
$resultArr["message"] = "success";
$result = json_encode($resultArr);
echo $result;
  ?>