How can I ensure that dates are correctly stored and retrieved from a MySQL database in PHP?

When storing dates in a MySQL database using PHP, it is important to use the correct date format and data type to ensure accurate storage and retrieval. One common way to achieve this is by using the MySQL DATE or DATETIME data types and formatting dates in the 'Y-m-d' or 'Y-m-d H:i:s' format respectively. Additionally, it is recommended to use prepared statements to prevent SQL injection vulnerabilities. 

// Example code snippet for storing and retrieving dates in a MySQL database

// Connect to MySQL database
$mysqli = new mysqli("localhost", "username", "password", "database");

// Prepare a SQL statement to insert a date into the database
$date = date('Y-m-d H:i:s');
$stmt = $mysqli->prepare("INSERT INTO table_name (date_column) VALUES (?)");
$stmt->bind_param("s", $date);
$stmt->execute();

// Prepare a SQL statement to retrieve dates from the database
$result = $mysqli->query("SELECT * FROM table_name");
while ($row = $result->fetch_assoc()) {
    $stored_date = $row['date_column'];
    echo "Stored Date: " . $stored_date . "\n";
}

// Close database connection
$mysqli->close();

Keywords

MySQL date format PHP date function SQL queries data retrieval

Related Questions