<?php
// include ('../connect.php');
require_once('headMain_sidebar.php');
?>
<!-- Page Content -->

<div class="container">
 <div class="row">
            <div class="col-lg-12" style="color: #900000">
                <h1 class="page-header"></h1>
				<?php
					if(isset($_POST['origin'])) {
					$_SESSION['origin'] = $_POST['origin'];
					}
					if(isset($_POST['compute'])){
					$_SESSION['compute'] = $_POST['compute'];
					}
					//$db=db_connect();
				//   $con = new mysqli($hostname,$username,$password,$database);
					//if(mysqli_connect_errno()) {
				//		printf("Failed to Connect to MYSQL", mysqli_connect_error());
					//	exit();
					//}
				
				if(isset($_SESSION['origin'])) {

                ?>
                <div class="row">
                    <div class="col-lg-12">
                        <div class="panel panel-info">
                            <div class="panel-heading">
                                Application Details
                            </div>
                            <!-- /.panel-heading -->
                            <div class="panel-body">
                                <div class="dataTable_wrapper">
                                    <table class="table table-striped table-bordered table-hover"
                                           id="dataTables-example">
                                        <thead>
                                        <tr class="success">
                                            <th>SN</th>
                                            <th>Form No</th>
                                            <th>Surname</th>
                                            <th>Other Names</th>
                                            <th>JAMB Number</th>
                                            <th>UTME Score</th>
                                        </tr>
                                        </thead>
                                        <?php
                                        //$rows_per_page = 50;
                                        $query = "select count(formno) from stddata where `level`='utmeForm'";
                                        $result = $db->query($query);
                                        $total_records = $result->rowCount();
                                        //$total_pages = ceil($total_records / $rows_per_page);
                                        //if (isset($_GET["page"])) {
                                        //	$page  = $_GET["page"];
                                        //	}
                                        //else
                                        //{
                                        //	$page=1;
                                        //}
                                        //$begin = ($page-1) * $rows_per_page;
                                        $query = "select formno,surname,othernames,jambno,jambscore from stddata where `level`='utmeForm' order by jambscore desc";
                                        $result = $db->query($query);

                                        if (!$result) {
                                            echo "Error in querying database.<br>\n";
                                        }
                                        //$i = $begin + 1;
                                        while ($row = $result->fetch(PDO::FETCH_BOTH)) {
                                            echo "<tr>";
                                            echo "<td>" . $i . "</td>";
                                            echo "<td>" . $row["formno"] . "</td>";
                                            echo "<td>" . $row["surname"] . "</td>";
                                            echo "<td>" . $row["othernames"] . "</td>";
                                            echo "<td>" . $row["jambno"] . "</td>";
                                            echo "<td style=\"text-align:center\">" . $row["jambscore"] . "</td>";
                                            echo "</tr>\n";
                                            $i++;
                                        }

                                        ?>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
 </div>
</div>

    <div class="panel-body">
        <!--<p><div class="col-lg-2 "><img src="images/rector.jpg" class="img-circle " width="140" height="140"></div>-->
        <div class="col-lg-9 col-lg-offset-1 text-center">
            <form action='admission_req_compute.php' method='post'>
                <input type="submit" name="compute" value="Click here to display computed List"/>
            </form>
        </div>
    </div>

<hr>

    <!-- Footer -->

    <footer>
        <div class="row">
            <div class="col-lg-12">
                <p style="color: #900000" ; align="center">Powered By Information and Communication Technology |
                    2015</p>
            </div>
        </div>
    </footer>
    <!-- /.container -->

    <!-- jQuery -->
    <script src="../js/jquery.js"></script>

    <!-- Bootstrap Core JavaScript -->
    <script src="../js/bootstrap.min.js"></script>
<?php
}
require_once('footMain.php');
?>