Fatal error: call to undefined method mysqli :: error ()

Question

I can connect, but when it comes to the prepared statement, this is the error I received. something is wrong?

The code:

// Open connection $db = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE); //check connection if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } // Create statement object $stmt = $db->stmt_init(); // sql statement $sql = "INSERT INTO ch_users ('uid','admin','password','directory','size','format','locationid') VALUES (?, 1, ?, ?, ?, ?, 1)"; // Create a prepared statement $stmt = $db->prepare($sql) or die($db->error()); 

Answer 1

For those who stumbled upon this page.

The error you get from

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

This is because we need to access the error as a variable, not as a function

therefore the correct code

 if(! empty( $mysqli->error ) ){ echo $mysqli->error; // <- this is not a function call error() } 

Hope this helps someone.

Answer 2

My bad, there shouldn't be quotes in sql statements for column fields. Now it works!