<?php
session_start();
include('headMain_2.php');
//echo $_SESSION['school'];
if (isset($_SESSION['school'])){
   echo  $_SESSION['school'];
   echo  $_SESSION['session'];
   $ff=  $_SESSION['levelID'];

    $queryq="SELECT levelName FROM leveltb where id='$ff'";
    $rsq=$db->query($queryq);
    $ff_fetch=$rsq->fetch(PDO::FETCH_BOTH);
    $levelName=$ff_fetch['levelName'];
   echo  $_SESSION['status'];
}
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */



?>
<script src="../SpryAssets/SpryMenuBar.js" type="text/javascript"></script>

<script type="text/javascript" language="javascript" src="../js/jquery-1.7.1.js"></script>
<script type="text/javascript" language="javascript" src="../js/scriptFile.js"></script>
<script type="text/javascript" language="javascript" src="../js/scriptLga.js"></script>

<div class="row">
    <div class="col-lg-1"></div>
    <div class="col-lg-8">
        <div class="panel panel-default">
            <div class="panel-heading">
                Uploading Admitted List
            </div>
            <div class="panel-body">

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

                        <table width="100%" cellspacing="5" cellpadding="3">
                            <tr>
                                <td>
                                    <table width="60%" align="center" cellpadding="3" cellspacing="5">
                                        <tr>
                                            <td><form id="form1" name="form1" method="post" action="schoolFeesAmountNew_process.php">
                                                    <fieldset>
                                                        <legend>Payment Fees</legend>
                                                        <table width="100%" cellspacing="5" cellpadding="3">
                                                            <tr>
                                                                <td>School</td>
                                                                <td>&nbsp;</td>
                                                                <td><select name="school" id="school" class="form-control">
                                                                        <?php
                                                                      //  require('../connect.php');
                                                                       // $db=db_connect();
                                                                        $query="SELECT distinct feesSchool FROM dept";
                                                                        $rs=$db->query($query);
                                                                        //$rs_fetch=$rs->fetch(PDO::FETCH_BOTH);
                                                                        echo '<option selected="selected">'.$_SESSION['school'].'</option>';
                                                                        while ($row=$rs->fetch(PDO::FETCH_BOTH)){
                                                                            //$row=mysql_fetch_row($rs);
                                                                            echo '<option>'.$row[0].'</option>';
                                                                        }
                                                                        ?>
                                                                    </select></td>
                                                            </tr>
                                                            <tr>
                                                                <td>Department</td>
                                                                <td>&nbsp;</td>
                                                                <td id="dept">&nbsp;</td>
                                                            </tr>
                                                            <tr>
                                                                <td>Level</td>
                                                                <td>&nbsp;</td>
                                                                <td><select name="levelID" id="levelID" class="form-control">
                                                                        <?php

                                                                        $query="SELECT * FROM leveltb";
                                                                        $rs1=$db->query($query);
                                                                        echo '<option selected="selected" value='.$ff.'>'.$levelName.'</option>';

                                                                        while ($row1=$rs1->fetch(PDO::FETCH_BOTH)){

                                                                            echo '<option value='.$row1[0].'>'.$row1[1].'</option>';
                                                                        }
                                                                        ?>
                                                                    </select></td>
                                                            </tr>
                                                            <tr>
                                                                <td>Session</td>
                                                                <td>&nbsp;</td>
                                                                <td><select name="asession" id="txtstate" class="form-control">
                                                                        <?php

                                                                        $query="SELECT distinct asession FROM current WHERE sn=2";
                                                                        $rs2=$db->query($query);
//                                                                        echo '<option selected="selected">'.$_SESSION['session'].'</option>';

                                                                        while ($row2=$rs2->fetch(PDO::FETCH_BOTH)){
                                                                            echo '<option>'.$row2[0].'</option>';
                                                                        }
                                                                        ?>
                                                                    </select></td>
                                                            </tr>
                                                            <tr>
                                                                <td>Status</td>
                                                                <td>&nbsp;</td>
                                                                <td><label for="status"></label>
                                                                    <select name="status" id="status" class="form-control">
                                                                       <?php echo '<option selected="selected">'.$_SESSION['status'].'</option>' ;?>;
                                                                        <option >Ex-Student</option>
                                                                        <option  >Repeater</option>
                                                                        <option >Normal</option>
                                                                        <option>PreND</option>
                                                                    </select></td>
                                                            </tr>
                                                            <tr>
                                                                <td>Session</td>
                                                                <td>&nbsp;</td>
                                                                <td><select name="a_code" id="a_code" class="form-control">
                                                                        <?php

                                                                        $query1="SELECT * FROM schoolfeecode";
                                                                        $rs21=$db->query($query1);

                                                                        while ($row21=$rs21->fetch(PDO::FETCH_BOTH)){
                                                                            echo '<option value="'.$row21[1].'">'.$row21[2].'</option>';
                                                                        }
                                                                        ?>
                                                                    </select></td>
                                                            </tr>
                                                            <tr>
                                                                <td>Amount</td>
                                                                <td>&nbsp;</td>
                                                                <td><label for="amount"></label>
                                                                    <input type="text" name="amount"  id="txtRound" class="form-control" /></td>
                                                            </tr>
                                                            <tr>
                                                                <td>&nbsp;</td>
                                                                <td>&nbsp;</td>
                                                                <td><input type="submit" name="button" id="button" value="Submit" class="btn btn-primary" /></td>
                                                            </tr>
                                                        </table>
                                                    </fieldset>
                                                </form></td>
                                        </tr>
                                    </table>
                                    <!-- InstanceEndEditable --></td>
                            </tr>
                        </table>                            </td>
                        </tr>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

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