Php call to member function query() on a non-object error

Question

I'm using mysqli for a function, and I'm getting an error, Fatal error: Call to a member function query() on a non-object in /home/u250000297/public_html/forum/system/db.php on line 46 I've tried different things, but I just get different errors, what am I doing wrong and where is my error?

Code lines 45-51:

function fetch($query) {
    $sql = $mysqli->query($query);
    $result =  $sql->fetch_array(MYSQLI_BOTH);
    return $result;
    $sql->free();

}

Here's my previous attempt and error : Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/u250000297/public_html/forum/system/db.php on line 46 Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/u250000297/public_html/forum/system/db.php on line 47 Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/u250000297/public_html/forum/system/db.php on line 46 Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/u250000297/public_html/forum/system/db.php on line 47

Code, lines 45-51:

 function fetch($query) {
    $sql = mysqli_query($mysqli, $query);
    $row = mysqli_fetch_array($sql, MYSQLI_BOTH);
    return $row;
    mysqli_free_result($row);

}

Connection:

$mysqli = mysqli_connect($this->host,$this->username,$this->password);
    mysqli_select_db( $mysqli,$this->database );
    if ($mysqli->connect_error) {
trigger_error('Database connection failed: '  . $mysqli->connect_error, E_USER_ERROR);

}

In my mail.php file $mail = $db->fetch("SELECT * FROM " . $prefix . "_mail WHERE id = '$mail_id'"); and $account = $db->fetch("SELECT * FROM accounts WHERE email = '$email' AND lpip = '$lpip'"); — user116046
– user116046, Commented Jan 29, 2014 at 7:10

Axel Amthor · Accepted Answer · 2014-01-29 07:13:51Z

1

Either you need to define $mysqli as global or pass it as an argument. After a return, no statement will be executed (mysqli_free).

Global:

function fetch($query) {
    global $mysqli;

    $sql = $mysqli->query($query);
    $result =  $sql->fetch_array(MYSQLI_BOTH);


    return $result;


}

Parameter (and even better):

function fetch($myslqi, $query) {

    $sql = $mysqli->query($query);
    $result =  $sql->fetch_array(MYSQLI_BOTH);


    return $result;


}

answered Jan 29, 2014 at 7:13

Axel Amthor

11.1k1 gold badge28 silver badges45 bronze badges

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

Comments

suchitra nair · Accepted Answer · 2014-01-29 07:33:33Z

0

Points to debug are

1) Is the connection to the database getting established?

2) Are your query strings correct?

Call to a member function query() on a non-object and Warning: mysqli_query() expects parameter 1 to be mysqli means that the $mysqli is null or isn't initialized properly. To get more information check the mysql error logs.

edited Jan 29, 2014 at 7:33

answered Jan 29, 2014 at 7:18

suchitra nair

5557 silver badges13 bronze badges

1 Comment

user116046 Over a year ago

Yes, the connection to the database is established, and I'm pretty sure my strings are correct

Collectives™ on Stack Overflow

Php call to member function query() on a non-object error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related