<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */
include('headMain_2.php');
?>
    <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/scriptFileLong.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">
                Select School for Semester Result Scores
            </div>
            <div class="panel-body">

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

                        <table width="100%" cellspacing="5" cellpadding="3">
                            <tr>
                  <td><fieldset>

                    <form action="rawscoreInfo.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
                      <table width="100%" cellspacing="5" cellpadding="3">
                        <tr>
                            <td><strong>Select School</strong></td>
                            <td>&nbsp;</td>
                            <td>
                                <select class="form-control" name="school" required="">
                                    <?php
                                    $sql=$db->query("select distinct school from rawscore");
                                    while($row=$sql->fetch(PDO::FETCH_BOTH)){
                                        echo '<option>'.$row['school'].'</option>';
                                    }
                                    ?>

                                </select>
                          <tr>
                              <td><strong>Select Department</strong></td>
                              <td>&nbsp;</td>
                              <td><br>
                                  <select class="form-control" name="dept" required="">
                                      <?php
                                      $sql=$db->query("select distinct dept from rawscore");
                                      while($row=$sql->fetch(PDO::FETCH_BOTH)){
                                          echo '<option>'.$row['dept'].'</option>';
                                      }
                                      ?>

                                  </select>
                          </tr>
                        </tr>
                          <tr>
                              <td><strong>Select Session</strong></td>
                              <td>&nbsp;</td>
                              <td><br>
                                  <select class="form-control" name="asession" required="">
                                      <?php
                                      $sql=$db->query("select distinct asession from rawcgpa");
                                      while($row=$sql->fetch(PDO::FETCH_BOTH)){
                                          echo '<option>'.$row['asession'].'</option>';
                                      }
                                      ?>

                                  </select>
                          </tr>
                          <tr>
                              <td><strong>Select Level</strong></td>
                              <td>&nbsp;</td>
                              <td><br>
                                  <select class="form-control" name="level" required="">
                                      <?php
                                      $sql=$db->query("select distinct level from rawscore");
                                      while($row=$sql->fetch(PDO::FETCH_BOTH)){
                                          echo '<option>'.$row['level'].'</option>';
                                      }
                                      ?>

                                  </select>
                          </tr>



                        <tr>
                          <td colspan="3"><br><input type="submit" name="submit" id="submit" value="Check" class="btn btn-primary form-control" /></td>
                        </tr>

                      </table>

                    </form>

                  </fieldset></td>
                            </tr>
                        </table>
                        </td>
                        </tr>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

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