<?php
ob_start();
include('headMain_2.php');
require_once('../connect.php');
$db=db_connect();

?>

    <div class="row">
        <div class="col-lg-10"></div>
        <div class="col-lg-8 col-lg-offset-2">
            <div class="panel panel-default">
                <div class="panel-heading">
                    <h3> Change Student Status </h3>
                </div>
                <div class="panel-body">

                    <div class="row">
                        <div class="col-lg-8 col-lg-offset-2">


                            <div>
                                <?php
                                if (isset($_GET['id'])){
                                    if ($_GET['id']==1){
                                        echo '<div  class="alert alert-success"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button> Status Updated Successfully</div>';
                                    }elseif($_GET['id']==2){
                                        echo ' <div class="alert alert-danger"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Updated Record Failed</div>';
                                    }elseif($_GET['id']==3){
                                        echo ' <div class="alert alert-danger"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Matriculation Number Not Exist</div>';
                                    }elseif($_GET['id']==4){
                                        echo ' <div class="alert alert-danger"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Matriculation Number Already Added</div>';
                                    }
                                }
                                ?>
                            </div>
                            <fieldset>
                                <form id="form1" role="form" name="form1" method="POST" action="student_status_process.php">
                                    <div> Enter Student Matriculation Number:<input type="text" name="matNo" class="form-control"></div>
                                    <div> Status:
                                        <select class="form-control" name="status_R">
                                            <?php
                                            $db=db_connect();
                                              $sql="select * from student_status";
                                            $sql_exe=$db->query($sql);
                                            while ($row=$sql_exe->fetch(PDO::FETCH_BOTH)){
                                                echo '<option value="'.$row[2].'">'.$row[1].'</option>';
                                            }
                                            ?>

                                        </select></div>
                                    <br>
                                    <div><input type="submit" class="btn btn-primary form-control" value="Change Status"></div>
                                </form>
                            </fieldset>



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

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