PHP OOP 和 MySQLi 连接 = fatal error :调用未定义的方法 mysqli::arrayQuery()

Question

请告诉我我做错了什么？以及如何更好地与基地合作？连接有效，但我看不到来自基地的信息。我只是得到:

Fatal error: Call to undefined method mysqli::arrayQuery()

我不明白如何修复它，谷歌也没有帮助。

<?php
class Proc{
    protected $DB;
    function __construct(){
        $this->DB=new mysqli('localhost', 'user', 'password', 'basename');
        $this->DB->query("set names utf8");}
    function __destruct(){unset($this->DB);}
    function GetAll(){
        $sql="SELECT * FROM users";
        $result = $this->DB->arrayQuery($sql, SQLITE_ASSOC);
        return $result;}
}

$Yo = new Proc();

$users = $Yo->GetAll();
echo "All users: ".count($users);
foreach ($users as $user){
    $id = $user["ID"];
    $n = $user["Name"];
    echo "{$id} - {$n}<br/>";}
?>

稍作修改，一切正常!感谢大家!

<?php
class Proc{
    protected $DB;
    function __construct(){
        $this->DB=new PDO("mysql:host=localhost;dbname=basename", user, password);
        $this->DB->query("set names utf8");}
    function __destruct(){unset($this->DB);}
    function GetAll(){
        $sql="SELECT * FROM users";
        $result = $this->DB->query($sql);
        return $result;}
}
$Yo = new Proc();
$users = $Yo->GetAll();
foreach ($users as $user){
    $id = $user["ID"];
    $n = $user["Name"];
    echo "{$id} - {$n}<br/>";}
?>

Answer 1

您使用的是什么数据库？ SQLite 还是 mysql ?

因为根据 PHP DOCS , 我猜 arrayQuery 函数只能用于 SQLite 数据库