PHP OOP and MySQLi connection = Fatal error: Call to undefined method mysqli::arrayQuery()

Question

Please tell me what I've done wrong? And how to work with base better? Connection works, but I can not see information from base. I just get:

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

I can't understand how to fix it, Google didn't help either.

<?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/>";}
?>

A little fix and all work perfect! Thanks to all!

<?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/>";}
?>

Call to undefined method mysqli::arrayQuery() - I mean error message is cear, isn't? — pavel
– pavel, Commented Jun 4, 2015 at 6:49
Checking php.net/manual/en/book.mysqli.php reveals that arrayQuery is not available (the mysqli class does not have such a method). Also, it might be better to switch to PDO — Alex Tartan
– Alex Tartan, Commented Jun 4, 2015 at 6:53

Abhinav · Accepted Answer · 2015-06-04 06:50:43Z

1

What database are you using? SQLite or mysql ?

Because as per the PHP DOCS, I guess the function arrayQuery can be used only for SQLite databases

answered Jun 4, 2015 at 6:50

Abhinav

8,17812 gold badges51 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Baaakaaa Over a year ago

MySQL 5.5.37, and connect as "mysqli". So this is not SQLite?

Abhinav Over a year ago

Nope...thats mysql database you are having, and since you have initialized "mysqli", the mysqli class does not have that method

Collectives™ on Stack Overflow

PHP OOP and MySQLi connection = Fatal error: Call to undefined method mysqli::arrayQuery()

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related