prosesinputt.php

<?php
include'konpros.php';

$tanggal = date("Y-m-d H:i:s");
$tglsurat = $_POST['tgl_surat'];
$nosurat = $_POST['nosurat'];
$nmpemohon = $_POST['nama_pemohon'];
$alamatpemohon = $_POST['alamat_pemohon'];
$nmrpemohon = $_POST['nomor_telepon_pemohon'];
$emailpemohon = $_POST['email_pemohon'];
$nminstansi = $_POST['nama_instansi'];
$alamatinstansi = $_POST['alamat_instansi'];
$emailinstansi = $_POST['email_instansi'];
$dataminta = $_POST['jenis_data'];
$satuanunit = $_POST['satuan_unit'];
$jumlahunit = $_POST['jumlah_unit'];
$satuanwaktu = $_POST['satuan_waktu'];
$jumlahwaktu = $_POST['jumlah_waktu'];
$total = $_POST['total'];
$harga = $_POST['harga'];
$lokasi = $_POST['lokasi'];
$periode = $_POST['periode'];
$jenistarif = $_POST['jenistarif'];
$lsa = $_POST['lsa'];
$proposal = $_POST['proposal'];
$surat = $_POST['surat'];

$sql = "INSERT INTO tabel_transaksi VALUES ('','','$tanggal','$tglsurat','$nosurat','$dataminta','$jumlahunit','$jumlahwaktu','$jenistarif','$total','$lsa','$proposal','$surat')";

$sql2= "INSERT INTO tabel_konsumen VALUES ('','$nminstansi','$alamatinstansi','$emailinstansi','$nmpemohon','$alamatpemohon','$nmrpemohon','$emailpemohon')";

if (!mysqli_query($koneksi,$sql)) {
	echo "gak masuk";
}else{
	echo "<script>alert('DATA BERHASIL DI INPUT'); window.location = 'forminput.php'</script>";
}

if (!mysqli_query($koneksi,$sql2)) {
	echo "gak masuk";
}else{
	echo "<script>alert('DATA BERHASIL DI INPUT'); window.location = 'forminput.php'</script>";
}


?>