Using Mysqli bind_param with date and time columns?

Question

How do you insert data into a MySQL date or time column using PHP mysqli and bind_param?

Answer 1

Like any other string

$stmt = $mysqli->prepare('insert into foo (dt) values (?)'); $dt = '2009-04-30 10:09:00'; $stmt->bind_param('s', $dt); $stmt->execute();