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

$db=db_connect();

                    $sql=$db->query("select * from entrancetable");
                   // $sql_fetch=$sql->fetch(PDO::FETCH_BOTH);



				?>
    <div class="row">
        <div class="col-lg-10">

        </div>
        <!-- /.col-lg-12 -->
    </div>
    <!-- /.row -->
    <div class="row">
    <div class="col-lg-10 col-lg-offset-1" >
    <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>Surname</th>
        <th>Other Names</th>
        <th>Department</th>
        <th>GSM</th>
        <th>e-Mail</th>
        <th>Trans ID</th>
        <th>Date Created</th>
        <th>Form Type</th>
        <th>Form No</th>
        <th>Password</th>
        <th>Status Change</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 $orderID= $row['surname'];?></td>
                    <td><?php echo $row['othernames'];?></td>

                    <td><?php
                        $deptID= $row['dept'];
                        $sql_dept=$db->query("select * from dept where sn='$deptID'");
                        $sql_dept_fetch=$sql_dept->fetch(PDO::FETCH_BOTH);
                        echo $sql_dept_fetch['dOption'];
                        //echo $deptID;
                        $a='True';
                        ?></td>
                    <td><?php echo $gsm=$row['gsm']; ?></td>

                    <td><?php echo $row['email'];?></td>
                    <td><?php echo $TransID=$row['transID'];?></td>
                    <td><?php echo $row['dateCreated'];?></td>
                    <td><?php echo $row['formType'];?></td>
                    <td><?php echo $row['formNo'];?></td>
                    <td><?php echo md5($row['password']);?></td>
                    <td>
                        <?php
                        if ($a=='True'){
                            echo '<a href="passwordChanged.php?id='.$TransID.'&gsm='.$gsm.'"target="_blank">Change Password</a>';
                        }else{
                           // echo '<a href="print/rotherFeePrint.php?id='.$orderID.'&ptype='.$pt.'"target="_blank">Re-Print Reciept</a>';
                        }
                        ++$i;
                        }
                        ?>


                    </td>
                </tr>
            </table>
        </form>
        <p>&nbsp;</p>
    </fieldset></td>
</tr>
</table>
    </div>
    </div>
    </div>
    </div>
    </div>

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