<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */
include('headMain.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">
                Uploading Courses
            </div>
            <div class="panel-body">

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

                        <table width="100%" cellspacing="5" cellpadding="3">
                            <tr>
                                <td><table width="100%" align="center" cellpadding="3" cellspacing="5">
                                        <tr>
                                            <td><fieldset>
                                                    <legend>
                                                        <form action="coursePool_process.php" method="post" enctype="multipart/form-data" name="import" id="import">
                                                            <div>School <select name="school" id="school" class="form-control" >
                                                                    <?php
                                                                    $query="SELECT distinct dSchool FROM dept";
                                                                    $rs=$db->query($query);
                                                                    echo '<option>'.'Select Option...'.'</option>';
                                                                    while ($row=$rs->fetch(PDO::FETCH_BOTH)){

                                                                        echo '<option>'.$row[0].'</option>';
                                                                    }
                                                                    ?>
                                                                </select></div>

<div>Department<select name="dept" id="dept" class="form-control">
        <option>Select Option...</option>
    </select></div>
                                                            <div>Level <select name="levelID" id="levelID" class="form-control" >
                                                                    <?php
                                                                    $querya="SELECT * FROM leveltb";
                                                                    $rsa=$db->query($querya);
                                                                    echo '<option>'.'Select Option...'.'</option>';
                                                                    while ($row=$rsa->fetch(PDO::FETCH_BOTH)){

                                                                        echo '<option value="'.$row[0].'">'.$row[1].'</option>';
                                                                    }
                                                                    ?>
                                                                </select></div>
                                                            <div>Semester<select name="semester" id="semester" class="form-control" >
                                                                    <option>First Semester</option>
                                                                    <option>Second Semester</option>
                                                                </select></div>
                                                            <input type="file" name="file" required="required" />
                                                            <br />
                                                            <div>

                                                            </div>
                                                           <div style="color: red" colspan="3"><hr><div class="alert-info"><h3>Note: The CSV file should follows this order:</h3></div>
                                                                    <br>column 1=>Course Code SN<br> column 2=>Course Title<br> column 3=>Course Unit</div>

                                                            <input type="submit" name="submit" value="Upload" id="btn" class="btn btn-primary" />
                                                        </form>
                                                </fieldset>
                                            </td>
                                        </tr>
                                    </table>
                                </td>
                            </tr>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

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