使用php 7.4连接本机的sqlite3

痛定思痛。 2023-03-13 06:38 2阅读 0赞

**环境：**

*  phpStorm 2019
 *  php 7.4
 *  sqlite 3.31  
    需配置php.ini，开启sqlite连接。

<?php
    class SQLite extends SQLite3
    { 
        function __construct()
        { 
            $this->open('D:\software\SQLite\sqlite3\testDB.db');
        }
    }
    $db = new SQLite();
    
    $r = $db->query('select * from student');
    while($row = $r->fetchArray()) { 
        var_dump($row);
    }
    $db->close();
    ?>

student表中的数据：  
![在这里插入图片描述][20200512155937858.png]

array(10) {
      [0]=>
      int(1)
      ["ID"]=>
      int(1)
      [1]=>
      string(3) "Tom"
      ["NAME"]=>
      string(3) "Tom"
      [2]=>
      int(18)
      ["AGE"]=>
      int(18)
      [3]=>
      string(3) "男"
      ["GENDER"]=>
      string(3) "男"
      [4]=>
      int(80)
      ["GRADE"]=>
      int(80)
    }
    array(10) {
      [0]=>
      int(2)
      ["ID"]=>
      int(2)
      [1]=>
      string(6) "张三"
      ["NAME"]=>
      string(6) "张三"
      [2]=>
      int(19)
      ["AGE"]=>
      int(19)
      [3]=>
      string(3) "男"
      ["GENDER"]=>
      string(3) "男"
      [4]=>
      int(0)
      ["GRADE"]=>
      int(0)
    }
    array(10) {
      [0]=>
      int(3)
      ["ID"]=>
      int(3)
      [1]=>
      string(4) "lisi"
      ["NAME"]=>
      string(4) "lisi"
      [2]=>
      int(17)
      ["AGE"]=>
      int(17)
      [3]=>
      string(3) "男"
      ["GENDER"]=>
      string(3) "男"
      [4]=>
      int(0)
      ["GRADE"]=>
      int(0)
    }
    array(10) {
      [0]=>
      int(4)
      ["ID"]=>
      int(4)
      [1]=>
      string(6) "wangwu"
      ["NAME"]=>
      string(6) "wangwu"
      [2]=>
      int(16)
      ["AGE"]=>
      int(16)
      [3]=>
      string(3) "男"
      ["GENDER"]=>
      string(3) "男"
      [4]=>
      int(0)
      ["GRADE"]=>
      int(0)
    }

**参考文章：**  
[https://www.cnblogs.com/coolbear/p/3167194.html][https_www.cnblogs.com_coolbear_p_3167194.html]

[20200512155937858.png]: /images/20230312/e59a8f2e4e584f3c97ff35a0386eb597.png
[https_www.cnblogs.com_coolbear_p_3167194.html]: https://www.cnblogs.com/coolbear/p/3167194.html