perbaikan 003

//proses query
<?php
//mysql_select_db($name_database, $database);
$database =   @mysqli_connect('localhost', 'fake_user', 'my_password', 'my_db');//sesuaikan

if (!$database) {
    /* Use your preferred error logging method here */
    error_log('Connection error: ' . mysqli_connect_error());
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form14")) {
  $data = $nTps = $_POST['jumlah_tps'];
  //for($i=1;$i<=$data;$i++)
  {

        $id = autonumber("tps", "id", 1, "");
        $code_region = 1;
        $name_region = $_POST['name_region'];

        $code_prov = $_POST['code_prov'];
        $row1 = mysql_fetch_assoc(mysqli_query("select * from master_region where code_region='$code_prov'",$database));
        $name_prov = $row1['name_region'];

        $code_kab = $_POST['code_kab'];
        $row2 = mysql_fetch_assoc(mysqli_query("select * from master_region where code_region='$code_kab'",$database));
        $name_kab = $row2['name_region'];

        $code_kec = $_POST['code_kec'];
        $row3 = mysql_fetch_assoc(mysqli_query("select * from master_region where code_region='$code_kec'",$database));
        $name_kec = $row3['name_region'];

        $code_kel = $_POST['code_kel'];
        $row4 = mysql_fetch_assoc(mysqli_query("select * from master_region where code_region='$code_kel'",$database));
        $name_kel = $row4['name_region'];

        //$code_tps = autostring("tps","code_tps",$code_kel,4,$code_kel.".");
        $code_tps =  "tps"."code_tps".$code_kel.4,$code_kel;
        $name_tps = substr($code_tps,-4);
        $password = $code_tps;
        $role = "CHECKER";

      $query=mysqli_fetch_assoc(mysqli_query("SELECT * FROM tps WHERE code_tp like  '$code_tps%'",$database));
      if ($query ){
        echo "<script>alert('Kode TPS ".$code_tps." sudah terdaftar !!!'); window.location = 'master-data'</script>";
      } else {
          for($iTps=0;$iTps<$nTps;$iTps++)
          {
              $code_tps = autostring("tps","code_tps",$code_kel,4,$code_kel.".");
              $code_tps .= sprintf("%04s",$iTps);
              $name_tps = substr($code_tps,-4);
              $password = $code_tps;
              $insertSQL = sprintf("INSERT HIGH_PRIORITY INTO tps (id, code_region, name_region, code_prov, name_prov, code_kab, name_kab, code_kec, name_kec, code_kel, name_kel, code_tps, name_tps, password, role) VALUES (%s, %s, %s,%s, %s, %s,%s, %s, %s,%s, %s, %s,%s, %s, %s)",
                  GetSQLValueString($id, "text"),
                  GetSQLValueString($code_region, "text"),
                  GetSQLValueString($name_region, "text"),
                  GetSQLValueString($code_prov, "text"),
                  GetSQLValueString($name_prov, "text"),
                  GetSQLValueString($code_kab, "text"),
                  GetSQLValueString($name_kab, "text"),
                  GetSQLValueString($code_kec, "text"),
                  GetSQLValueString($name_kec, "text"),
                  GetSQLValueString($code_kel, "text"),
                  GetSQLValueString($name_kel, "text"),
                  GetSQLValueString($code_tps2, "text"),
                  GetSQLValueString($name_tps, "text"),
                  GetSQLValueString($password, "text"),
                  GetSQLValueString($role, "text"));
            $Result1 = mysqli_query($insertSQL, $database) or die(mysql_error());
          }
        echo '<script>alert("Data berhasil dibuat"); location.href="master-data"</script>';
      }
  }

}
?>
//form input
<div class="modal fade" id="tambah_tps">
          <div class="modal-dialog modal-md">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span></button>
                <h4 class="modal-title">Add TPS</h4>
              </div>
              <div class="modal-body">
              <form enctype="multipart/form-data" method="post" name="form14" id="form14" action="<?php echo $FormAction; ?>" autocomplete="off">
              <div class="box-body">
              <div class="col-lg-6">
                <div class="form-group">
                  <label>Nama Wilayah</label>
                  <select class="form-control" name="name_region" id="name_region" style="width: 100%;" required>
                  <option value="" disabled selected>- PILIH -</option>
                    <option value="Indonesia">Indonesia</option>
                  </select>
                </div>
              </div>
              <div class="col-lg-6">
                <div class="form-group">
                  <label>Nama Provinsi</label>
                  <select class="form-control select2" name="code_prov" id="code_prov" style="width: 100%;" required>
                  <option value="" disabled selected>- PILIH -</option>
                  <?php
                  $no = 1;
                  $query=mysql_query("SELECT DISTINCT code_region,name_region FROM master_region WHERE CHAR_LENGTH(code_region)='2' ORDER BY code_region asc");
                  while ($row = mysql_fetch_assoc($query)):
                  ?>
                    <option value="<?php echo $row['code_region']; ?>"><?php echo $no++ ?>. <?php echo $row['name_region']; ?></option>
                  <?php endwhile;?>
                  </select>
                </div>
              </div>
              <div class="col-lg-6">
                <div class="form-group">
                  <label>Nama Kabupaten/Kota</label>
                  <select class="form-control select2" name="code_kab" id="code_kab" style="width: 100%;" required>
                    <option value="">- PILIH PROVINSI -</option>
                  </select>
                </div>
              </div>
              <div class="col-lg-6">
                <div class="form-group">
                  <label>Nama Kecamatan</label>
                  <select class="form-control select2" name="code_kec" id="code_kec" style="width: 100%;" required>
                    <option value="">- PILIH KAB/KOTA -</option>
                  </select>
                </div>
              </div>
              <div class="col-lg-6">
                <div class="form-group">
                  <label>Nama Kelurahan/Desa</label>
                  <select class="form-control select2" name="code_kel" id="code_kel" style="width: 100%;" required>
                    <option value="">- PILIH KECAMATAN -</option>
                  </select>
                </div>
              </div>
              <div class="col-lg-6">
                <div class="form-group">
                  <label>Jumlah TPS</label>
                  <input type="text" name="jumlah_tps" pattern="[0-9]{1,4}" title="Masukan angka" class="form-control" required>
                </div>
              </div>



              </div>
              <!-- /.box-body -->

              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
                <button type="submit" class="btn btn-primary" id="btn_save">Save</button>
                <input type="hidden" name="id">
                <input type="hidden" name="code_region">
                <input type="hidden" name="name_prov">
                <input type="hidden" name="name_kab">
                <input type="hidden" name="name_kec">
                <input type="hidden" name="name_kel">
                <input type="hidden" name="code_tps">
                <input type="hidden" name="name_tps">
                <input type="hidden" name="password">
                <input type="hidden" name="role">
                        <input type="hidden" name="MM_insert" value="form14">
              </div>
            </form>
            </div>
            <!-- /.modal-content -->
          </div>
          <!-- /.modal-dialog -->
        </div>
        <!-- /.modal -->