(Fatal error: Call to a member function bind_param() on a non-object)

php mysqli sqlbindparameter
Jonas Franz picture Jonas Franz · Sep 20, 2013 · Viewed 22.6k times · Source

I get an error with this text:(sorry for my bad english I am from germany!)

Error:Fatal error: Call to a member function bind_param() on a non-object in /users/ftf/www/ccache.php on line 44

A part of the Code from ccache.php

     // Neues Datenbank-Objekt erzeugen
    $db = @new mysqli( 'localhost', 'ftf', '***', 'ftf' );
    // Pruefen ob die Datenbankverbindung hergestellt werden konnte
    if (mysqli_connect_errno() == 0)
    {
        $sql = "INSERT INTO cache
('name', 'user', 'veroefentlichung', 'beschreibung', 'FTFcode', 'STFcode', 'TTFcode', 'type', 'lat', 'lon', 'address', 'link')
VALUES ('?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?')";
$eintrag = $db->stmt_init();
$eintrag = $db->prepare( $sql );

        $eintrag->bind_param($titel, $user, $datum, $desc, $FTF, $STF, $TTF, $type, $Lat, $Lon, $shortdesc, $genlink); // line 44

        $eintrag->execute();
        // Pruefen ob der Eintrag efolgreich war
        if ($eintrag->affected_rows == 1)
        {
            echo 'Der neue Eintrage wurde hinzugefügt.';
        }
        else
        {
            echo 'Der Eintrag konnte nicht hinzugefügt werden.';
        }
    }

Answer

Sammitch picture Sammitch · Sep 20, 2013

Check your return values!

Bad: $eintrag = $db->prepare( $sql )

Good:

if( ! $eintrag = $db->prepare( $sql ) ) {
  echo 'Error: ' . $db->error;
  return false; // throw exception, die(), exit, whatever...
} else {
  // the rest of your code
}

The same goes for $eintrag->execute();.

Also, the problem is probably the fact that you're wrapping your ? placeholders in quotes. Don't do that. MySQLi does that for you.

Related questions

How to insert the record with MySQL NOW() function in MySQLi with bind_param?

I need to execute this mysql query in MySQLi PDO with bind parametr in PHP: mysql_query("INSERT INTO `posts` (post_name,publish_date) VALUES ($post_name,NOW()) ") I use the script like this, but it doesn't insert publish_date …

Read More
What is the type of NULL in mysqli bind_param?

I am trying to bind params to a INSERT INTO MySQLi prepared statement if that variable exists, otherwise insert null.Then i know type variable i corresponding variable has type integer d corresponding variable has type double s corresponding variable …

Read More
mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in

I'm have some trouble checking if a Facebook User_id already exists in my database (if it doesn't it should then accept the user as a new one and else just load the canvas application). I ran it on my …

Read More