PHP replacement for MySQL Now()

Question

I do a lots of queries like:

SELECT THIS
FROM THAT
WHERE ROW_TIME < NOW()

How to create variable in PHP that will contain current time so i can make this work:

SELECT THIS
FROM THAT
WHERE ROW_TIME < '$variable'

?

Duplicate : http://stackoverflow.com/questions/1575601/datetime-now-php-mysql-pdo-variant — rkosegi, Jan 10 '13 at 14:24
"Tim S" gave you the answer, but still using the mysql function NOW() will be faster, than using the PHP date() function. Why exactly do you need to create a variable in PHP ? — HerpaMoTeH, Jan 10 '13 at 14:32

score 6 · Accepted Answer · answered Jan 10 '13 at 14:23

6

the PHP date($format) function returns current time as a string. You can set the format using a string.

date("Y-m-d H:i:s")

answered Jan 10 '13 at 14:23

Tim S.

will it be safe for time zones? – Tom Smykowski Jan 10 '13 at 14:26
Why do you need time zones, when this gives you the server time. NOW() also gives you the server's time. – HerpaMoTeH Jan 10 '13 at 14:29

score 1 · Answer 2 · answered Jan 10 '13 at 14:23

1

The PHP date function will help.

answered Jan 10 '13 at 14:23

SeanWM

1

Really? I had no idea. You knew what I meant so your comment is pointless. – SeanWM Jan 10 '13 at 14:27
I dont understand you. Sorry date is for time also, but its so broad answer it does not help me – Tom Smykowski Jan 10 '13 at 14:29
1

I was directing you to the function that will help you. Spend a little time on that page and you'd find your answer. – SeanWM Jan 10 '13 at 14:32

score 0 · Answer 3 · answered Jan 10 '13 at 14:23

0

You should use time() - it returns a timestamp. http://php.net/manual/en/function.time.php

answered Jan 10 '13 at 14:23

Kyle

time() doesn't return the same as mysql's NOW() – HerpaMoTeH Jan 10 '13 at 14:27

3 Answers3