</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>"; }