PHP compare dates

Question

ok basically I am trying to compare today date with a database date and determine if today date is > then one of the dates in database. but no matter what date is picked up from datatabase < or > compared to today the result is always true.

Could some one pleas have a look at my code and point out any potential wrongdoings please

PHP

$timestamp = date("Y-m-d");

$sql="SELECT enddate FROM campaigns WHERE id=".$data['camp'];
    $query = mysqli_query($db, $sql);

while($result = mysqli_fetch_assoc($query)){
    if($timestamp > $result){

        echo "<script type='text/javascript'>alert('This Workshop Has Expired');</script>";
        exit;
    }else{

        echo "<script type='text/javascript'>alert('Thank You For Registering');</script>";
        exit;
    }
}

In your database, how do you store "enddate"? You should be using timestamps for this really, and looking at how you make you $timestamp var I'm guessing you dont. — James
– James, Commented Dec 11, 2013 at 15:33
if($timestamp > $result){ ?? how does php know it is a "date" ? convert to integer using strtotime and then verify. in real life applications use datetime class. — Stewie
– Stewie, Commented Dec 11, 2013 at 15:34

Wilq · Accepted Answer · 2013-12-11 15:39:36Z

3

Try to for example :

$var = "2010-01-21 00:00:00.0"//date from DB
strtotime($var);

It turns it into a time value, and:

time() - strtotime($var);

gives you the seconds since $var

To check if $var has been within the last day try:

if((time()-(60*60*24)) < strtotime($var))

That's all! :)

edited Dec 11, 2013 at 15:39

Wilq

2,2674 gold badges33 silver badges38 bronze badges

answered Dec 11, 2013 at 15:34

sergio

5,2607 gold badges27 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tomazi Over a year ago

and yes i have tried var_dump both formats looked the same as well as i have tried strtotime the problem seemd to be in my if statment, but thank you for trying to help

Félix Adriyel Gagnon-Grenier · Accepted Answer · 2013-12-11 15:49:56Z

1

if($timestamp > $result['enddate']){

$result is an array, as called by $result = mysqli_fetch_assoc($query). mysqli_fetch_assoc returns an array with the column name of your row as keys and the content of each field as value.

edited Dec 11, 2013 at 15:49

answered Dec 11, 2013 at 15:34

Félix Adriyel Gagnon-Grenier

8,93510 gold badges58 silver badges69 bronze badges

1 Comment

Tomazi Over a year ago

owww loool it works but when i did var_dump on each variable $timestamp and $results the numbers looked correct and corresponding both to database and today date, sorr if it is a lame question but could you explain to me why i needed to add $result['enddate']

JustAPirate · Accepted Answer · 2013-12-11 15:38:31Z

1

The problem is that the "enddate" from your database isn't a number, it's a string.

You should convert it to numbers:

$now = time();
$sql="SELECT enddate FROM campaigns WHERE id=".$data['camp'];
$query = mysqli_query($db, $sql);
while($result = mysqli_fetch_assoc($query)){
    $db = strtotime($result);
    if($now > $db) {
        // expired
        echo "<script type='text/javascript'>alert('This Workshop Has Expired'); </script>";
        exit;
    }
    else {
        // not expired
        echo "<script type='text/javascript'>alert('Thank You For Registering');</script>";
        exit;
    }
}

answered Dec 11, 2013 at 15:38

JustAPirate

1645 bronze badges

Collectives™ on Stack Overflow

PHP compare dates

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related