Binding parameters with MySQLi throws "undefined method" error?

Question

I have this code:

$dateInt = intval($date);
$stmt = $this->db->prepare('SELECT * FROM establecimientos WHERE timestamp > ?');
$stmt->bindParam($dateInt);
$stmt->execute();

And I'm receiving this error:

Call to undefined method mysqli_stmt::bindParam()

I'm sure there's something terribly wrong, but I cannot certainly know!

Answer 1

You have 2 mistakes. The bind_param method requires a datatype hint as the first parameter and it is bind_param and not bindParam

$stmt->bind_param('i', $dateInt);

Check the Documentation