getting more results from array

nicky77uk1

My script below reports back First available room, i want it to report 1 or 2 or 3 available rooms depending on a variable passed. please help! Thanks

This is my db table intergers:
+---+
+ i +
+---+
+ 1 +
+---+
+ 2 +
+---+
+ 3 +
+---+

<style type="text/css"> 
.booked 
{background-color : #ff5050; color : black;} 
.free {background-color : #CCFFCC;color : black; } 
<font color=black size=2 face=verdana> 
</style> 

<?php 
//book.php 
$rt=1; 
$sy=2005; 
$sm=8; 
$sd=28; 
$start_date="$sy-$sm-$sd"; 


$ey=2005; 
$em=8; 
$ed=30; 
$ed2=$ed-1; 
$end_date="$ey-$em-$ed"; 
$start_date = "$sy-$sm-$sd"; 

// CHECK IF DESIRED BOOKING IS NOT MORE THaN 14 DAYS 
$date1sp = explode("-", $start_date); 
$date2sp = explode("-", $end_date); 
$sec1 = date("U", mktime(0, 0, 0, $date1sp[1], $date1sp[2], $date1sp[0])); 
$sec2 = date("U", mktime(0, 0, 0, $date2sp[1], $date2sp[2], $date2sp[0])); 
$diffsec = $sec2-$sec1; 
$diffday = round($diffsec/86400); 
$maxdays=14; 
if ($diffday >= $maxdays) { 
   echo "Booking is over 14 days, die."; 
   } else { 
// continue with the program 

include ("config.php"); 

MySQLConnectAndSelect(); 
function BuildHeader($StartDate, $EndDate,  &$Array) 
{ 
   // convert times to timestamps 
   $sd = strtotime($StartDate); 
   $ed = strtotime($EndDate); 

   // build array of dates to search 
   $cd = $sd; 
   while ($cd < $ed) 
   { 
    $t = strftime('%Y-%m-%d', $cd); 

// build header for free room array 
$Array[0][$t] = 'header'; 
$cd = strtotime('+1 day', $cd); 
   } 
} 


function GetBookedRooms($StartDate, $EndDate, &$RoomStatus, $rt) 
{     

   BuildHeader($StartDate, $EndDate, $RoomStatus); 


   $sql = 'SELECT * from intergers'; 

/* ***** START DIAGNOSTIC **** */ 
//echo '<pre>'; 
#print_r($sql); 
echo "<BR>"; 
/* ***** END DIAGNOSTIC **** */ 

   $result = mysql_query($sql) or die ('Failed to execute, Did you include rt=1?<BR><BR> ' . $sql .  ' due to ' . mysql_error()); 
   // read booked room data 
   while ($row = mysql_fetch_assoc($result)) 
   { 
    // store room booked data in array 
    // 1st dimension = date room was booked 
    // 2nd dimension = room number 

$RoomStatus[$row['room_number']][$row['thedate']] = 'Booked'; 

} 
   mysql_free_result($result); 

} 


function SetRoomsAvailable($StartDate, $EndDate, &$RoomStatus) 
{ 
   // convert all date/time strind to unix timestamps 
   $sd = strtotime($StartDate); 
   $ed = strtotime($EndDate); 

   // for each room in th array 
   foreach($RoomStatus as $room_number => $dates) 
   { 
    $cd = $sd; 
    // for each dte 
    while ($cd < $ed) 
    { 
      // mark room as free 
      $RoomStatus[$room_number][strftime('%Y-%m-%d', $cd)] = 'Free'; 
      $cd = strtotime('+1 day', $cd); 
    } 
   } 

/* ***** START DIAGNOSTIC **** */ 
//echo '<br><pre>'; 
//print_r($RoomStatus); 
//echo '</pre><br>'; 
/* ***** END DIAGNOSTIC **** */ 
} 

function GetFirstAvailableRoom($StartDate, $EndDate, $RoomStatus, &$Available) 
{ 
   $first_room = 0; 

   BuildHeader($StartDate, $EndDate, $Available); 

   // convert times to timestamps 
   $sd = strtotime($StartDate); 
   $ed = strtotime($EndDate); 

   // for each room 
   foreach($RoomStatus as $room_number => $dates) 
   { 
    $room_free = true; 
    // for each date 
    foreach ($dates as $date => $status) 
    { 
      $d = strtotime($date); 
      //checl only those dates within the required range 
      if ( ($sd <= $d) && ($d <= $ed) ) 
      { 
        // this room is booked 
        if ('Booked' == $status) 
        { 
          // so abort checking this room 
          $room_free = false; 
          break; 
        } 
      } 
    } 

// we have found a free room 
if (true == $room_free) 
{ 
  // save data and break out of loop 
  $first_room = $room_number; 
  $Available[$room_number] = array(); 
  SetRoomsAvailable($StartDate, $EndDate, $Available); 
  break; 
} 
   } 

// return first room found 
   return ($first_room); 
} 

function BuildTable($DataArray) 
{ 
   ksort($DataArray); 

   global $tdcol1; 
   // build display table 
   $tbl = '<table border="1">'; 

   // build table header - use dates that are in the array 
   $tbl .= '<tr>'; 
   $tbl .= '<td bgcolor=#ffcc99><B>Room Number</td></B>'; 

   foreach ($DataArray[0] as $date => $status) 
   { 
    $tbl .= '<td bgcolor=#ffcc99><b>' . date('D-j-M', strtotime($date)) . '</td>'; 
   } 
   $tbl .= '</tr>'; 

   reset ($DataArray); 

   // for each of our rooms 
   foreach ($DataArray as $room_number => $room) 
   { 
    // assume row 0 is the header row 
    // and valid room numbers are > 0 


if (0 < $room_number) 
{ 


  // create a new row and display the room number 
  $tbl .= '<tr>'; 
  $tbl .= '<td><font color=navy><b>'. $room_number . '</b></td>'; 

  // for each date in out selected range 
  foreach ($room as $key => $value) 
  { 
    // work out style to be used 
    switch ($value) 
    { 
      case 'Free': 
        $style = 'free'; 
        break; 
      case 'Booked': 
        $style = 'booked'; 
        break; 
      default: 
        $style = 'booked'; 
        break; 
    } 

    // display the status of this room (booked or free) 
    $tbl .= '<td class="' . $style . '">'. $value . '</td>'; 
  } 

  // end the row 
  $tbl .= '</tr>'; 
} 
   } 
   // close the table 
  echo"</tr></table>"; 


   return ($tbl); 
} 

$roomnum=7; //amount of rooms for this type i.e 7 singles 

/* ***** START OF TEST DATA ***** */ 
// build an array of rooms to check availability 

  for ($i = 1; $i <= $roomnum; $i++) 
{ 
   $room_status[$i] = array(); 
} 

$booked = array(); 


SetRoomsAvailable($start_date, $end_date, $room_status); 
GetBookedRooms($start_date, $end_date, $room_status, $rt); 

$tbl = BuildTable($room_status); 
echo $tbl; 

   echo"</tr></table>"; 

$available = array(); 
$first_room = GetFirstAvailableRoom($start_date, $end_date, $room_status, $available); 


if (0 < $first_room) 
{ 
   echo '<h3>ROOM IS AVAILABLE FOR YOUR STAY</h3>'; 

   $tbl = BuildTable($available); 
   echo $tbl; 

} 
} 
?>

LoganK

What are you trying to do?

nicky77uk1

If you run the code, then u will see what i mean...it will find the first avail room but i want the first 3!

cheers!

LoganK

I can't run the code without a DB, plus my comp. is down right now...try something in your SQL query like "LIMIT 3" to return 3 results, and make sure PHP process everything with a while($row = mysql_fetch_array($result)) loop and not a simple "$row = mysql_fetch_array($result)" assignment.

nicky77uk1

Ok, no DB is required, you can just execute this code as is...it will output a table with the first room as being available, i want it to out put the first 3!

<style type="text/css">  

.booked  

{background-color : #ff5050; color : black;} 
.free {background-color : #CCFFCC;color : black; } 
<font color=black size=2 face=verdana>  

</style>  

<?php  

//book.php 
$rt=1;  

$sy=2005;  

$sm=8;  

$sd=28;  

$start_date="$sy-$sm-$sd";  


$ey=2005;  

$em=8;  

$ed=30;  

$ed2=$ed-1;  

$end_date="$ey-$em-$ed";  

$start_date = "$sy-$sm-$sd";  

// CHECK IF DESIRED BOOKING IS NOT MORE THaN 14 DAYS 
$date1sp = explode("-", $start_date);  

$date2sp = explode("-", $end_date);  

$sec1 = date("U", mktime(0, 0, 0, $date1sp[1], $date1sp[2], $date1sp[0]));  

$sec2 = date("U", mktime(0, 0, 0, $date2sp[1], $date2sp[2], $date2sp[0]));  

$diffsec = $sec2-$sec1;  

$diffday = round($diffsec/86400);  

$maxdays=14;  

if ($diffday >= $maxdays) {  

   echo "Booking is over 14 days, die.";  

   } else {  

// continue with the program 

include ("config.php");  

MySQLConnectAndSelect();  

function BuildHeader($StartDate, $EndDate,  &$Array)  

{  

   // convert times to timestamps 
   $sd = strtotime($StartDate);  

   $ed = strtotime($EndDate);  

   // build array of dates to search 
   $cd = $sd;  

   while ($cd < $ed)  

   {  

    $t = strftime('%Y-%m-%d', $cd);  

// build header for free room array 
$Array[0][$t] = 'header';  
$cd = strtotime('+1 day', $cd);  
   }  

}  


function GetBookedRooms($StartDate, $EndDate, &$RoomStatus, $rt)  

{      

   BuildHeader($StartDate, $EndDate, $RoomStatus);  

$RoomStatus[$row['room_number']][$row['thedate']] = 'Booked';  


}  


function SetRoomsAvailable($StartDate, $EndDate, &$RoomStatus)  

{  

   // convert all date/time strind to unix timestamps 
   $sd = strtotime($StartDate);  

   $ed = strtotime($EndDate);  

   // for each room in th array 
   foreach($RoomStatus as $room_number => $dates)  

   {  

    $cd = $sd;  

    // for each dte 
    while ($cd < $ed)  

    {  

      // mark room as free 
      $RoomStatus[$room_number][strftime('%Y-%m-%d', $cd)] = 'Free';  

      $cd = strtotime('+1 day', $cd);  

    }  

   }  

/* ***** START DIAGNOSTIC **** */  

//echo '<br><pre>'; 
//print_r($RoomStatus); 
//echo '</pre><br>'; 
/* ***** END DIAGNOSTIC **** */  

}  

function GetFirstAvailableRoom($StartDate, $EndDate, $RoomStatus, &$Available)  

{  

   $first_room = 0;  

   BuildHeader($StartDate, $EndDate, $Available);  

   // convert times to timestamps 
   $sd = strtotime($StartDate);  

   $ed = strtotime($EndDate);  

   // for each room 
   foreach($RoomStatus as $room_number => $dates)  

   {  

    $room_free = true;  

    // for each date 
    foreach ($dates as $date => $status)  

    {  

      $d = strtotime($date);  

      //checl only those dates within the required range 
      if ( ($sd <= $d) && ($d <= $ed) )  

      {  

        // this room is booked 
        if ('Booked' == $status)  

        {  

          // so abort checking this room 
          $room_free = false;  

          break;  

        }  

      }  

    }  

// we have found a free room 
if (true == $room_free)  
{  
  // save data and break out of loop 
  $first_room = $room_number;  
  $Available[$room_number] = array();  
  SetRoomsAvailable($StartDate, $EndDate, $Available);  
  break;  
}  
   }  

// return first room found 
   return ($first_room);  

}  

function BuildTable($DataArray)  

{  

   ksort($DataArray);  

   global $tdcol1;  

   // build display table 
   $tbl = '<table border="1">';  

   // build table header - use dates that are in the array 
   $tbl .= '<tr>';  

   $tbl .= '<td bgcolor=#ffcc99><B>Room Number</td></B>';  

   foreach ($DataArray[0] as $date => $status)  

   {  

    $tbl .= '<td bgcolor=#ffcc99><b>' . date('D-j-M', strtotime($date)) . '</td>';  

   }  

   $tbl .= '</tr>';  

   reset ($DataArray);  

   // for each of our rooms 
   foreach ($DataArray as $room_number => $room)  

   {  

    // assume row 0 is the header row 
    // and valid room numbers are > 0 


if (0 < $room_number)  
{  


  // create a new row and display the room number 
  $tbl .= '<tr>';  
  $tbl .= '<td><font color=navy><b>'. $room_number . '</b></td>';  

  // for each date in out selected range 
  foreach ($room as $key => $value)  
  {  
    // work out style to be used 
    switch ($value)  
    {  
      case 'Free':  
        $style = 'free';  
        break;  
      case 'Booked':  
        $style = 'booked';  
        break;  
      default:  
        $style = 'booked';  
        break;  
    }  

    // display the status of this room (booked or free) 
    $tbl .= '<td class="' . $style . '">'. $value . '</td>';  
  }  

  // end the row 
  $tbl .= '</tr>';  
}  
   }  

   // close the table 
  echo"</tr></table>";  


   return ($tbl);  

}  

$roomnum=7; //amount of rooms for this type i.e 7 singles 

/* ***** START OF TEST DATA ***** */  

// build an array of rooms to check availability 

  for ($i = 1; $i <= $roomnum; $i++)  

{  

   $room_status[$i] = array();  

}  

$booked = array();  


SetRoomsAvailable($start_date, $end_date, $room_status);  

GetBookedRooms($start_date, $end_date, $room_status, $rt);  

$tbl = BuildTable($room_status);  

echo $tbl;  

   echo"</tr></table>";  

$available = array();  

$first_room = GetFirstAvailableRoom($start_date, $end_date, $room_status, $available);  


if (0 < $first_room)  

{  

   echo '<h3>ROOM IS AVAILABLE FOR YOUR STAY</h3>';  

   $tbl = BuildTable($available);  

   echo $tbl;  

}  

}  

?>

leatherback

Hi,

Just wondering...

Why don't you do this in sql? Seems to me like you ar enow tryuing to get something done in dozens of functions, which one solid SQL statement could do in one go.

Bu ok..

in getfirstavailableroom:


// we have found a free room
if (true == $room_free)  
{  
  // save data and break out of loop
  $first_room = $room_number;  
  $Available[$room_number] = array();  
  SetRoomsAvailable($StartDate, $EndDate, $Available);  
  break;  
}

the command break; causes your code to execute after the initial finding.

You could change this to something like (Set $i =0; in the first line of this function, and remember, this is an example, and may not work directly):


// we have found a free room
if (true == $room_free)  
{  

  // save data and break out of loop
  $first_room[$i] = $room_number;  
  $Available[$room_number] = array();  
  SetRoomsAvailable($StartDate, $EndDate, $Available);  
  $i++;
  if($i == 3)
      {
      break;  

      }
    }

leatherback

LoganK wrote:
I can't run the code without a DB, plus my comp. is down right now...try something in your SQL query like "LIMIT 3" to return 3 results, and make sure PHP process everything with a while($row = mysql_fetch_array($result)) loop and not a simple "$row = mysql_fetch_array($result)" assignment.

Hi Logan,

No need to reply if you do not get the concept. 😃 You do not use databases, do you?

The query cannot be limited to 3 records because at the moment all records are retrieved, and the data is tested against a reservation record or something. As I mentioned in my post: SQL can handle this very elegantly, if the dtaabase is set up properly. By the little fix I posted should just do it. It is in coding. Not newbies. So I suppose the general limit statement would be known to the poster.

LoganK

leatherback wrote:
Hi Logan,

No need to reply if you do not get the concept. 😃 You do not use databases, do you?

The query cannot be limited to 3 records because at the moment all records are retrieved, and the data is tested against a reservation record or something. As I mentioned in my post: SQL can handle this very elegantly, if the dtaabase is set up properly. By the little fix I posted should just do it. It is in coding. Not newbies. So I suppose the general limit statement would be known to the poster.

J.

I kind of get the concept, perhaps I didn't read enough of the post. And yes, I do use databases, unless you were talking to the original poster. If he's doing what you're saying, then yes, I would agree with you - use the builtin functions of SQL to get the rooms that are booked, not getting everything and sorting it with PHP.

Nicky - I can't run any code since my computer is down. It's hard drive crashed and it's in the shop. I've lamented about it enough on this board so I'm not going to give the full details 🙂

nicky77uk1

leatherback, worked like a charm, thank you!

i found a function, but i dont know how to use it! 😕

lets say i would like to know the rate between 2005-06-01 to 2005-06-04, it should be 65 i know...but i want to know how to use this function!

cheers!

<?
// initialize array 
$date_array = array(); 

// add rates for specified ranges 
addRange($date_array, '2005-05-10', '2005-05-30', 40); 
addRange($date_array, '2005-06-01', '2005-06-30', 65); 
addRange($date_array, '2005-02-01', '2005-02-28', 25); 

// sort the array by date, maybe not needed 
ksort($date_array); 

// printing it out just to see it 
echo '<pre>'; 
print_r($date_array); 
echo '</pre>'; 

// and here's the magic 
function addRange(&$date_array, $startdate, $enddate, $rate) { 
    // a full day's and a half day's worth of seconds 
    $halfday = 12*3600; 
    $fullday = 24*3600; 

// set timestamps for the dates given, giving extra padding to the end 
$starttime = strtotime($startdate) + $halfday; 
$endtime = strtotime($enddate) + $fullday; 

// loop through each day in this range 
for ($currtime=$starttime; $currtime<$endtime; $currtime+=$fullday) { 

    // get the Y-m-d format of the current time 
    $date = date('Y-m-d', $currtime); 

    // and insert the rate for this range into that slot 
    $date_array[$date] = $rate; 

    // get the day of the week 
    $day = date('w', $currtime); 

    // a day of 0 is sunday, and 6 is saturday 
    if ($day == 0 || $day == 6) { 

        // if its saturday or sunday, increase this date by 10 
        $date_array[$date] += 10;   
    } 
} 
}

leatherback

Well,

this is how you use is:

addRange($date_array, '2005-05-10', '2005-05-30', 40);

But it is more a matter of.. What does it do, and what do you want to achieve. I have a whoiole bunch of functions. But I am sure they are not functional for you..

To me it seems like all it does is set rates for specific timeperiods.
If in the function you would add
global $date_array;
as first statement, I think it would work better.
Then you can add the ranges as shown, and retrieve the rates by:

$rate = $date_array[$date];

nicky77uk1

leatherback,

i see what your saying...but with this function...i want rates for a range of dates...

i.e

2005-06-18 - 2005-06-20 (american dates)

if i do:

echo $date_array['2005-06-18'];
echo $date_array['2005-06-19'];
echo $date_array['2005-06-20'];

i get:

75
75
65

but the function has a startdate and enddate which means i could somehow make variables like below and call the function!

$startdate="2005-06-18";
$enddate="2005-06-20";

and it should give me: 75 75 65

can you see how this can be done?

leatherback

Hi,

I am not sure.

The function you showed really only sets this dat array with rates. The only way I can think of, is to change the date in day-month-year variables, and then go for each day to the variable, and extract. Or you could change the array to a datefield (Not sure oif that is an existing variable type though).

Or.. You could insert the dates as unix timestamps. THen you could select from the array values between start and end.

But this is major changing the script, and I think you should give it a tincker yourself if you'd want to do that, and maybe post later what you have got. It is all about learning right?