session_start();
if (!session_is_registered("LLC"))
{
// if session check fails, invoke error handler
header("Location: ../loginform.php");
exit();
}
$user = $_SESSION['UNAME'];
$Room = $_GET['room'];
$Task = $_GET['task'];
include("../include/dbconfig.php");
$connection = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!");
mysql_select_db($db_name);
?>
$query = "SELECT Description, Status, Place from SR_task where RoomNo='$Room' and Task='$Task'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
print <<
Edit Task of $Room
Add |
Tasks |
Status |
END;
$query = "SELECT Task, Status from SR_task where RoomNo='$Room' order by Place";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result))
{
if ($row[1] == '1')$s='Enabled';else $s='Disabled';
print <<
Edit |
$row[0] |
$s |
END;
}
?>