<?php
// lf hmc convever..
session_start();
if (!isset($_SESSION['access']) or $_SESSION['access'] != 3) {
$_SESSION['access'] = 0;
session_destroy();
header('location:/sen/Modules/Login/login.php');
}
require_once 'db.php';
$db = Connect_To_Server();
$db_found = Connect_To_DB();
$ty = "Water";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title> </title>
</head>
<body>
<?php
//3/ perform database query
// for deleteing complaints.........................................................
$result = mysql_query("SELECT t1.*,t2.wing,t2.floor,t2.room FROM complaints AS t1 JOIN residents AS t2 ON t1.id = t2.login_id where Type = '{$ty}' order by serviced ", $db);
if (!$result) {
die("database selection failed:" . mysql_error());
}
//4. use returned data
//while($row = mysql_fetch_array($result)){
<a href="http://intranet.daiict.ac.in">Intranet</a>
</li>
<li>
<a href="/sen/Modules/Signout.php">Sign Out</a>
</li>
</ul>
</nav>
</fieldset>
</form>
</header>
</div>
<!-- content -->
<div class="wrapper row2">
<div id="status">
<marquee behavior="scroll" direction="left" scrollamount="20"><?php
$db_handle = Connect_To_Server();
$db_found = Connect_To_DB();
view_dhobi();
echo " And ";
view_doctor();
Close_To_Server($db_handle);
function view_dhobi()
{
$SQL_Query = "select name from dhobi_status where present='i' limit 1";
$result = mysql_query($SQL_Query);
$out = mysql_fetch_assoc($result);
$name = $out['name'];
if ($name != "") {
echo "Dhobi {$name} Is Present";
} else {
echo "No Dhobi Is Present";
function view_form_doctor()
{
$db_handle = Connect_To_Server();
$db_found = Connect_To_DB();
$SQL_Query = "select doctor_id,name from doctor";
$result = mysql_query($SQL_Query);
if ($result == false) {
echo mysql_error();
} else {
// echo "<FORM NAME='form3' METHOD='POST' ACTION='gate.php' >";
echo "<table>";
echo "<tr><td>Doctor Name: </td><td><select name='doctor_id'>";
while ($out = mysql_fetch_assoc($result)) {
$name = $out['name'];
$doctor_id = $out['doctor_id'];
echo "<option value={$doctor_id}> {$name} </option>";
}
echo "</td></tr>";
echo "</select>";
echo "<tr><td>";
echo "<input type='SUBMIT' NAME='SUBMIT12' VALUE='Doctor Enter' >";
echo "</td><td>";
echo "<input type='SUBMIT' NAME='SUBMIT13' VALUE='Doctor Exit' >";
echo "</td></tr>";
}
echo "</table>";
}
