PHP Warning: date() expects parameter 2 to be long, string given in

Question

I got this warning:

PHP Warning:  date() expects parameter 2 to be long, string given in /home/xxxx/public_html/init.php on line 98

and the code:

$stats['statTodaysLinks']   = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `DATE_ADDED` LIKE '".date ('Y-m-d', TIMENOW)."%'");

As the error message states, `TIMENOW` is a `string`, not a `long`. — Phylogenesis, May 26 '17 at 14:34
Or TIMENOW is undefined, therefore PHP converts it to a string. — Flosculus, May 26 '17 at 14:34
if you want to get current time, remove `TIMENOW` in `date` function — Canh Nguyen, May 26 '17 at 14:35

score 2 · Answer 1 · answered May 26 '17 at 14:38

2

It's your TIMENOW constant that's causing the problem by the looks of it, there's no need for it as the function will automatically use the current time if you don't supply anything.

So instead of date ('Y-m-d', TIMENOW) use date ('Y-m-d').

answered May 26 '17 at 14:38

stevenkellow

75
4

PHP Warning: date() expects parameter 2 to be long, string given in

1 Answers1