<?php   include_once('../config/db.php');   include_once('../config/check.php');  

if (filter_has_var(INPUT_POST, "submit")) 
    try{
            
            $name     =                 htmlspecialchars ( $_POST['name']);
            $capacity =                 htmlspecialchars ( $_POST['capacity']);
            $price    =                 htmlspecialchars ( $_POST['price']);

            $sql = 'INSERT INTO rooms ( name,capacity,price ) VALUES(:name,:capacity,:price )';
            $conn->prepare($sql)->execute (['name'=>$name,'capacity'=>$capacity,'price'=>$price  ]);
            header("location:room.php");

        } catch(Exception $e) { echo 'Message: ' .$e->getMessage();}

?>

<!DOCTYPE html>
<html>
<head>
<?php include_once('../inc/slink.php');   ?>  
</head>
<body <?php include_once('../inc/snav.php');  ?>>
<div class="wrapper">

  <!-- Main Header -->
    <header class="main-header">

    <!-- Logo -->
       <?php include_once('../inc/sbrand.php');   ?>

    <!-- Header Navbar -->
    <?php include_once('../inc/snavbar.php');   ?>

  </header>
 
  <!-- Left side column. contains the logo and sidebar -->
    <aside class="main-sidebar">

    <!-- sidebar: style can be found in sidebar.less -->
     <?php include_once('../inc/smenu.php');   ?>
    <!-- /.sidebar -->
  </aside>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
        <section class="content-header" style="padding-bottom:0px;">
            <p style="color:green; font-size:20px; font-weight:bold; " > <i class="fa fa-plus-circle" ></i> Add Groups  </p>      
        </section>
<!-- Main content -->

  <section class="content container-fluid" style="padding-top:0px;" > 
        <div class="box box-default box-xs" >
            <div class="box-body">
                <div class="row">
                    <form class="form-horizontal add_form "  action="" method="post"  >
                                               
                            <!-- <div class="col-sm-4"> 
                                <label > Date  </label>  
                                <input type="text"   autocomplete="off" class="form-control datepicker" name="date"   required=""   > 
                            </div>                                            -->
                            <div class="col-sm-6"> 
                                <label > Group Name  </label>  
                                    <input type="text"  name="name" value="" autocomplete="off" class="form-control"   required=""   > 
                            </div> 
                            <div class="col-md-3">
                              <label > Branch </label>
                                <select class=" js-example-basic-single  " name="branch" required=""  id="branch" style="width:100%" >
                                
                                            <?php
                                            $stmt = $conn->prepare("SELECT * FROM branches");
                                            $stmt->execute();
                                            while($data=$stmt->fetch(PDO::FETCH_ASSOC))
                                                {?>
                                    <option> </option>
                                    <option value="<?php echo $data['id']; ?>"><?php echo $data['name']; ?></option>
                                    <?php } ?>
                                </select>
                            </div>

                            <!-- <div class="col-sm-3"> 
                                <label> Branch  </label>  
                                    <input type="text"  name="branch" value="" autocomplete="off" class="form-control"   required=""   > 
                            </div>  -->
                            <div class="col-sm-3"> 
                                <label> Location  </label>  
                                    <input type="text"  name="location" value="" autocomplete="off" class="form-control"   required=""   > 
                            </div> 
                            <div class="col-sm-3"> 
                                <label> Account_Number  </label>  
                                    <input type="text"  name="accountnumber" value="" autocomplete="off" class="form-control"   required=""   > 
                            </div>
                            <div class="col-sm-3"> 
                                <label> Members  </label>  
                                    <input type="text"  name="members" value="" autocomplete="off" class="form-control"   required=""   > 
                            </div>
                            <div class="col-sm-3"> 
                                <label> Chairperson_Number  </label>  
                                    <input type="text"  name="chairpersonnumber" value="" autocomplete="off" class="form-control"   required=""   > 
                            </div>
                            <div class="col-sm-3"> 
                                <label> Active_Members  </label>  
                                    <input type="text"  name="activemembers" value="" autocomplete="off" class="form-control"   required=""   > 
                            </div>
                            <!-- <div class="col-sm-3"> 
                                <label > Code </label>  
                                    <input type="text"  name="code" value="" autocomplete="off" class="form-control"   required=""   > 
                            </div> 
                            <div class="col-sm-12"> 
                                <label > Description  </label>  
                                    <input type="text"  name="description"  autocomplete="off" class="form-control"   required=""   > 
                            </div>  -->
           
                        <!-- submit button -->
                        <div class="form-group">                              
                            <div class="col-sm-offset-4 col-sm-10" style="padding:0.5rem;">
                                    <button type="submit"  name="submit" class="btn btn-success col-md-3 subbtn ">  <i class="fa fa-plus"></i>  Add group </button> </div>
                        </div> 
                    </form>               
                </div>
            </div>
        </div>
                                
    </section>

</div>
  <!-- /.content-wrapper -->
  
  <!-- Main Footer -->
  <footer class="main-footer">
    <?php  include_once('../inc/sfooter.php'); ?>
  </footer>
  
</div>
                         
<!-- ./wrapper -->

<!-- REQUIRED JS SCRIPTS -->
<?php include_once('../inc/slinkjs.php') ?>

</body>
</html>