</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";
    }
Example #2
0
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>";
}