How to Insert Date and Time Data into MySQL using mysqli bind_param?

Using MySqli bind_param to Insert Date and Time Data

Inserting date and time values into MySQL columns using PHP mysqli and bind_param involves treating them like any other string. Here's how to do it:

1. Prepare the Statement:

$stmt = $mysqli->prepare('insert into foo (dt) values (?)');

2. Bind the Date or Time Value:

Use the 's' format specifier to bind a string. For example, for a date-time value of '2009-04-30 10:09:00':

$dt = '2009-04-30 10:09:00';
$stmt->bind_param('s', $dt);

3. Execute the Statement:

$stmt->execute();

By following this approach, you can insert date and time values into MySQL columns efficiently using mysqli and bind_param.

The above is the detailed content of How to Insert Date and Time Data into MySQL using mysqli bind_param?. For more information, please follow other related articles on the PHP Chinese website!