SQL query TIMESTAMPDIFF with php not working

Question

I try to take a date and do countdown untill that day like following:

The date i want to countdown to: 2016-05-1 00:00:00

Then i want to calculate the diff between the date and now so i can do countdown timer.

I have this:

date_default_timezone_set("Asia/Jerusalem");

if ($result = $db->query("SELECT TIMESTAMPDIFF(SECOND, NOW(), 2016-05-1 00:00:00)")) {

    while($row = $result->fetch_array()) {
        $currentTimeLeft= $row['TIMESTAMPDIFF(SECOND, NOW(), 2016-05-1 00:00:00)']; 
    }

    echo json_encode($currentTimeLeft);
}

I dont understand why this returning empty. What is wrong here?

This is similar, I wonder whether your question is close enough to be dupe: stackoverflow.com/questions/15877121/… — Pavel V.
– Pavel V., Commented Apr 28, 2016 at 10:01

Minesh Patel · Accepted Answer · 2016-04-28 10:10:38Z

3

I see quote issue in your query

try this

if($result = $db->query("SELECT TIMESTAMPDIFF(SECOND,NOW(),'2016-05-1 00:00:00') as datediff")) {

        while($row = $result->fetch_array()) {
                $currentTime = $row['datediff']; 
        }

 echo json_encode($currentTime);

I have added an alias "datediff" to the result column as well

edited Apr 28, 2016 at 10:10

answered Apr 28, 2016 at 10:04

Minesh Patel

5411 gold badge6 silver badges14 bronze badges

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

1 Comment

RiggsFolly Over a year ago

You might explain that you have also added an alias to give the result column an easily usable name try this is not helpful to others that may read your answer at a later date

Aju John · Accepted Answer · 2016-04-28 10:03:44Z

0

you are missing quotes in the query

if ($result = $db->query("SELECT TIMESTAMPDIFF(SECOND, NOW(), '2016-05-1 00:00:00') as t")) {

answered Apr 28, 2016 at 10:03

Aju John

2,2441 gold badge14 silver badges27 bronze badges

Collectives™ on Stack Overflow

SQL query TIMESTAMPDIFF with php not working

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related