CODEWITHSUNDEEP
phpmysqlsql
Rav_g
Rav_g

Reputation: 123

SQL query TIMESTAMPDIFF with php not working

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?

Upvotes: 0

Views: 249

Answers (2)

Minesh Patel
Minesh Patel

Reputation: 541

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

Upvotes: 3

Aju John
Aju John

Reputation: 2244

you are missing quotes in the query

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

Upvotes: 0

Related Questions