Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!--================Home Banner Area =================-->
- <section class="banner_area">
- <div class="banner_inner banner_box d-flex align-items-center">
- <div class="overlay bg-parallax" data-stellar-ratio="0.9" data-stellar-vertical-offset="0" data-background=""></div>
- <div class="container">
- <div class="banner_content text-center">
- <h2>Contact Us</h2>
- <div class="page_link">
- <a href="index.html">Home</a>
- <a href="contact.html">Contact</a>
- </div>
- </div>
- </div>
- </div>
- </section>
- <!--================End Home Banner Area =================-->
- <!--================Contact Area =================-->
- <section class="contact_area p_120">
- <div class="container">
- <div class="row">
- <div class="col-lg-12">
- <?php
- $jmlh = @$_GET['jmlh'];
- $sql_hidden = "SELECT * FROM tb_calon_pengantin WHERE kd_pengantin = '$user_login'";
- $query_hidden = mysqli_query($koneksi,$sql_hidden) or die (mysqli_error());
- $data_hidden = mysqli_fetch_array($query_hidden);
- date_default_timezone_set('Asia/Jakarta');
- $carikode = mysqli_query($koneksi,"SELECT MAX(kd_tamu) FROM tb_tamu") or die (mysqli_error());
- $datakode = mysqli_fetch_array($carikode);
- $date = date('Y');
- if($datakode)
- {
- $nilaikode = substr($datakode[0], 6);
- $kode = (int) $nilaikode;
- $kode = $kode + 1;
- $hasilkode = "TU".$date.str_pad($kode, 3, "0", STR_PAD_LEFT);
- }
- else
- {
- $hasilkode = "TU".$date."001";
- }
- ?><form class="row contact_form" action="" method="post"><?php
- for($i=1; $i<=$jmlh; $i++)
- {
- ?>
- <div class="col-md-6">
- <div class="form-group">
- <label>Nama Tamu</label>
- <input type="hidden" class="form-control" name="kd_pengantin[<?=$i?>]" value="<?php echo $data_hidden['kd_pengantin']; ?>">
- <input type="hidden" class="form-control" name="kd_tamu[<?=$i?>]" value="<?php echo $hasilkode; ?>">
- <input type="hidden" class="form-control" name="status[<?=$i?>]" value="tamu">
- <input type="text" class="form-control" name="nm_tamu[<?=$i?>]" placeholder="Enter your name">
- </div>
- <div class="form-group">
- <label>Handphone</label>
- <input type="text" class="form-control" name="tlpon[<?=$i?>]" placeholder="Enter Phone">
- </div>
- <div class="form-group">
- <label>Email</label>
- <input type="email" class="form-control" name="email[<?=$i?>]" placeholder="Enter Your Email Address">
- </div>
- <div class="form-group">
- <label>Keterangan</label>
- <select class="form-control" name="keterangan[<?=$i?>]">
- <option value="">-----Pilih-----</option>
- <option value="teman">Teman/Sahabat</option>
- <option value="keluarga">Keluarga</option>
- </select>
- </div>
- </div>
- <div class="col-md-6">
- <div class="form-group">
- <label>Alamat</label>
- <textarea class="form-control" name="alamat[<?=$i?>]" rows="2" placeholder="Enter Your Address"></textarea>
- </div>
- </div>
- <?php
- }
- ?>
- <div class="col-md-12 text-right">
- <input type="submit" class="btn submit_btn" name="save" value="Save">
- </div>
- </form>
- </div>
- </div>
- </div>
- </section>
- <!--================Contact Area =================-->
- <?php
- $save = @$_POST['save'];
- if($save)
- {
- $jmlh = count($_POST['kd_tamu']);//@$_GET['jmlh'];
- for($i=1; $i<=$jmlh; $i++)
- {
- $kd_tamu = @$_POST['kd_tamu'][$i];
- $nm_tamu = @$_POST['nm_tamu'][$i];
- $alamat = @$_POST['alamat'][$i];
- $tlpon = @$_POST['tlpon'][$i];
- $email = @$_POST['email'][$i];
- $status = @$_POST['status'][$i];
- $keterangan = @$_POST['keterangan'][$i];
- $kd_pengantin = @$_POST['kd_pengantin'][$i];
- $sql = "INSERT INTO tb_tamu VALUES
- ('$kd_tamu', '$nm_tamu', '$alamat', '$tlpon', '$email', '$status', '$keterangan', '$kd_pengantin')"
- or die (mysqli_error());
- echo $sql;
- //$query = mysqli_query($koneksi,$sql);
- //echo "<script type='text/javascript'>alert('Tambah Data Berhasil, Silahakan Tamu Undangan Suruh Cek Email');window.location.href='?page=email&ID=$username';</script>";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement