how to display dates in future through PDO

elemelas

does anybody know how can I get NOW() working through PDO layer ? it works perfectly with normal mysql, but doesn't with PDO ...

$query = $conn->prepare('SELECT * FROM events WHERE date>NOW() ORDER BY date ASC');

elemelas

...

NogDog

I'm not real familiar with PDO, but I think I recall someone else having a problem with that sort of thing in a PDO prepared statement. You may need to use PDO::query() instead, which should be OK in this case since there are no inputs to bind.

elemelas

would there be any similar method to that ? I don't really care about the method, all I want is the result. I tried this:

$now = strtotime("now"); 

 $query = $conn->prepare('SELECT * FROM events WHERE date > :now ORDER BY date ASC'); 
$query -> bindValue(':now', $now);

but it doesn't work ..

NogDog

What I was suggesting to try is:

$result = $conn->query('SELECT * FROM events WHERE date>NOW() ORDER BY date ASC');
$events = $result->fetch_all();

elemelas

yeah, but this is only example, I will definetely want to use bound parameters in query.

NogDog

Well, if no PDO user here comes up with another solution, you could always create the query as a stored procedure in the DBMS, then just query that stored procedure.
😕