<?php
error_reporting(0);
define('INCLUDE_CHECK',true);
session_start();
require ('classes/config.php');
require_once('classes/session.php');
			 		   
?>



<!DOCTYPE html>
<html>
<head>
<title>OSCOTECH | Admitted List</title>
<link href="http://oscotechesaoke.edu.ng/admission_portal/layout/css/bootstrap.login.css" rel="stylesheet" type="text/css" media="all" />
<link href="http://oscotechesaoke.edu.ng/admission_portal/layout/css/login.css" rel="stylesheet" type="text/css" media="all" />		
<link rel="shortcut icon" href="../images/favicon.ico">
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<link href='http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700,800' rel='stylesheet' type='text/css'>
<style type="text/css">
	body{margin-top:-40px; padding:0; top:0;}
</style>
</head>
<body>
	<div style="width:97%; margin:0 auto"> 
        <center>
        <h1 style="font-weight:bold; font-size:25px">OFFICE OF HIGHER EDUCATION, BURSARY AND SCHOLARSHIPS, OSOGBO<br>
    	<br>STUDENT BIO - DATA</h1>
    	<br>
        <table class="table  table-condensed " style="width:850px; font-size:12px">
        	<thead>
                <tr height="10px">
                    <td><strong>(1) NAME OF INSTITUTION:</strong> OSUN STATE COLLEGE OF TECHNOLOGY, ESA-OKE</td>
                </tr>
                <tr>
                    <td><strong>(2) COLLEGE/FACULTY:</strong> <?php echo strtoupper(substr($_SESSION['faculty'],11))?></td>
                </tr> 
                <tr>
                    <td><strong>(3) DEPARTMENT:</strong> <?php echo strtoupper($_SESSION['programme']. " " .$_SESSION['courses'])?> </td>
                </tr>
            </table>
        <table class="table table-bordered  table-condensed table-responsive" style="width:750px; font-size:12px">
        	<thead>
                <tr height="10px">
                    <th>S/N</th>
                    <th>FULLNAME</th>
                    <th>MATRIC NO</th>
                    <th>SEX</th>
                    <th>MARITAL STATUS</th>
                    <th>DOB</th>
                    <th>PHONE</th>
                    <th>YEAR OF ENTRY</th>
                    <th>GRADUATION YEAR</th>
                    <th>STATE</th>
                    <th>L.G.A.</th>
                    <th>HOME TOWN</th>
                </tr>
            </thead>
        						<?php
								if($_SESSION[fromdate]=="" || $_SESSION[todate]=="")
								
								$sql = mysql_query("SELECT DISTINCT * FROM course_register
										WHERE matricno LIKE '%162%'
										AND semester='First'
										AND courses='$_SESSION[courses]'
										AND level='$_SESSION[programme]'
										AND session='$_SESSION[sek]' 
										ORDER BY matricno ASC");
                        $i=0;
                        while($row=mysql_fetch_array($sql)){
                        $i++;
                        $color=($i%2==0)?"lightblue":"white";
                        if ($row['session']=='2016/2017'){$grad='2017/2018';}
                        if ($row['session']=='2017/2018'){$grad='2018/2019';}
												
                    ?>
                                    <tbody>
                                        <tr height="10px" >
                                        	<td><?php echo $i;?></td>
                                            <td width="300px"><?php echo strtoupper($row['surname']. " " . $row['othername']);?></td>
                                            <td><?php echo $row['matricno'];?></td>
                                            <td><?php echo strtoupper(substr($row['sex'],0,1));?></td>
                                            <td><?php echo $row['mstatus'];?></td>
                                            <td><?php echo $row['dob'];?></td>
                                            <td><?php echo $row['phone'];?></td>
                                            <td><?php echo $row['session'];?></td>
                                            <td><?php echo $grad;?></td>
                                            <td><?php echo $row['state'];?></td>
                                            <td><?php echo $row['lga'];?></td>
                                            <td><?php echo $row['hometown'];?></td>
                                        </tr>
                                    </tbody>
                          <?php	
							}														
							?>
                                </table>
        
                           
        </center>
    </div>
    	<br>
    <center>
   		<INPUT TYPE="button" class="btn btn-success " VALUE="PRINT" ONCLICK="self.print();">
    </center>
    <br>
</body>
</html>

<?php mysql_close();  ?>