<?php 
include ("kfunctions.php");
?>

<html>
<head>
<?php kheader(); ?>
</head>
<body>

    <div id="wrapper">

        <!-- Navigation -->
        <nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
            <!-- Brand and toggle get grouped for better mobile display -->
            <?php ktopbar(); ?>
            <!-- Sidebar Menu Items - These collapse to the responsive navigation menu on small screens -->
            <?php kleftbar(); ?>
            <!-- /.navbar-collapse -->
        </nav>

        <div id="page-wrapper">

            <div class="container-fluid">

      

                <!-- /.row -->

                            <?php

if(isset($_POST["adminsubmit"])){

include ("connect.php");
$cid=$_POST["cid"];
$fname=$_POST["fname"];
$sname=$_POST["sname"];
$gender=$_POST["gender"];
$c16=$_POST["c16"];
$orgfee=$_POST["orgfee"];
$ownfee=$_POST["ownfee"];
$comment=$_POST["comment"];
$r1=$_POST["r1"];
$r2=$_POST["r2"];
$r3=$_POST["r3"];
$totalfee = $orgfee + $ownfee;

include ("uploads.php");
$count=$dbh->exec("insert into children (cid,fname,sname,gender,c16,img,orgfee,ownfee,totalfee,status,comment,bbf,t1,t1r,r1,t2r,r2,t3r,r3,t2,t3) values('$cid','$fname','$sname','$gender','$c16','$img','$orgfee','$ownfee','$totalfee','Active','$comment','$ownfee','$ownfee','$r1','$r1','$r2','$r2','$r3','$r3','$ownfee','$ownfee')"); 

echo "<div class='alert alert-success'> Details on ".$fname." ".$sname." have been submitted. </div>";

}
?>

                   
<div class="col-lg-12">
                        <div class="panel panel-yellow">
                            <div class="panel-heading">
                                <h3 class="panel-title">Requirements</h3>
                            </div>
                            <div class="panel-body">
                                <div class='col-lg-3'>
                <select name="year" class="form-control">
<option value="">Year</option>
<option value="17">2017</option>
<option value="16">2016</option>
<option value="18">2018</option>
<option value="19">2019</option>
<option value="20">2020</option>

                  </select>
                  </div>

                  <div class='col-lg-3'>
<select class="form-control" name="term">
<option value="">Term</option>
<option value="1">Term I </option>
<option value="2">Term II </option>
<option value="3">Term III </option>
<option value="4">All Terms</option>
</select>
</div>

                  <div class='col-lg-3'>
<select class="form-control" name="class">
<option value="">Class</option>
<option value="0.1"> Baby class </option>
<option value="0.2"> Middle class </option>
<option value="0.3"> Top class </option>
<option value="1"> Primary 1 </option>
<option value="2"> Primary 2 </option>
<option value="3"> Primary 3 </option>
<option value="4"> Primary 4 </option>
<option value="5"> Primary 5 </option>
<option value="6"> Primary 6 </option>
<option value="7"> Primary 7 </option>

</select>
                  </div>

                  <div class='col-lg-3'>
                    <input type="text" name="schoolfees" class="form-control" placeholder="School Fees">
                  </div>
<br><br>
                  <div class='col-lg-3'>
Uniform <input type="text" name="uni" class="form-control">
                  </div>

                  <div class='col-lg-3'>
Contribution <input type="text" name="cont" class="form-control">
                  </div>

                  <div class='col-lg-3'>
Registration <input type="text" name="reg" class="form-control">
                  </div>

                  <div class='col-lg-3'>
Holiday <input type="text" name="hol" class="form-control">
                  <br>
                  </div>
                  
                  <div class='col-lg-3'>
Admission <input type="text" name="adm" class="form-control">
                  </div>

                  <div class='col-lg-3'>
Transport <input type="text" name="tp" class="form-control">
                  </div>

                  <div class='col-lg-3'>
Mocks and Facilitation <input type="text" name="cont" class="form-control">
                  </div>

                  <div class='col-lg-3'>
Other 1  <input type="text" name="o1" class="form-control">
                  <br>
                  </div>

<div class='col-lg-3'>
Other 2  <input type="text" name="o2" class="form-control">
                  </div>

                  <div class='col-lg-3'>
Other 3  <input type="text" name="o3" class="form-control">
                  </div>

<div class='col-lg-3'> 
 <textarea name="comment" class="form-control" placeholder="Comment"></textarea>
                  </div>


                    </div>
                </div>
            </div>

<!----row---->

<input type="submit" name='adminsubmit' class='btn btn-sm btn-primary' value="Submit Form">
<input type="reset" class='btn btn-sm btn-primary'  value="Reset Form">
</form>                     


                             
                                </div>
                                
                            </div>
                        </div>
                    </div>
                  </div>
                <!-- /.row -->

                  </div>
                <!-- /.row -->

            </div>
            <!-- /.container-fluid -->

        </div>
        <!-- /#page-wrapper -->

    </div>
    <!-- /#wrapper -->

    <!-- jQuery -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.11.1/jquery.js"></script>

    <!-- Bootstrap Core JavaScript -->
    <script src="js/bootstrap.min.js"></script>

    <!-- Morris Charts JavaScript -->

</body>

</html>