<?php include 'header.php'; ?>
<style>
    #form .form-group label.error {
    color: #FB3A3A;
    display: inline-block;
    margin: 0px 0 0px 0px;
    padding: 0;
    text-align: left;
    }
</style>
    
    <main id="main-container">
           <div class="content content-narrow">
                  <div class="row">
                      <div class="col-lg-12">
                            <h2 class="content-heading">Add State Commission</h2>
<?php  

if(isset($_REQUEST['submit'])){
	$state= $_REQUEST['state'];
	$comm= $_REQUEST['comm'];
	$order= $_REQUEST['num'];
	$full=$_REQUEST['full'];
	$stat=$_REQUEST['status'];
	
		$query="INSERT INTO sp_state_commission set state_id='$state',comm_name='$comm',full_name='$full',display_order='$order',status='$stat'"; 
        
	  	$sql = $db->prepare($query);
         $sql->execute();
		 echo '<h3 style="color:#000000;">Data submit successfully</h3>';
}
  
 ?>
     <div class="block">
          <div class="block-header">
                <ul class="block-options">
                    <li>
                        <button type="button"><i class="si si-settings"></i></button>
                    </li>
                </ul>
                <h3 class="block-title"></h3>
          </div>
                <div class="block-content block-content-narrow">
                    <form class="js-validation-bootstrap form-horizontal" action="state_commission.php" method="post" enctype="multipart/form-data" id="form">
                        <div class="form-group">
                            <label class="col-md-4 control-label" for="val-username">State<span class="text-danger">*</span></label>
                                <div class="col-md-7">
                                    <select class="js-select2 form-control" name="state" style="width: 100%;">
											             <?php 
											                $sql = $db->prepare("SELECT state_id,state_name FROM sp_states");
                                      $sql->execute();
                                    ?>
                                      <option selected="selected">--Select State--</option><?php
                                          while($row1=$sql->fetch(PDO::FETCH_ASSOC))
                                            { ?>
                                      <option value="<?php echo $row1['state_id']; ?>"><?php echo $row1['state_name']; ?></option>
                                           <?php
                                             } ?>
                                      </select>
                                  </div>
                          </div>
                          <div class="form-group">
                              <label class="col-md-4 control-label" for="val-email">State Commission<span class="text-danger">*</span></label>
                              <div class="col-md-7">
                                  <input class="form-control" type="text" name="comm" placeholder="">
                              </div>
                          </div>
										      <div class="form-group">
                              <label class="col-md-4 control-label" for="val-email">FUll Name<span class="text-danger">*</span></label>
                                  <div class="col-md-7">
                                      <input class="form-control" type="text" name="full" placeholder="Full Name">
                                    </div>
                          </div>
                          <div class="form-group">
                              <label class="col-md-4 control-label" for="val-confirm-password">Display order<span class="text-danger">*</span></label>
                                  <div class="col-md-7">
                                      <input class="form-control" type="number" name="num" placeholder="">
                                  </div>
                          </div>
								          <div class="form-group">
                              <label class="col-md-4 control-label" for="val-email">Status<span class="text-danger">*</span></label>
                                  <div class="col-md-7">
                                      <select name="status" class="form-control">
                											  <option value="1">Active</option>
                											  <option value="0">Deactive</option>
              											  </select>
                                  </div>
                          </div>
									        <div class="form-group">
                              <div class="col-md-8 col-md-offset-4">
                                  <button class="btn btn-sm btn-primary" type="submit" name="submit">Submit</button>
                              </div>
                          </div>
                      </form>
                  </div>
              </div>
          </div>
      </div>
  </div>
</main>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
  <script src="https://ajax.aspnetcdn.com/ajax/jquery.validate/1.9/jquery.validate.min.js"></script>

	<script type="text/javascript">
  (function ($, W, D)
    {
      var JQUERY4U = {};
      JQUERY4U.UTIL =
        {
          setupFormValidation: function ()
          {
          //form validation rules
          $("#form").validate({
              rules: {
				   
              state:  {
                  required: true,
                  
              },
              comm: {
                      required: true,
                  },
			     full: {
                      required: true,
                  },
              /* img: {
                      required: true,
       
                  }, */
              num: {
                      required: true,
                      
                  }
			  },
              messages: {
              state: "Please Enter exam name",
              comm: "Please Enter slug name",
              num: "Please Enter order number",
              },
              submitHandler: function (form) {
              form.submit();
              }
          });
        }
      }
  $(D).ready(function ($) {
      JQUERY4U.UTIL.setupFormValidation();
  });
  })(jQuery, window, document);
</script>
<?php  include 'footer.php'; ?>