<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */
include('headMain_2.php');
if (isset($_GET['matNo'])){
    $matNo=$_GET['matNo'];
     $asession=$_GET['asession'];
     $courseCode=$_GET['courseCode'];

}
echo '<div align="right"><a href="javascript:history.go(-1)"> Go to Previous page</a></div>';
?>
    <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">
                Score Details
            </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="viewRawScore_process.php" method="post"  name="form1" id="form1">
                      <table width="100%" cellspacing="5" cellpadding="3">
                          <tr>
                              <?php

                              if (isset($_GET['id'])){
                                  if ($_GET['id']==1){
                                      echo '<td colspan="3"  class="alert alert-success"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Record Updated Successfully';
                                  }elseif($_GET['id']==3){
                                      echo ' <td colspan="3" class="alert alert-danger"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Record Failed to Update';
                                  }elseif($_GET['id']==4){
                                      echo  ' <td colspan="3" class="alert alert-danger" align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Password Mismatch';
                                  }
                              }
                              ?>
                              </td>
                          </tr>
                          <tr>
                            <td><strong>Session</strong></td>
                            <td>&nbsp;</td>
                            <td>
                                <input type="text" class="form-control" value="<?php echo $asession;?>" readonly  name="asession">
                          <tr>
                              <td><strong>Course Code</strong></td>
                              <td>&nbsp;</td>
                              <td>
                                  <input type="text" class="form-control" value="<?php echo $courseCode;?>"  readonly name="courseCode">

                              </td>
                          </tr><tr>
                              <td><strong>Matric No</strong></td>
                              <td>&nbsp;</td>
                              <td>
                                  <input type="text" class="form-control" value="<?php echo $matNo;?>" readonly  name="matNo">

                                 </td>
                          </tr>
                        </tr>
                          <?php
                          $sql_d=$db->query("select * from rawscore where matNo='$matNo' and asession='$asession' and courseCode='$courseCode'");
                          $sql_d_count=$sql_d->rowCount();
                          $sql_d_fetch=$sql_d->fetch(PDO::FETCH_BOTH);
                          if ($sql_d_count==1){
                              $score=$sql_d_fetch['score'];
                              $grade=$sql_d_fetch['grade'];
                              $cpoint=$sql_d_fetch['cpoint'];
                              $level=$sql_d_fetch['level'];
                          }
                          ?>
                          <tr>
                              <td><strong>Score</strong></td>
                              <td>&nbsp;</td>
                              <td><br>

                                  <input type="text" class="form-control" value="<?php echo $score;?>" maxlength="2" name="score">
                          </tr>
                          <tr>
                              <td><strong>Grade</strong></td>
                              <td>&nbsp;</td>
                              <td><br>

                                  <input type="text" class="form-control" value="<?php echo $grade;?>" maxlength="2" name="grade">
                          </tr>
                          <tr>
                              <td><strong>C. Point</strong></td>
                              <td>&nbsp;</td>
                              <td><br>

                                  <input type="text" class="form-control" value="<?php echo $cpoint;?>" maxlength="5" name="cpoint">
                          </tr>
                          <tr>
                              <td><strong>Level</strong></td>
                              <td>&nbsp;</td>
                              <td><br>

                                  <input type="text" class="form-control" value="<?php echo $level;?>" name="level">
                          </tr>



                        <tr>
                          <td colspan="3"><br><input type="submit" name="submit" id="submit" value="Edit" 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');
?>