SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | include'konpros.php'; | |
| 3 | ||
| 4 | - | $satuanunit = $_POST['satuan_unit']; |
| 4 | + | $nminstansi = $_POST['nama_instansi']; |
| 5 | - | $satuanwaktu = $_POST['satuan_waktu']; |
| 5 | + | $alamatinstansi = $_POST['alamat_instansi']; |
| 6 | - | $harga = $_POST['harga']; |
| 6 | + | $emailinstansi = $_POST['email_instansi']; |
| 7 | - | $lokasi = $_POST['lokasi']; |
| 7 | + | $nmpemohon = $_POST['nama_pemohon']; |
| 8 | - | $periode = $_POST['periode']; |
| 8 | + | $alamatpemohon = $_POST['alamat_pemohon']; |
| 9 | $nmrpemohon = $_POST['nomor_telepon_pemohon']; | |
| 10 | $emailpemohon = $_POST['email_pemohon']; | |
| 11 | ||
| 12 | - | $nminstansi = $_POST['nama_instansi']; |
| 12 | + | $stmt_konsumen = mysqli_prepare($koneksi, "INSERT INTO tabel_konsumen(nama_instansi, alamat_instansi, email_instansi, nama_pemohon, alamat_pemohon, no_telp, email_pemohon) VALUES (?, ?, ?, ?, ?, ?, ?)"); |
| 13 | - | $alamatinstansi = $_POST['alamat_instansi']; |
| 13 | + | mysqli_stmt_bind_param($stmt_konsumen, 'sssssss', $nminstansi, $alamatinstansi, $emailinstansi, $nmpemohon, $alamatpemohon, $nmrpemohon, $emailpemohon); |
| 14 | - | $emailinstansi = $_POST['email_instansi']; |
| 14 | + | $result_konsumen = mysqli_stmt_execute($stmt_konsumen); |
| 15 | - | $nmpemohon = $_POST['nama_pemohon']; |
| 15 | + | |
| 16 | - | $alamatpemohon = $_POST['alamat_pemohon']; |
| 16 | + | if ( $result_konsumen ) {
|
| 17 | - | $nmrpemohon = $_POST['nomor_telepon_pemohon']; |
| 17 | + | $id_konsumen = mysqli_insert_id($koneksi); |
| 18 | - | $emailpemohon = $_POST['email_pemohon']; |
| 18 | + | $tanggal = date("Y-m-d H:i:s");
|
| 19 | - | |
| 19 | + | $tglsurat = $_POST['tgl_surat']; |
| 20 | - | $tanggal = date("Y-m-d H:i:s");
|
| 20 | + | $nosurat = $_POST['nosurat']; |
| 21 | - | $tglsurat = $_POST['tgl_surat']; |
| 21 | + | $dataminta = $_POST['jenis_data']; |
| 22 | - | $nosurat = $_POST['nosurat']; |
| 22 | + | $jumlahunit = $_POST['jumlah_unit']; |
| 23 | - | $dataminta = $_POST['jenis_data']; |
| 23 | + | $jumlahwaktu = $_POST['jumlah_waktu']; |
| 24 | - | $jumlahunit = $_POST['jumlah_unit']; |
| 24 | + | $jenistarif = $_POST['jenistarif']; |
| 25 | - | $jumlahwaktu = $_POST['jumlah_waktu']; |
| 25 | + | $total = $_POST['total']; |
| 26 | - | $jenistarif = $_POST['jenistarif']; |
| 26 | + | $lsa = $_POST['lsa']; |
| 27 | - | $total = $_POST['total']; |
| 27 | + | $proposal = $_POST['proposal']; |
| 28 | - | $lsa = $_POST['lsa']; |
| 28 | + | $surat = $_POST['surat']; |
| 29 | - | $proposal = $_POST['proposal']; |
| 29 | + | |
| 30 | - | $surat = $_POST['surat']; |
| 30 | + | $stmt_transaksi = mysqli_prepare($koneksi, "INSERT INTO tabel_transaksi (tgl_input, tgl_surat, no_surat, jenis_data, jumlah_unit, jumlah_waktu, jenis_tarif, harga_total, nama_lsa, proposal, surat, id_konsumen) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); |
| 31 | mysqli_stmt_bind_param($stmt_transaksi, 'sssssssssssi', $tanggal, $tglsurat, $nosurat, $dataminta, $jumlahunit, $jumlahwaktu, $jenistarif, $total, $lsa, $proposal, $surat, $id_konsumen); | |
| 32 | - | $sql2= "INSERT INTO tabel_konsumen(nama_instansi,alamat_instansi,email_instansi,nama_pemohon,alamat_pemohon,no_telp,email_pemohon) VALUES ('$nminstansi','$alamatinstansi','$emailinstansi','$nmpemohon','$alamatpemohon','$nmrpemohon','$emailpemohon')";
|
| 32 | + | $result_transaksi = mysqli_stmt_execute($stmt_transaksi); |
| 33 | ||
| 34 | - | $sql = "INSERT INTO tabel_transaksi (tgl_input,tgl_surat,no_surat,jenis_data,jumlah_unit,jumlah_waktu,jenis_tarif,harga_total,nama_lsa,proposal,surat) VALUES ('$tanggal','$tglsurat','$nosurat','$dataminta','$jumlahunit','$jumlahwaktu','$jenistarif','$total','$lsa','$proposal','$surat')";
|
| 34 | + | if ( $result_transaksi ) {
|
| 35 | echo "<script>alert('DATA BERHASIL DI INPUT'); window.location = 'forminput.php'</script>";
| |
| 36 | - | if (!mysqli_query($koneksi,$sql2)) {
|
| 36 | + | } |
| 37 | - | echo "gak masuk"; |
| 37 | + | else {
|
| 38 | - | }else{
|
| 38 | + | echo "gak masuk transaksi <br />"; |
| 39 | - | echo "<script>alert('DATA BERHASIL DI INPUT'); window.location = 'forminput.php'</script>";
|
| 39 | + | } |
| 40 | } | |
| 41 | else {
| |
| 42 | - | if (!mysqli_query($koneksi,$sql)) {
|
| 42 | + | echo "gak masuk konsumen <br />"; |
| 43 | - | echo "gak masuk transaksi <br />"; |
| 43 | + | } |
