retrieve Datetime object from mysql database in php

Question

I have a specific problem regarding the mysql Datetime format to store the date and time together in table, so I have stored values in the table and now I want to retrieve those values and then compare that time with current datetime but things are going horribly wrong. this is what i tried so far..

<?php
    date_default_timezone_set('Asia/Calcutta');
    require_once('connect.php');

    $query="select matchTime from fixture_list where value1='Mumbai'";
    if($result= mysqli_query($con,$query)){
        while($row=mysqli_fetch_assoc($result)){
            print_r($row);
        }
        mysqli_free_result($result);
    }

    //$target = new DateTime('2018-07-27 01:00:00');
    $target = new DateTime($query);
    $now = new DateTime;
    $diff = $target->diff($now);

    if ($target > $now) {
        echo $diff->format('%a days, %h hours, %i minutes to go');
    } 
    else {
        echo $diff->format('%a days, %h hours, %i minutes too late');
    }
?>

My only purpose is to get the datetime value in string propbably which has been stored in the database and pass it to $target variable and then compare with $now, this is the error I m getting "Array ( [matchTime] => 2018-07-27 00:00:00 ) Array ( [matchTime] => 2018-07-27 00:00:00 ) Array ( [matchTime] => 2018-07-28 01:00:00 ) Fatal error: Uncaught exception 'Exception' with message 'DateTime::__construct(): Failed to parse time string (select matchTime from fixture_list) at position 0 (s): The timezone could not be found in the database'"

Nick · Accepted Answer · 2018-07-28 03:21:15Z

1

This line:

$target = new DateTime($query);

should be:

$target = new DateTime($row['matchTime']);

answered Jul 28, 2018 at 3:21

Nick

147k23 gold badges67 silver badges106 bronze badges

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

9 Comments

Vipul Singh Over a year ago

How to use where clause in matchTime inside row??

Nick Over a year ago

I'm not sure what you mean?

Vipul Singh Over a year ago

I mean table has multiple rows , but I want to retrieve Datetime of any perticular row at a time so I will have to apply some constrains like where clause

Nick Over a year ago

Isn't that what you are doing with where value1='Mumbai'? Or perhaps you want something like where matchTime > NOW() - INTERVAL 7 DAY?

Vipul Singh Over a year ago

Ya what I am doing with where value1='mumbai', will this work ??

|

Collectives™ on Stack Overflow

retrieve Datetime object from mysql database in php

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related