<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:30 PM
 */
include('ace_headMain.php');
?>


    <div class="row">
        <div class="col-lg-12">

        </div>
        <!-- /.col-lg-12 -->
    </div>
    <!-- /.row -->
    <div class="row">
        <div class="col-lg-12">
            <div class="panel panel-info">
                <div class="panel-heading">
                    Admitted Students
                </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 >
                                <th>Form No</th>
                                <th>Full Name</th>
                                <th>Department</th>
                                <th>Level ID</th>
                                <th>Status</th>
                                <th>Mobile No.</th>
                            </tr>


                            </thead>
                            <tbody>
                            <?php
                                $i=0;
                                while ($row=$query->fetch(PDO::FETCH_BOTH)){
                                ?>
                            <tr class="odd gradeX">
                                <td><?php echo $row['formNo']; ?></td>
                                <td><?php echo $row['names']; ?></td>
                                <td><?php echo $row['course']; ?></td>
                                <td class="center"><?php $k= $row['levelID'];
                                     $r=($db->query("select levelName from leveltb where id='$k'")->fetch(PDO::FETCH_BOTH));
                                    echo $r['levelName'];?></td>
                                <td class="center"><?php echo $row['status']; ?></td>
                                <td class="center"><?php echo $row['gsm']; ?></td>
                            </tr>
                            <?php
                            ++$i;
                            }
                            ?>


                            </tbody>
                        </table>
                    </div>
                    <!-- /.table-responsive -->
                    <div class="well">
      <?php
include('footMain.php');
?>