prepare function used wrong?

Question

anyone knows why i get this error:

Call to a member function prepare() on a non-object

for this code-snippet:

public function check_availability($dataID) {

    $query = "SELECT dump FROM dumps WHERE dump = '".$dataID."'";
    if ($stmt = $mysqli->prepare($query)) {

        $stmt->execute();

        if($stmt->rowCount() > 0) {
            return FALSE;
        } else {
            return TRUE;
        }

        $stmt->close();
    }
}

especially for this line:

if ($stmt = $mysqli->prepare($query)) {

the variable $mysqli cant be wrong because of:

$mysqli = new mysqli($config['sql_hostname'], $config['sql_username'], $config['sql_password'], $config['sql_database']);

UPDATE:

i am calling this script in browser:

define('SECURE', true);

include "storescripts/connect_to_mysql.php";

require 'AvailabilityChecker.php';

$config = array('DB' => $mysqli,
                'Table' => 'dumps',
                'Row' => 'dump',
                'Output' => true,
                'Format' => 'JSON');

$availabilityChecker = new AvailabilityChecker($config);

if($availabilityChecker->check_availability($_POST['dataID'])) {
    echo "ok";
} else {
    echo "not ok";
}

$mysqli is defined in "connect_to_mysql.php" so?

Where do you define `$mysqli` in [the scope](http://php.net/manual/en/language.variables.scope.php)? — PeeHaa, Nov 23 '13 at 16:18
check this http://stackoverflow.com/questions/4463441/call-to-a-member-function-prepare-on-a-non-object-php-help — vijaykumar, Nov 23 '13 at 16:20
No you have a look at one of the many many duplicates @user2999787 — PeeHaa, Nov 23 '13 at 16:24

Patato · Answer 1 · 2013-11-23T16:32:13.863

0

you should create an Object of mysqli and check the result

$mysqli = new mysqli("localhost", "username", "password", "dbname");
if(!$mysqli)
{
   die("can not access the db");
}

then you can use the function

$mysqli->prepare($query)

edited Nov 23 '13 at 16:32

answered Nov 23 '13 at 16:19

Patato

1,464
10
12

ehm i created an object already, dont u see? – user2999787 Nov 23 '13 at 16:23
before using $mysqli you should check it by using if($mysqli){} – Patato Nov 23 '13 at 16:30

prepare function used wrong?

1 Answers1