<?php
require_once('headMain_dsa.php');
?>

			<?php
            extract($_POST);
			require_once('../connect.php');
            $db=db_connect();
 $sql1="select * from realdata where `matNo`='$serial' or gsm='$serial'";
 $result1=$db->query($sql1);
 $num=$result1->rowCount();
            $result1_fetch=$result1->fetch(PDO::FETCH_BOTH);
            //echo $num;
$levelID=$result1_fetch['levelID'];
$aspoa1=$db->query("select * from leveltb where id='$levelID'");
if ($aspoa1->rowCount()==1){
    $aspoa1_fet=$aspoa1->fetch(PDO::FETCH_BOTH);
    $levelN=$aspoa1_fet[1];
}else{
    $levelN=0;
}
 if ($num>0){
            ?>
<fieldset>

    <legend><h2>Student Details</h2></legend>
    <table width="100%" cellspacing="5" cellpadding="3">
        <tr>
            <td width="52%"><strong>Matric Numberr</strong></td>
            <td width="48%"><?php echo $result1_fetch['matNo'];?></td>
        </tr>
        <tr> <td><strong>Full Name</strong></td>  <td><?php echo $result1_fetch['names'] ;?></td>  </tr>
        <tr><td><strong>Department/Course</strong></td>	<td><?php echo $result1_fetch['course'];?></td>   </tr>
			    <tr> <td><strong>Level Name </strong></td>	 <td><?php echo $levelN;?></td> </tr>
			    <tr><td><strong>GSM</strong></td> <td><?php echo $result1_fetch['gsm'];?></td></tr>
			    <tr><td><strong>State</strong></td> <td><?php echo $result1_fetch['state'];?></td></tr>
			    <tr><td><strong>LGA</strong></td> <td><?php echo $result1_fetch['lga'];?></td></tr>
			    <tr><td><strong>Gender</strong></td> <td><?php echo $result1_fetch['sex'];?></td></tr>
			    <tr><td><strong>Address</strong></td> <td><?php echo $result1_fetch['address'];?></td></tr>
			    <tr><td><strong>Student Status (Graduated)</strong></td> <td><?php echo $result1_fetch['graduated'];?></td></tr>

<tr><td colspan="2"><hr></td></tr>


			    <tr><td><strong>Parent/Guardian Name </strong></td><td><?php echo $result1_fetch['gNames'];?></td></tr>
			    <tr><td><strong>Parent/Guardian GSM </strong></td><td><?php echo $result1_fetch['gGSM'];?></td></tr>
			    <tr><td><strong>Parent/Guardian Address </strong></td><td><?php echo $result1_fetch['gAddress'];?></td></tr>
<!--			    <tr><td><strong>Parent/Guardian Address </strong></td><td>--><?php //echo $result1_fetch['gAddress'];?><!--</td></tr>-->
			    </table>
			</fieldset>
			<?php
}else{
	 echo 'No record Found';
 }

?>
    <div align="left"><a href="javascript:history.go(-1)" style="font-size: 18px"> Go to Previous page</a></div> <hr>
			
			<!-- InstanceEndEditable --></td>
            <td align="right" valign="top"><!-- InstanceBeginEditable name="EditRegion4" --><!-- InstanceEndEditable --></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
<p>&nbsp;</p>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
</script>
</body>
<!-- InstanceEnd --></html>
<?php
include('footMain.php');
?>