使用php 7.4连接本机的sqlite3

环境：

• 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表中的数据：

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