php compare current date with dates stored in database

Question

I am trying coding a php script where i want to extract a date field from a database table,store this date compare it with todays. To see if the data. from database has passed or not compared to todays date.

the code i have written for this functionality looks like its not working
I think i am getting the date() format wrong.
I am not to sure about the logic if statments.

php

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

while($info = mysqli_fetch_assoc($result)){
    if(date("Y-m-d") > $result){
        exit;
        echo "Success";
    }
    elseif(date("Y-m-d") < $result){
        return true;
        echo "Failure";
    }
}

웃웃웃웃웃 · Accepted Answer · 2013-12-04 09:54:35Z

2

Use strtotime()

while($info = mysqli_fetch_assoc($result)){
    if(strtotime(date("Y-m-d")) > strtotime($result)){
        exit;
        echo "Success";
    }
    elseif(strtotime(date("Y-m-d")) < strtotime($result)){
        return true;
        echo "Failure";
    }
}

answered Dec 4, 2013 at 9:54

웃웃웃웃웃

12k15 gold badges63 silver badges95 bronze badges

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

Comments

Ramesh · Accepted Answer · 2013-12-04 09:52:50Z

1

You have to do:

if(date("Y-m-d") > $info['enddate']) {

answered Dec 4, 2013 at 9:52

Ramesh

4,3032 gold badges19 silver badges24 bronze badges

Comments

kba · Accepted Answer · 2013-12-04 09:54:37Z

1

Youl could just let MySQL worry about it.

SELECT DATEDIFF(NOW(),enddate) FROM campaigns WHERE id=".$data['camp']

That will return the number of days between the two dates. See the manual for DATEDIFF.

answered Dec 4, 2013 at 9:54

kba

19.5k6 gold badges65 silver badges90 bronze badges

Comments

flicher88 · Accepted Answer · 2013-12-04 09:57:09Z

0

You can use below query :

$sql="SELECT (CASE WHEN DATE(NOW()) > enddate THEN 'success' ELSE 'failed' END) AS mystatus FROM campaigns WHERE id=".$data['camp'];

Then you just need to call mystatus column from the query.

answered Dec 4, 2013 at 9:57

flicher88

352 silver badges7 bronze badges

Comments

Kishan · Accepted Answer · 2017-10-05 10:51:45Z

0

I spend lot of time to compare only dates and i found a solution like this

Always set format like date('Y-m-d')

$dateTo='2016-08-07';
if(date("Y-m-d", strtotime($dateTo)) > date('Y-m-d')){
   echo 'yes';
}else{
   echo 'no';
}

answered Oct 5, 2017 at 10:51

Kishan

1,21014 silver badges26 bronze badges

Collectives™ on Stack Overflow

php compare current date with dates stored in database

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Related