Jump to content

loop from the query

Jenling

By Jenling
in PHP Coding Help

 Share

Recommended Posts

Jenling Newbie

Jenling

Posted
Posted

Its me again! I want to ask if there is a way to loop the query in the database? Im building a booking system recently. I wanted to make a table to show all the status of occupied or available in the column of the table. However, I need to compare the startTime_of_booking,end_time_of_booking and the room in my database in order to show the value on the table. Can somebody help me with this?

 

This is my code:

<?php require_once('connections/connect.php');
session_start();
?>
<script type="text/javascript">
<!--
function redirect()
{
window.location = "index.php"
}
//-->
</script>
<?
if(!session_is_registered(username))
{
echo "<script type=\"text/javascript\">".
	"alert('Unauthorized access to this page. Please Log In');".
	"redirect()".
	"</script>";		
}
?>
<html>
<head>
<meta http-equiv="Content-Language\" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>SKTM Online Booking System</title>

<script>
<language="javascript" type="text/javascript"> 
function switchpage(select) { 
    var index; 

  for(index=0; index<select.options.length; index++) 
    if(select.options[index].selected) 
      { 
        if(select.options[index].value!="") 
          window.location.href=select.options[index].value; 
        break; 
      } 
} 
</script>


     
<SCRIPT language=Javascript>
function displayMenu(currentMenu) 
{
var thisMenu = document.getElementById(currentMenu).style
if (thisMenu.display == "block") 
{
	thisMenu.display = "none"
} 
else 
{
	thisMenu.display = "block"
}
return false
}
</script>
<style type="text/css"> 
    <!-- 
    .cornercell { 
       text-align: center; 
       border: 1px solid black; 
       height: 20px; 
       background-color: #DCDCDC; 
    } 
    .daycell { 
      text-align: center; 
      width: 12%; 
      height: 20px; 
      border-bottom: 1px solid black; 
      border-right: 1px solid black; 
      border-top: 1px solid black; 
      background-color: #DCDCDC; 
    } 
    .timecell { 
      text-align: center; 
      border-bottom: 1px solid black; 
      border-right: 1px solid black; 
      border-left: 1px solid black; 
      background-color: #DCDCDC; 
      width: 11%; 
      height: 20px; 
    } 
    .concell { 
      border-right: 1px solid black; 
      border-bottom: 1px solid black; 
      background-color: #F2F2F2; 
      text-align: center; 
    } 
    .setcell { 
      border-right: 1px solid black; 
      border-bottom: 1px solid black; 
      background-color: #EFEFEF; 
      text-align: center; 
    } 
    --> 
</style> 
<body background="img/bg_bar.jpg">
<table align="center" border="0" width="989" cellspacing="0" cellpadding="0">
<tr>
<td rowspan="2" width="10%">
<img border="0" src="img/UMS.jpg" width="107" height="108"></td>
<td width="89%" height="84">
<p align="center"><font face="Century Gothic" size="6" color="#0099FF">SKTM Online Booking System</font></td>
</tr>
<tr>
<td width="89%" bgcolor="#0099FF" height="15"><font face="Tw Cen MT"> <font color="#FFFFFF">Welcome! You are currently log on as <? echo "$username";?></font></font></td>
</tr>
<tr>
<td colspan="2" bordercolor="#0099FF">
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#0099FF">
<tr>
<td valign="top" width="182" height="660"><p> </p>
  <? include "siteBar.php"; ?></td>

<td valign="top" width="">
<table border="1" width="100%" height="38">
<tr>
<? include "MRBar.php"; ?>
</tr>
</table>			
<table width= "100%" height="208" border="0">
<tr>
<td width="77%" height="204" valign="top">
<h3>Meeting Room >> View Availability</h3>
<form action="" method="post" name="form1" target="_self" id="form1">
  <label>
  <div align="center"  ><h3>Select a meeting room to view :<h3>
    </font>
   <select name="select">
      <option value="Meeting Room 1">Meeting Room 1</option>
      <option value="Meeting Room 2">Meeting Room 2</option>
  <option value="Meeting Room 3">Meeting Room 3</option>
  <option value="Meeting Room 4">Meeting Room 4</option>
  <option value="Meeting Room 5">Meeting Room 5</option>
  <option value="Meeting Room 6">Meeting Room 6</option>
  <option value="Eksekutif">Eksekutive</option>
  <option value="Seminar Room">Seminar Room</option>
    </select>
    <input type="submit" name="Submit" value="Select" />
 </form>
     

   <div align="center"><?php 
   
if($_POST[select]==$select1)
{
echo ("Meeting Room 1");
}
else if ($_POST[select]==$select2) {
echo ("Meeting Room 2");}

else if ($_POST[select]==$select3) {
echo ("Meeting Room 3");}

else if ($_POST[select]==$select4) {
echo ("Meeting Room 4");}

else if ($_POST[select]==$select5) {
echo ("Meeting Room 5");}

else if ($_POST[select]==$select6) {
echo ("Meeting Room 6");}

else if ($_POST[select]==$select7) {
echo ("Eksekutive");}

else if ($_POST[select]==$select8) {
echo ("Seminar Room");}
$select=$_POST[select];?>

<?php 
$start = 800; 
$stop = 2230; 
//$number_of_rooms = 7;  

$http = $_SERVER['PHP_SELF']; 
$week_days = array("Mon","Tue","Wed","Thur","Fri","Sat","Sun"); 
$result = array(); 
$cycle = array(); 

Function search_between($val, $arr) 
{ 
  $rtn = false; 
  foreach($arr as $array) 
  { 
    if($array['startTime'] <= $val && $array['endTime'] > $val) 
{ 
      $rtn = $array; 
      break; 
    } 
  } 
  return $rtn; 
} 

Function get_last_monday($day,$month,$year) 
{ 
  $timestamp = mktime(0,0,0,$month,$day,$year); 
  While(date('w',$timestamp) != 1)  
    $timestamp -= 60*60*24; 
  return $timestamp; 
} 

$day = $_GET['day']; 
$month = $_GET['month']; 
$year = $_GET['year']; 
if(empty($_GET['day'])) $day = date('d'); 
if(empty($_GET['month'])) $month = date('m'); 
if(empty($_GET['year'])) $year = date('Y'); 


$last_monday = get_last_monday($day,$month,$year); 
$forward['day'] = date("d", ($last_monday+(8*24*3600))); 
$forward['month'] = date("m", ($last_monday+(8*24*3600))); 
$forward['year'] = date("Y", ($last_monday+(8*24*3600))); 
$back['day'] = date("d", ($last_monday-(6*24*3600))); 
$back['month'] = date("m", ($last_monday-(6*24*3600))); 
$back['year'] = date("Y", ($last_monday-(6*24*3600))); 

if(isset($_POST['confi'])) // If 'jump to day' button has been pressed 
{
  // Error notifications
  if ($_POST['day'] > 31) die("Error! There can't be that many days in a month");
  if ($_POST['month'] > 12) die("Error! There can't be that many months in a day");
  if ($_POST['year'] < 2007) die("Error! You can't set a reservation event in the past");
}

elseif(isset($_POST['confirm'])) { 
  if ($_POST['day'] > 31) die("Virhe! Montakos päivää voi olla kuukaudessa..?"); 
  if ($_POST['month'] > 12) die("Virhe! Montakos kuukautta olikaan vuodessa?"); 
  if ($_POST['year'] < 2003) die("Virhe! Onko varaus kenties menneisyydessä?"); 
  if ($_POST['hour'] > 24) die("Virhe! Montakos tuntia päivässä olikaan?"); 
  if ($_POST['minute'] > 60) die("Virhe! Montakos niitä minuutteja olikaan?"); 
  if ($_POST['hour2'] > 24) die("Virhe! Montakos tuntia päivässä olikaan?"); 
  if ($_POST['minute2'] > 60) die("Virhe! Montakos niitä minuutteja olikaan?"); 
  if ($_POST['hour'] > $_POST['hour2']) die("Virhe! Aloitustunti on suurempi kuin lopetustunti!"); 
   
  
$contents .= ' 
    <table cellpadding="6" border="0" width="100%"> 
    <tr> 
      <td align="left"> 
        Today Date: '.date("d.m.Y", $last_monday).' - '.date("d.m.Y", ($last_monday+6*24*3600)).'<br> 
        <a href="MRview.php?day='.$back['day'].'&month='.$back['month'].'&year='.$back['year'].'">[Previous Day]</a> 
        <a href="MRview.php?day='.date('d').'&month='.date('m').'&year='.date('Y').'">[This Day]</a> 
        <a href="MRview.php?day='.$forward['day'].'&month='.$forward['month'].'&year='.$forward['year'].'">[Next Day]</a><br> 
      </td> 
      <td align="right"> 
        <form method="get" action="MRview.php" style="margin: 0px;"> 
        Jump To: 
        <input type="text" size="2" value="'.$day.'" maxlength="2" name="day"> <b>.</b> 
        <input type="text" size="2" value="'.$month.'" maxlength="2" name="month"> <b>.</b> 
        <input type="text" size="4" value="'.$year.'" maxlength="4" name="year"> 
        <input type="submit" value=">>"> 
        </form> 
      </td> 
    </tr> 
    </table> 
    <table cellspacing="0" cellpadding="1" width="100%"> 
    <tr> 
      <td class="cornercell"> Time </td> 
  '; 

for($f=0;$f<7;$f++) 
{ 
  $contents .= "    <td class=\"daycell\"> ".$week_days[$f]." ".date("d.m.Y",$last_monday+($f*60*60*24))." </td>\n"; 
  $set[$g] = 0; 
} 

$contents .= "    </tr>\n"; 

for($i=$start; $i<$stop; $i=$i+50) 
{ 
  $contents .= "    <tr>\n"; 
   
  $first_num = substr($i, 0, -2); 
  if(substr($i, -2) == 50) $last_num = '30'; else $last_num = '00'; 
  if($last_num == 30) { $sec_last_num = '00'; $sec_first_num = $first_num+1; } else { $sec_last_num = '30'; $sec_first_num = $first_num; } 
  $contents .= "      <td class=\"timecell\">".$first_num.":".$last_num."-".$sec_first_num.":".$sec_last_num."</td>\n"; 
  
$query1  = "SELECT MRname FROM booking WHERE  MRname='$select'";
$result1 = mysql_query($query1);
$row=mysql_fetch_assoc($result1);

do{ 
for($g=0; $g<7; $g++) 
{ 
    $seek_time = $g*24*60*60+$last_monday+($first_num*60*60+$last_num*60); 
    $s_result = search_between($seek_time, $result); 
    if(!$s_result) 
{ 
      $MRview = " "; 
      $not_found = false; 
    } else 
{ 
      $not_found = true; 

      $MRname = stripslashes($s_result['MRname']); 
       
     
      if($cycle[$g] == 0 && (($s_result['endTime'] - $s_result['startTime'])/60/30) >= 1) 
  { 
        
        $cycle[$g] = ($s_result['endTime'] - $s_result['startTime'])/60/30; 
        $begin = 1; 
      } 
    } 
     
    if($cycle[$g] == 0) 
{ 
      $contents .= "      <td class=\"concell\"> </td>\n"; 
    } elseif($begin == 1) 
{ 
      $contents .= "      <td class=\"setcell\" rowspan=\"".$cycle[$g]."\">"; 
      if($not_found) 
        $contents .= '<a href="'.$http.'?act=poista&id='.$s_result['id'].'&day='.$day.'&month='.$month.'&year='.$year.'">[D]</a> '; 
      $contents .= $MRname."</td>\n"; 
      $begin = 0; 
    } 
    if($cycle[$g] > 0) 
{ 
      $cycle[$g]--; 
    } 
  } 
  $contents .= "    </tr>\n"; 
} while($row=mysql_fetch_assoc($result1));

/* $contents .= ' 
    </table><br> 
     
    <form action="'.$http.'?day='.$day.'&month='.$month.'&year='.$year.'" method="post" name="form"> 
    <table border="0" cellpadding="3" cellspacing="0" width="98%"> 
    <tr> 
      <td valign="middle" align="left">Varattava aika</td> 
      <td valign="middle" align="left"> 
        <input type="text" size="2" value="'.$day.'" maxlength="2" name="day"> <b>.</b> 
        <input type="text" size="2" value="'.$month.'" maxlength="2" name="month"> <b>.</b> 
        <input type="text" size="4" value="'.$year.'" maxlength="4" name="year"> 
        klo: <select name="hour" size="1"> 
  '; 
           
  for($r=substr($start, 0, -2); $r<=substr($stop, 0, -2); $r++) 
    $contents .= '        <option value="'.$r.'">'.$r."</option>\n"; 
     
$contents .= ' 
        </select> <b>:</b> 
        <select name="minute" size="1"> 
           <option value="00">00</option> 
           <option value="30">30</option> 
        </select> - 
        <select name="hour2" size="1"> 
  '; 
         
  for($r=substr($start, 0, -2); $r<=substr($stop, 0, -2); $r++) 
    $contents .= '        <option value="'.$r.'">'.$r."</option>\n"; */
     
  $contents .= ' 
      
    </table> 
    </form> 
'; 
print $contents; 
?>

</table>
</td>
</tr>

</td>
</tr>
</table>
<table align="center" border="0" width="800" cellspacing="0" cellpadding="0">
<td rowspan="1" width="30%">
<p align="center" style="margin-top: 0; margin-bottom: 0"> </p>
<p align="center" style="margin-top: 0; margin-bottom: 0"> </p>
<p align="center" style="margin-top: 0; margin-bottom: 0">
<font size="2" face="Times New Roman">© </font>
<font face="Lucida Console" size="2">UMS Copyright 2007. All Rights Reserved.</font></p>
<p align="center" style="margin-top: 0; margin-bottom: 0"> </p>
<p align="center" style="margin-top: 0; margin-bottom: 0">
<font face="Lucida Console" size="2">University Malaysia Sabah</font></p>
<p align="center" style="margin-top: 0; margin-bottom: 0">
<font face="Lucida Console" size="2">88450 Kota Kinabalu</font></p>
</table></td>
</body>
</html>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.