Search data by date from a database table using PHP?

Question

I have a table where a date field (datetime type). Stored data like 2015-12-09 11:33:44 .I have datepicker input field to search data which generated date like 2015-12-09.So how can i search data using the given date.Assume that i have many data with same date but different time.Is this possible to get all matched data with a given date?

Al Amin Chayan · Accepted Answer · 2016-01-06 06:06:10Z

3

convert your input date in a date range:

$inpute_date = '2015-12-09';
$start_date = $inpute_date . ' 00:00:00';
$end_date = $inpute_date . ' 23:59:59';

And in your condition:

WHERE your_date_col BETWEEN '$start_date' AND '$end_date'

answered Jan 6, 2016 at 6:06

Al Amin Chayan

2,5004 gold badges26 silver badges43 bronze badges

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

1 Comment

VolkerK Over a year ago

Just tested my "solution" (using Date()) and yours and ...dang, MyQL really doesn't optimize WHERE Date(d)='...' to use the index on d exactly like it does for d BETWEEN ... AND .... (It does use the index, but without index push down).

Collectives™ on Stack Overflow

Search data by date from a database table using PHP?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related