
 <?php include('connect.php') ?>
		
		<?php 
 if (isset($_POST['save']))

$room_name=$_POST['room_name'];
$semester=$_POST['semester'];
$sy=$_POST['sy'];

$search_query_all=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%'")or die(mysqli_error());
$search_query=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and day='MWF'  and semester like '%$semester%' and sy like '%$sy%'")or die(mysqli_error());
$search_query2=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and day='TTh'  and semester like '%$semester%' and sy like '%$sy%'")or die(mysqli_error());
$search_query1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%'")or die(mysqli_error());
$count=mysqli_num_rows($search_query);
$count2=mysqli_num_rows($search_query2);
$row=mysqli_fetch_assoc($search_query1);
$row_all=mysqli_fetch_assoc($search_query_all);


$id=$row_all['examid'];
?>
<header><style>
#foot{
margin-left:100px;

}


</style></header>
<center>
CARLOS HILADO MEMORIAL STATE COLLEGE</br>
Talisay City, Negros Occidental</br>
COLLEGE OF INDUSTRIAL TECHNOLOGY</br>
INDIVIDUAL FACULTY WORKLOAD</br>
</h5>
<table width="70%" class="report">
	<tr>
		<td>Name of Faculty: <font color="blue"><?php echo $row['room_name'];?></font></td>
		<td>School Year:&nbsp;<?php echo $row['sy']; ?></td>
		<td>Semester:&nbsp;<?php echo $row['semester']; ?>
			</td>
	</tr>
	
	
		</td>
	</tr>
	
</table><br>
<table border="1" style="border-collapse:collapse;">
  <thead>
    <tr>
      <th class="time_start"><font size="1">Time</font></th>
      <th><font size="1">First Day</font></th>
      <th><font size="1">Second Day</font></th>
      <th><font size="1">Third Day</font></th>
      
    </tr>
  </thead>
  <tbody>
  <?php
$search_rows=mysqli_fetch_array($search_query);
?>
    <tr>
      <td width="110" align="center" height="50">
	   <font size="1">
	  <b><font color="black">7:00am-8:00am</b>
	 </font>
	 </td>
      <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='7:00am' and time_end='8:00am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	   if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='7:00am' and time_end='8:00am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	 
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%thirdday%' and time_start='7:00am' and time_end='8:00am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	    
	  
	  
	   <tr>
      <td width="110" align="center">
	   <font size="1" color="black">
	  <b>8:00am-9:00am</b>
	 </font>
	 </td>
      <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='8:00am' and time_end='9:00am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='8:00am' and time_end='9:00am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	   if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='8:00am' and time_end='9:00am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   
	  
	  
	  
	  
	     <tr>
      <td width="70" align="center">
	   <font size="1" color="black">
	  <b>9:00am-10:00am</b>
	 </font>
	 </td>
      <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='9:00am' and time_end='10:am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='9:00am' and time_end='10:am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='9:00am' and time_end='10:am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	    
	  
	     <tr>
      <td width="70" align="center">
	   <font size="1" color="black">
	  <b>10:00am-11:00am</b>
	 </font>
	 </td>
      <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='10:am' and time_end='11:00am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='10:am' and time_end='11:00am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	   if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='10:am' and time_end='11:00am' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	   if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   
	   <tr>
      <td width="70" align="center">
	   <font size="1" color="black">
	  <b>11:00am-12:00pm</b>
	 </font>
	 </td>
      <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='11:00am' and time_end='12:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='11:00am' and time_end='12:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='11:00am' and time_end='12:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	   if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	    
	  <tr>
	  
      <td width="70" align="center">
	  <font size="1" color="black">
	  <b>12:00pm-1:00pm</b>
	 </font>
	</td>
     <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='12:00pm' and time_end='1:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='12:00pm' and time_end='1:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	   <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='12:00pm' and time_end='1:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	   if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
     

	  </tr>	
	  
	  
	  <tr>
      <td width="70" align="center">
	   <font size="1" color="black">
	  <b>1:00pm-2:00pm</b>
	 </font>
	</td>
 <td width="300" height="50" style="background-color:#f5f5f5;">
 <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='1:00pm' and time_end='2:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='1:00pm' and time_end='2:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='1:00pm' and time_end='2:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	   if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  <font size="1">
	  </td>
     
	  </tr>	
	  
	  
	  	  
	  
	  	          <tr>
      <td width="70" align="center">
	  <font size="1" color="black">
	  <b>2:00pm-3:00pm</b>
	 </font>
	</td>
 <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='2:00pm' and time_end='3:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	 if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['sy'];}
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
		<font size="1">	  	
		<?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='2:00pm' and time_end='3:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	 if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['sy'];}
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='2:00pm' and time_end='3:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	 if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
     
	  
	  	  
	  	          <tr>
      <td width="70" align="center">
	  <font size="1" color="black">
	  <b>3:00pm-4:00pm</b>
	 </font>
	</td>
 <td width="300" height="50" style="background-color:#f5f5f5;">
 <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='3:00pm' and time_end='4:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	 if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='3:00pm' and time_end='4:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='3:00pm' and time_end='4:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	  if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
     
	  
	  
	  	  
	  	          <tr>
      <td width="70" align="center">
	  <font size="1" color="black">
	  <b>4:00pm-5:00pm</b>
	 </font>
	</td>
     <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='4:00pm' and time_end='5:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	 if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='4:00pm' and time_end='5:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	 if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='4:00pm' and time_end='5:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	 
	  	  

	  	          <tr>
      <td width="70" align="center">
	  <font size="1" color="black">
	  <b>5:00pm-6:00pm</b>
	 </font>
	</td>
   <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='5:00pm' and time_end='6:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	 if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='5:00pm' and time_end='6:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	 if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
			  <font size="1">
	  	  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='5:00pm' and time_end='6:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	 if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
    
	  
	  	  	          <tr>
      <td width="70" align="center">
	  <font size="1" color="black">
	  <b>6:00pm-7:00pm</b>
	 </font>
	</td>
    <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='6:00pm' and time_end='7:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='6:00pm' and time_end='7:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='6:00pm' and time_end='7:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
    
	  	  		

	  	  	          <tr>
      <td width="70" align="center">
	  <font size="1" color="black">
	  <b>7:00pm-8:00pm</b>
	 </font>
	</td>
  <td width="300" height="50" style="background-color:#f5f5f5;">
	  <font size="1">
	  <?php 
	  $result=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%firstday%' and time_start='7:00pm' and time_end='8:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result);
	if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
	   <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%secondday%' and time_start='7:00pm' and time_end='8:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	 </td>

	    <td width="300" height="50" style="background-color:#f5f5f5;">
	  	  <font size="1">
		  <?php 
	  $result1=mysqli_query($conn,"select * from examsched where room_name like '%$room_name%' and semester like '%$semester%' and sy like '%$sy%' and day like '%Friday%' and time_start='7:00pm' and time_end='8:00pm' ")or die(mysqli_error());
	  $row=mysqli_fetch_array($result1);
	if($row > 0){
			echo '<div style="background-color:#65ff94;">';
	 echo $row['subject_code'];
	 echo '<br>';
	 echo $row['fname']; 
	 echo '<br>';	 
	 echo $row['course_year_section'];
	 }
	  ?>
	  </font>
	  </td>
     
	  
	  
	  

	  
	
  </tbody>
  </table></center>
  </b></br>
  <div id="foot">
  <font size="1">
 <p> I hereby certify the correctness of the above examsched of subjects
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

  Instructor's Signature</p>
 </font>
<font size="1">Prepared by:</font>
<br></br>
<font size="1">CRISTINE V. REDOBLO, MAEd, MIT
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </br>
Chairperson, BSIS </br> </br></br>

<font size="1">Recommending Approval:</font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


<br>
</br>
<font size="1">ANTONIO L. DERAJA PH. D 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;
JANET P. ESPINOSA Ph.D.
<br>
<font size="1">Dean College of Industrial Technology</font>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;
Vice President, Academic  Affairs
<br>
<br>
<br>

<font size="1">Approved:</font>
<br>
<br>





RENATO M. SOROLLA, Ph.D.

<br>

SUC President II  
  </div></div>
  </html>