Datetime NOW PHP mysql (+ PDO variant)

mysql, pdo, php

Solution

Because nobody has explicitly answered the question, I'll add the correct answer for the sake of completeness.

$stmt = $pdoDb->prepare('INSERT INTO tablename (id, value, time_created) VALUES (:id, :value, NOW())');
// either bind each parameter explicitly 
$stmt->bindParam(':id', $id); // PDOStatement::bindValue() is also possibly
$stmt->bindParam(':value', $value);
$stmt->execute();
// or bind when executing the statement
$stmt->execute(array(
    ':id'    => $id,
    ':value' => $value
));

Problem

Thanks for looking. All helpful answers/comments are up voted. In php, you can use NOW() like this: ``` mysql_query("INSERT INTO tablename (id, value, time_created) VALUES ('{$id}', '{$value}', NOW())"); ``` How can I do the same thing in PDO. When I bind like this, I get an error: ``` $stmt->bindParam(':time_added', NOW(), PDO::PARAM_STR); ``` Is it the PDO:PARAM_STR?

Original source