1 reply to this topic

[Rohan21]

Well, i have a problem in prepared statement with 'bind_param'

My queries looks like this

<?php

$result = $db_connection->prepare("update users set date = ? where email= ?");

    $result->bind_param("ss", $mysqlDateString,$email));

    $result->execute();


?>

Here $mysqlDateString is the date variable
When i execute this, it gives error

Quote

Fatal error: Call to a member function bind_param() on a non-object in F:\xampp\htdocs\Login.php on line 21

Here what should be the variable type of date. I have tried many things but nothing works.

[Orjan]

it says that bind_param fails as $result is a non-object, that means that your prepare statement failed and returned null.