Information |
";
$ID=$HTTP_GET_VARS["key"];
/*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 ("Action unsuccesful!");
$query="select workID,assistant,workNumber,reserved from works where access_key='$ID'";
$result=mysql_query($query) or die ("Action Unsuccesful");
$row=mysql_fetch_array($result);
$workID=$row[0];
$query="select name,resTime from reservedWorks where workID='$workID'";
$result=mysql_query($query) or die ("Action Unsuccesful");
$row1=mysql_fetch_array($result);
$row2=mysql_fetch_array($result);
$row3=mysql_fetch_array($result);
if($row[3]){
$time=$row1[1];
$date=getClearTime($time);
}
else{
$date=":";
}
$other_query="select workDescription from workTopics where workNumber='$row[2]'";
$other_result=mysql_query($other_query) or die ("Action Unsuccesful");
$other_row=mysql_fetch_array($other_result);
echo "Work: | ";
echo "$other_row[0] |
";
echo "Group member 1: | ";
echo '';
echo "$row1[0]
|
Group member 2: | ";
echo '';
echo "$row2[0]
|
Group member 3: | ";
echo '';
echo "$row3[0]
|
Reserved : | $date |
Assistant: | $row[1] |
";
mysql_close($work_link);
?>