PHP Checking if the current date is before or after a set date

Question

Im pulling a date from a database which is formatted like dd-mm-YYYY  What I want to do is check the current date   if the current date is before the date coming from the database then it needs to print the database date if its after then it needs to print  go ahead   Could anyone point me in the right direction

User · Answer

if strtotime  row  database date     gt  strtotime  now    echo  row  database date    else echo date  d-m-Y      No need to check the hours because if they are on the same day it will show the same date either way

User · Answer

if  strtotime  date   gt  mktime 0 0 0   should do the job

User · Answer

I have used this one and it served the purpose    if  date  lt  date  Y-m-d                       echo  Date is in the past      BR

User · Answer

if  strtotime  database date   gt  strtotime  now

User · Answer

I wanted to set a specific date so have used this to do stuff before 2nd December 2013  if mktime 0 0 0 12 2 2013   gt  strtotime  now             do stuff     The 0 0 0 is midnight  the 12 is the month  the 2 is the day and the 2013 is the year

User · Answer

if strtotime  db date   gt  time        echo  db date    else     echo  go ahead

User · Answer

Use strtotime to convert any date to unix timestamp and compare

User · Answer

Here s a list of all possible checks for  hellip       Did a date pass     Possible ways to obtain the value   date   strtotime   date      date  gt  date   U     date  gt  mktime  0  0  0    date  gt  strtotime   now     date  gt  time    date  gt  abs  intval    SERVER  REQUEST TIME         Performance Test Result  PHP 5 4 7   I did some performance test on 1 000 000 iterations and calculated the average      Ordered fastest to slowest    --------------------- ---------------           method             time         --------------------- ---------------           time           0 0000006732              SERVER        0 0000009131           date  U          0 0000028951          mktime 0 0 0      0 000003906         strtotime  now      0 0000045032      new DateTime  now     0 0000053365     --------------------- ---------------    ProTip  You can easily remember what s fastest by simply looking at the length of the function  The longer  the slower the function is   Performance Test Setup  The following loop was run for each of the above mentioned possibilities  I converted the values to non-scientific notation for easier readability    loops   1000000   start   microtime  true    for    i   0   i  lt   loops   i         date   U     printf            date  U          s       n       rtrim  sprintf     10F     microtime  true   -  start      loops     0         Conclusion  time   still seems to be the fastest

User · Answer

If you are looking for a generic way of doing this via MySQL  you could simply use a SELECT statement  and add the WHERE clause to it   This will grab all fields for all rows  where the date stored in field  date  is before  now    SELECT   FROM table WHERE UNIX TIMESTAMP  date    lt  UNIX TIMESTAMP     Personally  I found this method to be more gentle on newbies in MySQL  since it uses the standard SELECT statement with WHERE to fetch the results  Obviously  you could grab only the fields relevant if you wanted to  by listing them instead of using a wildcard

User · Answer

a MySQL-only solution would be something like this   SELECT IF  UNIX TIMESTAMP  field    gt  UNIX TIMESTAMP     field   GO AHEAD   as  yourdate  FROM  table

[php] PHP Checking if the current date is before or after a set date

Examples related to php