Can not compare two date using PHP

Question

I have an issue while comparing two date inside if condition. I am providing my code below.

$erresult = mysqli_fetch_array($qrylast);
$ticket = $erresult['ticket_id'];
if ((date("Y-m-d") == $erresult['date'])) {
    $id = sprintf("%03d", $ticket++);
    $fields = array("date", "ticket_id ");
    $tablename = "db_ticket";
    $values = array(date("Y-m-d"), $id);
    $id1 = db_insert($tablename, $values, $fields);
    if ($id1) {
        $ticket_id = 'W1' . date("Ymd") . $id;
    }
} else {
    $id = '001';
    $fields = array("date", "ticket_id ");
    $tablename = "db_ticket";
    $values = array(date("Y-m-d"), $id);
    $id1 = db_insert($tablename, $values, $fields);
    if ($id1) {
        $ticket_id = 'W1' . date("Ymd") . $id;
    }
}

Here I need to compare today's date with date save inside database. My saved date inside database datatype is also date but here always else part is executing. In my code I have one condition (date("Y-m-d")==$erresult['date']) and this condition is never executing even two date are same.

If you're sure that `date("Y-m-d")` and `$erresult['date'])` are the same, you've to check your script call: are you sure that your posted code will be executed? — schellingerht, Jan 22 '16 at 05:18
i am getting `2016-01-22` while print $erresult['date'] and its datatype is date in db. — satya, Jan 22 '16 at 05:20
Then your code is working fine and also your code is working for me. — Ramalingam Perumal, Jan 22 '16 at 05:23

score 2 · Accepted Answer · edited May 23 '17 at 11:52

2

Try

if(strtotime(date("Y-m-d")) == strtotime($erresult['date']))

follow :- How to compare two dates in php

edited May 23 '17 at 11:52

Community

1
1

answered Jan 22 '16 at 05:05

Rakesh Sharma

13,680
5
37
44

I have also datatype as date in DB. – satya Jan 22 '16 at 05:08
check updated answer – Rakesh Sharma Jan 22 '16 at 05:10
I used your answer but still issue is same. – satya Jan 22 '16 at 05:17
its result is one while i checked doing echo. – satya Jan 22 '16 at 05:18

score 2 · Answer 2 · edited Jan 22 '16 at 05:16

2

You can use the strtotime() function to compare the two dates e.g

if(strtotime(date("Y-m-d")) == strtotime(date("Y-m-d",$erresult['date'])))

edited Jan 22 '16 at 05:16

Rakesh Sharma

13,680
5
37
44

answered Jan 22 '16 at 05:11

Dilip Kale

71
7

Can not compare two date using PHP

2 Answers2