Answers for "how to retrieve data from database based on date in php"

php date from mysql and date

$phpdate = strtotime( $mysqldate );
$mysqldate = date( 'Y-m-d H:i:s', $phpdate );

how to get date with php

<?php

// Use date
  
echo date("F j, Y, g:i a");                   // September 23, 2021, 3:56 pm
echo date("m.d.y");                           // 05.20.33
echo date("j, n, Y");                         // 10, 3, 2001
echo date("Ymd");                             // 20210616
echo date('h-i-s, j-m-y, it is w Day');       // 06-17-19, 10-03-01, 1631 1618 6 Satpm01
echo date('\i\t \i\s \t\h\e jS \d\a\y.');     // It is the 10th day.
echo date("D M j G:i:s T Y");                 // Thur Oct 14 17:16:18 MST 1999
echo date('H:m:s \m \i\s\ \t\h\e\ \m\o\n\t\h'); // 06:11:04 m is the minute
echo date("H:i:s");                           // 09:19:30
echo date("Y-m-d H:i:s");                     // 2012-09-14 04:03:02 Mysql format

?>