Name | Student ID | Work |
Date | Grade | Assistant |
';
if($byPeriod==yes){
$query=$query."(unixTime <= $etime and unixTime >=$btime) and";
}
if($byNumber==yes){
$query=$query." (studentID <= $elimit and studentID >= $blimit) and";
}
if($byWork==yes){
$query=$query." (work='$work') and";
}
if($byAssistant==yes){
$query=$query." (assistant='$assistant') and";
}
if($byGrade==yes){
$query=$query." (grade>=$bgrade and grade<=$egrade) and";
}
$query=$query." (grade!='7'))";
//echo "$query";
/*The file contains authentication information*/
require "/home/www/data/labReservation.conf";
$work_link=mysql_connect($host,$user,$passwd);
mysql_select_db("labReservation",$work_link) or die ("Couldn't select!");
$result=mysql_query($query) or die ("Couldn't query");
while ($row=mysql_fetch_array($result)){
echo "$row[0] | $row[2] | $row[1] | $row[3] | ";
if($row[5]==6)
echo "Approved | ";
else
echo "$row[5] | ";
echo "$row[4] |
";
}
echo "";
//echo $query;
}
else{
echo 'This service demands valid authentication.';
}
?>