Search between two dates in mysql and php

Question

Hi I want to search the items present in the table users. The code I wrote is

$fromdate = date("Y-m-d H:i:s", strtotime($_POST['fromdate'])); $todate = date("Y-m-d H:i:s", strtotime($_POST['todate'])); $s="SELECT * FROM logs WHERE dt BETWEEN $fromdate AND $todate ORDER BY dt DESC "; $x = mysql_query($s);

But the output is not showing. Please someone help me.

try with $s="select * from logs where dt between '$fromdate' and '$todate' order by dt desc ";// you forget quotes in your query — Saty
– Saty, Commented Apr 8, 2015 at 9:14
You need to put $fromdate and $todate in quotes. Avoid writing php variables directly in sql statement. — Đuro Mandinić
– Đuro Mandinić, Commented Apr 8, 2015 at 9:14

Narendrasingh Sisodia · Accepted Answer · 2015-04-08 09:26:15Z

Need to apply quotes around '$fromdate' and '$todate' as

$s="SELECT * FROM logs WHERE dt BETWEEN '$fromdate' AND '$todate' ORDER BY dt DESC ";

Saty · Accepted Answer · 2015-04-08 09:21:03Z

0

$fromdate = strtotime($_POST['fromdate']); $todate = strtotime($_POST['todate']); $query="SELECT * FROM logs WHERE UNIX_TIMESTAMP(dt) BETWEEN $fromdate AND $todate ORDER BY dt DESC ";

edited Apr 8, 2015 at 9:21

Saty

22.5k7 gold badges35 silver badges52 bronze badges

answered Apr 8, 2015 at 9:18

Harut Gabrielyan

296 bronze badges

1 Comment

Jørgen R Over a year ago

While this may answer the question it’s always a good idea to put some text in your answer to explain what you're doing. Read how to write a good answer.

Collectives™ on Stack Overflow

Search between two dates in mysql and php

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related