<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:30 PM
 */

include('headMain.php');
$dbC = db_con_forms_connect();
$aspoa="select * from forms";
$aspoa_exe=$dbC->query($aspoa);
echo $aspoa_exe->rowCount();

?>


    <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>E Mail</th>
                                <th>Programme Type</th>
                                <th>Status</th>
                                <th>ChangeName</th>
                                <th>changeDept</th>
                            </tr>


                            </thead>
                            <tbody>
                            <?php
                                $i=0;
                                while ($row=$aspoa_exe->fetch(PDO::FETCH_BOTH)){
                                ?>
                            <tr class="odd gradeX">
                                <td><?php echo $row['applicant_id']; ?></td>
                                <td><?php echo $row['display_fullname']; ?></td>
                                <td><?php echo $row['dept']; ?></td>
                                <td><?php echo $row['email'];?></td>
                                <td><?php echo $row['progtype']; ?></td>
                                <td><?php echo $row['student_status']; ?></td>
                                <td><a href="editName.php?ID=<?php echo $row['email']; ?>">Edit Name</a></td>
                                <td><a href="editDept.php?ID=<?php echo $row['email']; ?>">Edit Dept</a></td>
                            </tr>
                            <?php
                            ++$i;
                            }
                            ?>


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