查找我的sql表中可用的日期范围[重复]

Question

This question already has an answer here:

• How do I query between two dates using MySQL? 10 answers

I have Two Input One is

<input type="text" data-date-format="dd-mm-yyyy" class="datepicker span11" name="start_date" placeholder="Check-In Date" />

Second is

<input type="text" data-date-format="dd-mm-yyyy" class="datepicker span11" name="end_date" placeholder="Check-Out Date" />

Now The My database have two Column which is " id, start_date, end_date" and Respectively value of them is "1, 14-05-2016, 21-05-2016"

Now when i choose Form Input box "15-05-2016" as start_date And "17-05-2016" as end_date. then i get empty result. i Checked the query in sql it is shown ok. then i dump this query which shows "SELECT * FROM room_inventory WHERE start_date >= '15-05-2016' AND end_date <= '17-05-2016' "

No error came. but also don't get any result.

I tried this

 $start_date = $_POST['start_date'];
 $end_date = $_POST['end_date'];

 $checkAvailability = "SELECT * FROM room_inventory WHERE start_date >= '$start_date' AND end_date <= '$end_date' ";

 $resultAvailability = mysqli_query($con, $checkAvailability);
 $rowAvailability = mysqli_fetch_array($resultAvailability);
 rint_r($rowAvailability);

So how do i get that the input date are available in this database.

</div>

Answer 1

i think problem in query ...you can check by printing query text i think it should be :"SELECT rc_type FROM room_inventory WHERE start_date >= ".$start_date." AND end_date <= ".$end_date ." i wish it will help you :)