PHP利用sqlite3查询数据转为json对象到Vue前端中

PHP利用sqlite3查询数据转为json对象到Vue前端中

1. 数据库内容：
   1|1|1|[1,2,3]|1|-48
   2|1|1|[1,2,3]|2|47
   3|1|1|[1,2,3]|1|-4
   4|1|1|[1,2,3]|2|42

2. PHP代码

<?php
   //打开数据库
   class MyDB extends SQLite3
   {
      function __construct()
      {
         $this->open('test.db');
      }
   }
   $db = new MyDB();//创建一个数据库对象
   $sql =<<<EOF
      SELECT * from log1;
EOF;//SQL语句，查询出所有数据
   $ret = $db->query($sql);//执行SQL语句
   $arr = array();//定义一个数组，用于装载数据
   header('Content-Type:application/json');//设置响应体数据类型
   while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
      array_push($arr,$row);//将查询出来数据依次添加到数组中
   }
   echo json_encode($arr,JSON_FORCE_OBJECT); //将json对象化数组
   $db->close();//关闭数据库
?>`

3. 前端利用ajax访问该PHP文件

getAllLog1(){
      this.$http({
        method: "get",
        url: "/getAllog1.php",
      })
        .then(function (response) {     
          console.log(response.data);      
        })
        .catch(function (error) {
          console.log(error);
        });
    }

4. 在控制台打印出结果
   {"0":{"ID":1,"lOG_STATUS":1,"MACHINE_STATUS":1,"MACHINE_ID":"[1,2,3]","MACHINE_MODE":1,"MACHINE_MODE_DATA":-48},"1":{"ID":2,"lOG_STATUS":1,"MACHINE_STATUS":1,"MACHINE_ID":"[1,2,3]","MACHINE_MODE":2,"MACHINE_MODE_DATA":47},"2":{"ID":3,"lOG_STATUS":1,"MACHINE_STATUS":1,"MACHINE_ID":"[1,2,3]","MACHINE_MODE":1,"MACHINE_MODE_DATA":-4},"3":{"ID":4,"lOG_STATUS":1,"MACHINE_STATUS":1,"MACHINE_ID":"[1,2,3]","MACHINE_MODE":2,"MACHINE_MODE_DATA":42}}