How can the current date be retrieved from a MySQL database in PHP?

To retrieve the current date from a MySQL database in PHP, you can use the SQL function `CURDATE()` in your query. This function returns the current date in the format 'YYYY-MM-DD'. You can then fetch the result from the query and use it as needed in your PHP code. 

<?php
// Connect to the database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Query to retrieve the current date
$query = "SELECT CURDATE() AS current_date";
$result = mysqli_query($connection, $query);

// Fetch the result
$row = mysqli_fetch_assoc($result);
$currentDate = $row['current_date'];

// Output the current date
echo "The current date is: " . $currentDate;

// Close the connection
mysqli_close($connection);
?>

Keywords

PHP MySQL date retrieval database query current date

Related Questions