<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-03-24
 * Time: 05:21 PM
 */
require_once('headMainAdmin.php');
//	require_once('../connect.php');
extract($_POST);

$db=db_connect();

$sql=$db->query("select * from stddata where formNo not like '%Delete%' and level='hndForm'");
// $sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
?>
    <!-- /.row -->
    <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 >
                                <th>S/N</th>
                                <th>Form No</th>
                                <th>Surname</th>
                                <th>Other Names</th>
                                <th>Department</th>
                                <th>GSM</th>
                                <th>Jamb No</th>
                                <th>Jamb Score</th>
                                <th>reg Date</th>
                                <th>Form Type</th>

                                <th>.</th>
                            </tr>


                            </thead>
                            <tbody>

                            <?php
                            $i=0;
                            while ($row=$sql->fetch(PDO::FETCH_BOTH)){
                            ?>
                            <tr class="odd gradeX">
                                <td><?php echo $i +1;?></td>
                                <td><?php echo $formNo=$row['formNo'];?></td>
                                <td><?php echo $orderID= $row['surname'];?></td>
                                <td><?php echo $row['otherNames'];?></td>
                                <td><?php
                                   echo $row['dept'];
                                    $a='True';
                                    ?></td>
                                <td><?php echo $gsm=$row['gsm'];?></td>
                                <td><?php echo $row['jambNo'];?></td>
                                <td><?php echo $row['jambScore'];?></td>
                                <td><?php echo $row['regDate'];?></td>
                                <td><?php echo $row['level'];?></td>


                                <td>
                                    <?php
                                    if ($a=='True'){
                                        echo '<a href="applyEdit.php?formNo='.$formNo.'&gsm='.$gsm.'"target="_blank">Change Details</a>';
                                    }else{
                                        // echo '<a href="print/rotherFeePrint.php?id='.$orderID.'&ptype='.$pt.'"target="_blank">Re-Print Reciept</a>';
                                    }
                                    ++$i;
                                    }
                                    ?>

                                </td>
                            </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>


<?php
include('footMain.php');
?>