php - Search between two times (e.g. 14:00:00 - 16:00:00) -



php - Search between two times (e.g. 14:00:00 - 16:00:00) -

can here tell me how write code search time. illustration in database, have start_time , end_time this:

start_time end_time 14:00:00 16:00:00

i have php code search if set in text field find time 14:00:00 16:00:00, but

my question how can same result if user search time between ?

for example, if user search time 15:00:00 16:00:00.

sorry english..hope can help me..thank you.

below code.

form

<input name="intime" type="time" placeholder='insert time'> <input name="intime2" type="time" placeholder='insert time'> <input name="submit" type="submit" value="search" /> </form>

where time between start_time , end_time;

php mysql

Comments

Popular posts from this blog

assembly - What is the addressing mode for ld, add, and rjmp instructions? -

vowpalwabbit - Interpreting Vowpal Wabbit results: Why are some lines appended by "h"? -

Is there a way to convert an HTML page styled with Bootstrap CSS into email-compatible html? -