//打开db.db表

$db = new SQLite3('db.db');

if(!$db){

   echo $db->lastErrorMsg();

   exit;

} else {

}

$keys = array();

$students = array();

//查询

$ret = $db->query("SELECT * from student limit 50");

//将结果保存到新数组

while($row = $ret->fetchArray(SQLITE3_ASSOC) ){

   $keys = array_keys($row);

   //转换列值,防止出现乱码

   foreach($keys as $key){

      $row[$key] = mb_convert_encoding($row[$key],"gb2312","utf-8");

   }

   //添加到新数组

   array_push($students, $row);

}

$db->close();

print_r($students);