<?php  
include 'header.php';
$user_id =$_SESSION['user_id'];
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL)
?>

<style>
    #form .form-group label.error {
    color: #FB3A3A;
    display: inline-block;
    margin: 0px 0 0px 0px;
    padding: 0;

    }
    .form-horizontal .control-label{
      text-align:left !important;
    }
</style>

<main id="main-container">
  <div class="content content-narrow">
    <div class="row">
      <div class="col-lg-12">
        <h2 class="content-heading">Add State Cities</h2>
          <?php
            $curDate = date('Y-m-d H:i:s');
            if(isset($_REQUEST['Add'])){
              $city = $_REQUEST['city'];
              $city_slug = $_REQUEST['city_slug'];
              $state_id = $_REQUEST['state_id'];
              $Update_exam=$db->prepare("INSERT INTO sp_city SET city='$city',city_slug='$city_slug',state_id='$state_id'");
              $Update_exam->execute();
              $message = "City Added Successfully";
          }
          ?>
          <?php echo $message; ?>
        <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" method="post" id="form">
              <div class="form-group">
                <label class="col-md-4 control-label" for="val-select2">Select Exam</label>
                <div class="col-md-8">
                  <select class="js-select2 form-control" id="state_id" name="state_id" 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($row=$sql->fetch(PDO::FETCH_ASSOC)) {
                    ?>
                        <option value="<?php echo $row['state_id']; ?>"><?php echo $row['state_name']; ?></option>
                    <?php } ?>
                  </select>
                </div>
              </div>
                     
              <div class="form-group">
                <label class="col-md-4 control-label" for="val-select2">City Name</label> 
                <div class="col-md-8" class="new_class">
                  <span>
                  <input type="text" name="city" id="city" class="js-select2 form-control text">
                </span>
                </div>
              </div>

              <div class="form-group">
                <label class="col-md-4 control-label" for="val-select2">City Slug</label> 
                <div class="col-md-8" class="new_class">
                  <span>
                  <input type="text" name="city_slug" id="city_slug" class="js-select2 form-control text">
                </span>
                </div>
              </div>

              <div class="form-group">
                <div class="col-md-4"></div>
                <div class="col-md-4">
                  <button class="btn btn-lg btn-primary" type="submit" name="Add">Add</button>
                </div>
                <div class="col-md-4"></div>
              </div>
            </form>
          </div>
        </div>
      </div>
    </div>
  </div>
</main>

<?php  include 'footer.php'; ?>