xxxxxxxxxx
<?php
// Assuming you have established a MySQL database connection
// Query to retrieve the current date and time from MySQL
$query = "SELECT NOW() AS current_datetime";
$result = mysqli_query($connection, $query);
// Check if the query was successful
if ($result) {
// Fetch the result row
$row = mysqli_fetch_assoc($result);
// Retrieve the current datetime
$datetime = $row['current_datetime'];
// Format the datetime as desired (e.g., "Y-m-d H:i:s")
$formattedDatetime = date('Y-m-d H:i:s', strtotime($datetime));
// Output the formatted datetime
echo "Formatted Datetime: " . $formattedDatetime;
} else {
// Handle query error
echo "An error occurred.";
}
// Remember to close the database connection when you're done
mysqli_close($connection);
?>
xxxxxxxxxx
date("D M j G:i:s T Y")."<br>"; // Sat Mar 22 17:16:18 MST 2001
date('H:m:s \m \i\s\ \m\o\n\t\h')."<br>"; // 18:03:18 m is month
date("H:i:s")."<br>"; // 18:16:18
date("Y-m-d H:i:s")."<br>"; // 2022-03-11 18:16:18 (MySQL DATETIME format)
date("j F, Y, g:i a")."<br>"; // 11 March, 2022, 6:16 pm
date("m.d.y")."<br>"; // 03.11.01
date("j, n, Y")."<br>"; // 11, 3, 2001
date("Ymd")."<br>"; // 20010310
date('h-i-s, j-m-y, it is w Day')."<br>"; // 02-12-18, 10-03-01, 1631 1618 6 Satpm01
date('\i\t \i\s \t\h\e jS \d\a\y.')."<br>"; // it is the 15th day.
xxxxxxxxxx
$myDateTime = DateTime::createFromFormat('Y-m-d', $dateString);
$newDateString = $myDateTime->format('d-m-Y');
xxxxxxxxxx
date_default_timezone_set('asia/karachi'); // set timezone
$timestamp = $row['last_login']; // get current epoch time
$format = "Y-m-d h:i:s a"; // format for date output
$formatted_date = date($format, $timestamp); // convert timestamp to format
print($formatted_date);
xxxxxxxxxx
$fecha_format = date("d/m/Y", strtotime('2022-12-24'));
// salida: 24/12/2022
xxxxxxxxxx
<?php
// Author: Sazid Hasan Milon
// https://shmilon.com
// https://fiverr.com/shmilon
// Assuming $row['start_date'] contains the date from the database
$databaseDateTime = $row['start_date'];
// Create a DateTime object from the database date
$dateTime = new DateTime($databaseDateTime);
// Format the date as dd/mm/year
$dateFormatted = $dateTime->format('d/m/Y');
// Format the time as 12:30 pm
$timeFormatted = $dateTime->format('h:i a');
// Output the formatted date and time
echo "Formatted Date: $dateFormatted<br>";
echo "Formatted Time: $timeFormatted";
?>