Compare date in a table to todays date

Question

Im trying to figure out how can I make an if statement to compare todays date with a date field in a table.

<?php 
    $dayte_today = date('Y-m-d');
    $plannerid = $_GET["plannerid"];

    $sql="SELECT * FROM planner_content WHERE planner_id='$plannerid'";
    $result=mysqli_query($con,$sql)or die(mysqli_error($con));

    // Mysql_num_row is counting table row
    $count=mysqli_num_rows($result);

    if($count>=1){ 
    /* echo "Your id is $userID"; */
        while ($link =  mysqli_fetch_object($result)) {
        echo ''.$link->date.' - '.$link->comment.'' ;
        }

    }
    else {
        echo "No events yet";
    }
?>

I've got it to show results for the moment, but I don't know how to compare the actual date with the date in the table. I tried to use mysqli_fetch_object but I didn'y get it to work.

I would convert all database dates to a unix timestamp using strtotime() and then use time() to get the current time as a timestamp....then compare — The One and Only ChemistryBlob, Sep 09 '14 at 21:46
i dont need time i just want to compare a date such as 09/09/2014 — fmonper1, Sep 09 '14 at 21:58
You are vulnerable to [sql injection attacks](http://bobby-tables.com) — Marc B, Sep 09 '14 at 22:06

Olantobi · Answer 1 · 2014-09-10T00:06:02.803

0

For comparing dates, you can use the combination of date() and strtotime functions

if($count>=1){ 
    /* echo "Your id is $userID"; */
        while ($link =  mysqli_fetch_object($result)) {
        $planned_date = date('Y-m-d', strtotime($link->date));
        /* Do your comparison here */
           $dayte_today - $planned_date;
        }

    }
    else {
        echo "No events yet";
    }

You can also filter from the mysql query using a query like this

SELECT * FROM planner_content WHERE planner_id='$plannerid' AND date < curdate();

edited Sep 10 '14 at 00:06

answered Sep 09 '14 at 22:11

Olantobi

869
1
8
16

i want it in the if function , to "echo" only the past dates – fmonper1 Sep 09 '14 at 22:52
In that case, you can just filter from the sql query. Check the update to my answer – Olantobi Sep 10 '14 at 00:07

score 0 · Answer 2 · answered Sep 09 '14 at 22:59

0

Why not compare dates using mysql's built-in date functions?

Add a column to your select statement that uses datediff() to return a number that you can use in your application logic.

answered Sep 09 '14 at 22:59

Adrian J. Moreno

14,350
1
37
44

Compare date in a table to todays date

2 Answers2