How to Convert PHP Dates to MySQL Format for Database Storage?

Converting PHP Date to MySQL Format

In programming, you may encounter situations where you need to convert a date from PHP format to MySQL format for storage in a database. This conversion is essential to ensure compatibility with MySQL's specific date and time representation.

To address this issue, you can utilize the following code:

<code class="php">$date = mysql_real_escape_string($_POST['intake_date']);</code>

Assuming you have a MySQL column defined as DATE type, you can convert the PHP date to MySQL using the following code:

<code class="php">$date = date('Y-m-d', strtotime(str_replace('-', '/', $date)));</code>

This code replaces any dashes (-) in the date string with forward slashes (/), creating a date string in the format "YYYY-MM-DD" compatible with MySQL's DATE type.

Alternatively, if your MySQL column is defined as DATETIME type, you can use this code instead:

<code class="php">$date = date('Y-m-d H:i:s', strtotime(str_replace('-', '/', $date)));</code>

This code not only converts the date to the correct format for MySQL's DATETIME type but also includes the time component in the conversion.

Remember that strtotime() requires the date string to be in a specific format with slashes (/) instead of dashes (-). If your date string is not in this format, you can use the following code to convert it:

<code class="php">$date = preg_replace('#(\d{2})/(\d{2})/(\d{4})\s(.*)#', '-- ', $date);</code>

This code extracts the date components (day, month, year, and time) and reassembles them in the format "YYYY-MM-DD HH:MM:SS" suitable for MySQL's DATETIME type.

The above is the detailed content of How to Convert PHP Dates to MySQL Format for Database Storage?. For more information, please follow other related articles on the PHP Chinese website!