Property availability

stephenp222

hi guys,

I am designing a website which has properties on for rent.
I would like to show the availability of each property when a button next to the property is clicked on.

I want to have a calendar pop up with the date(s) the propery is unavailable Highlighted.
It will have to be updated through the admin function (which is onsite already for other stuff), and be in fields in the same table as the properties (to make things easier).

I have no idea of how to do this.

My site uses an MYSQL database.

I am very new to PHP so any help would be appreciated.

Thanks

Stephen

buraks78

hi,

you may cram all the unavailable dates into an array and then use a an if statement in each respective table cell on your calendar page...

for instance, if august 12th and 13th are unavailable dates:

<?php
//put all unavailable dates into an array or
//if you are retrieving them from the database store them
//with spaces between and then use explode() function to
//convert them into an array

$unavailable=array("20030812", "20030813");
?>

in your table change the background of each respective calendar cell into red if they are unavailable btw you have to put these if statemenst in all calendar cells

 
<td <?php if(in_array("20030812",$unavailable)){echo "bgcolor=\"red\"";}?>> August 12 </td>
<td <?php if(in_array("20030813",$unavailable)){echo "bgcolor=\"red\"";}?>> August 13 </td>

this would work but it would also make it really hard to maintain this code if you are planning to publish dates in more than one month...

drawmack

what the above poster gave are the mechanics for a single day/month. Now here is how you put that into a loop

$arydays = array(31,28,31,etc);

$thisMonth = date('m');
$thisYear = date('Y');

//gotta account for leap year
if($thisYear%4 == 0) {$arydays[1] = 29;}

//code to finde the day of the week the month began on that I don't feel like looking up right now
//but is pretty simple
for($i=1;$i<=$arydays[$thisMonth];$i++) {
   //code for each day from above poster here
}

//code to pad calendar for any remaining days in the last week.

buraks78

nice job, but i think there is one little flaw...

date('m') returns the numeric representation of a month, with leading zeros. that means if the month is january you get 01...

but in order the get the correct number of days in january from your $arydays array you need the 0 key. so what you have to do is to subtract one from $thisMonth variable...

$arydays = array(31,28,31,etc);

$thisMonth = date('m');
$index_key = $thisMonth - 1;
$thisYear = date('Y');

//gotta account for leap year
if($thisYear%4 == 0) {$arydays[1] = 29;}

//code to finde the day of the week the month began on that I don't feel like looking up right now
//but is pretty simple
for($i=1;$i<=$arydays[$index_key];$i++) {
   //code for each day from above poster here
}

//code to pad calendar for any remaining days in the last week.

drawmack

ha yes I forgot that I usually build my array like this

$aryMonths(0,31,28,31,etc.);

stephenp222

Ok guys,

Thanks very much for the replies, i have got a simple thing working using the arrays, but i want to get it working by reading the info from a field in a MYSQL DB.

As was sugessted to use the explode() function, i have tried this but not with any luck.

Table name is "property"
my primary Key field is "id" (which i use to select the data for the correct property)
and the availability data will be in "availability"

can some get me going in the right direction for this.

I am getting better!!

Thanks

Stephen

drawmack

okay

assume
$month holds the current month
$days is the number of days in the current month
$year holds the current 4 digit year
$id holds the id for this property
availablity holds the data in YYYY-MM-DD format

for($i=1;$i<=$days;$i++) {
  $sql = "SELECT ID FROM property WHERE availability = \"" . $year . "-" . $month . "-" . $day . "\" AND id=$id";
//process the query
}