php - binding parameters using the NOW function -

in mysql, how bind parameters when using now() function?

$stmt = $conn->prepare("insert myguests (firstname, lastname, date) values (?, ?, ?)"); $stmt->bind_param("sss", $firstname, $lastname, now()); 

this doesn't work.

now() not parameter of query. put this:

$stmt = $conn->prepare("insert myguests (firstname, lastname, date) values (?, ?, now())"); $stmt->bind_param("sss", $firstname, $lastname);