PROBLEM WITH FINDING DATE AVAILABLE BETWEEN TWO DATES

samannoychatter

Hi ,

I am stuck in a big problem..

I am able to find the availability between dates with the below code. But the issue is that this is not my desired result.

Below codes gives the result like :

If my checkin date = 2010-11-23 and check out date is 2010-11-24 or 2010-11-28 it returns true,i.e. UNAVAILABLE.

But when ever the date is given like checkin date = 2010-11-20 and check out date=2010-11-28 it returns true , ie. UNAVAILABLE.

The thing which i want is that it should not return available if in database checkindate=2010-11-23 and checkout date = 2010-11-24 exist , when user want to find availability between 2010-11-20 and 2010-11-28 as 23rd and 24th falls in between these dates.

Below is my code ::

<?php
$date1d=20;
$date1m=11;
$date1y=2010;
$date1time=mktime(12,0,0,$date1m,$date1d,$date1y);


$date2d=28;
$date2m=11;
$date2y=2010;
$date2time=mktime(12,0,0,$date2m,$date2d,$date2y);

$diffintime=$date2time-$date1time;


$date1=$date1d."-".$date1m."-".$date1y;
$date2=$date2d."-".$date2m."-".$date2y;
$apartmentid="5";

$noofdays=$diffintime/86400;

echo "Difference in Time - ".$diffintime."<br>";
echo "CheckIn Date - ".$date1."<br>";
echo "CheckOut Date - ".$date2."<br>";
echo "No of Days Booked - ".$noofdays."<br>";
echo "Apartment Id- ".$apartmentid."<br>";


if(checkavailability($date1,$date2,$apartmentid,$noofdays)==true)
   {
	 echo "UNAVAIBALE";    

   }
else echo "AVAILABLE"; 


?>

<?php
function checkavailability($date1,$date2,$apartmentid,$noofdays)
{
     $selectapartmentdate="SELECT checkin_date,checkout_date FROM reservation where apartment_id='".$apartmentid."' AND checkin_date >= '".$value."' and checkout_date <= '".$date2."'";
	 $selectapartmentdate=mysql_query($selectapartmentdate);
	 $num=mysql_num_rows($selectapartmentdate);
	     if( $num>0)
           {
			 return false;
           } 
}
?>

dalecosp

Where does $value come from? It appears only once, and without initialization or assignment.

samannoychatter

Here is the proper code..

<?php
$date1d=20;
$date1m=11;
$date1y=2010;
$date1time=mktime(12,0,0,$date1m,$date1d,$date1y);

$date2d=28;
$date2m=11;
$date2y=2010;
$date2time=mktime(12,0,0,$date2m,$date2d,$date2y);

$diffintime=$date2time-$date1time;

$date1=$date1d."-".$date1m."-".$date1y;
$date2=$date2d."-".$date2m."-".$date2y;
$apartmentid="5";

$noofdays=$diffintime/86400;

echo "Difference in Time - ".$diffintime." ";
echo "CheckIn Date - ".$date1." ";
echo "CheckOut Date - ".$date2." ";
echo "No of Days Booked - ".$noofdays." ";
echo "Apartment Id- ".$apartmentid." ";

if(checkavailability($date1,$date2,$apartmentid,$noofdays)==true)
{
echo "UNAVAIBALE";

}
else echo "AVAILABLE";

<?php
function checkavailability($date1,$date2,$apartmentid,$noofdays)
{
$selectapartmentdate="SELECT checkin_date,checkout_date FROM reservation where apartment_id='".$apartmentid."' AND checkin_date >= '".$date1."' and checkout_date <= '".$date2."'";
$selectapartmentdate=mysql_query($selectapartmentdate);
$num=mysql_num_rows($selectapartmentdate);
if( $num>0)
{
return false;
}
}
?>

My table contains two fields checkin_date and checkout_date against a particular booking.

I can't allow any bookings between these dates if already booked. Please help me with the solution.