Prepared statement problem

[Arjun21]

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

My queries looks like this

PHP Code:

<?php
$result = $db_connection->prepare("update users set date = ? where email= ?");
    $result->bind_param("s", $mysqlDateString));
    $result->bind_param("s", $email);
    $result->execute();

?>

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

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.

[Fou-Lu]

Given the error you are missing a lot of code here.
This isn't the right way to use bind_param though. That should be $result->bind_param("ss", $mysqlDateString, $email);. If $result is not an object as its complaining about here, this indicates that the prepare has failed. $db_connection appears to me to be a MySQLi object, otherwise the prepare would have fatal error on it as well.
You can try adding an error in there.

PHP Code:

if ($result = $db_connection->prepare('...'))
{
    // ...
}
else
{
    printf('Error: %s', $db_connection->error);
}