SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | $koneksi = mysqli_connect("localhost", "root", "", "posijb");
| |
| 3 | - | $koneksi = mysqli_connect("localhost","root","","posijb");
|
| 3 | + | if (mysqli_connect_errno()) {
|
| 4 | - | $noppb=$_POST['noppb']; |
| 4 | + | echo "Failed to connect to MySQL: " . mysqli_connect_error(); |
| 5 | - | $tgl=$_POST['tgl']; |
| 5 | + | exit(); |
| 6 | - | $jenis=$_POST['jenis']; |
| 6 | + | } |
| 7 | - | $keperluan=$_POST['keperluan']; |
| 7 | + | $noppb = $_POST['noppb']; |
| 8 | - | function proses_hoby($ppb_id) |
| 8 | + | $tgl = $_POST['tgl']; |
| 9 | - | {
|
| 9 | + | $jenis = $_POST['jenis']; |
| 10 | - | if(isset($_POST["deskripsi"])) |
| 10 | + | $keperluan = $_POST['keperluan']; |
| 11 | - | {
|
| 11 | + | function proses_hoby($ppb_id) |
| 12 | - | $hoby=$_POST["deskripsi"]; |
| 12 | + | {
|
| 13 | - | reset($hoby); |
| 13 | + | if (isset($_POST["deskripsi"])) |
| 14 | - | foreach ($hoby as $key => $val) {
|
| 14 | + | {
|
| 15 | - | $deskripsi =$_POST["deskripsi"][$key]; |
| 15 | + | $hoby = $_POST["deskripsi"]; |
| 16 | - | $qty =$_POST["qty"][$key]; |
| 16 | + | reset($hoby); |
| 17 | - | $satuan =$_POST["satuan"][$key]; |
| 17 | + | $koneksi = mysqli_connect("localhost", "root", "", "posijb");
|
| 18 | - | $harga =$_POST["harga"][$key]; |
| 18 | + | if (mysqli_connect_errno()) {
|
| 19 | - | $bayar =$_POST["bayar"][$key]; |
| 19 | + | echo "Failed to connect to MySQL: " . mysqli_connect_error(); |
| 20 | - | $pembayaran =$_POST["pembayaran"][$key]; |
| 20 | + | exit(); |
| 21 | - | $supplier_id =$_POST["supplier_id"][$key]; |
| 21 | + | } |
| 22 | - | $rekening =$_POST["rekening"][$key]; |
| 22 | + | foreach ($hoby as $key => $val) |
| 23 | - | $koneksi = mysqli_connect("localhost","root","","posijb");
|
| 23 | + | {
|
| 24 | - | $sql_hoby ="INSERT INTO desppb(deskripsi, qty, satuan, harga, bayar, pembayaran, supplier_id, rekening, ppb_id) |
| 24 | + | $deskripsi = $_POST["deskripsi"][$key]; |
| 25 | - | VALUES('$deskripsi','$qty','$satuan','$harga','$bayar','$pembayaran','$supplier_id','$rekening','$ppb_id')";
|
| 25 | + | $qty = $_POST["qty"][$key]; |
| 26 | - | $hasil_hoby =mysqli_query($koneksi,$sql_hoby); |
| 26 | + | $satuan = $_POST["satuan"][$key]; |
| 27 | - | } |
| 27 | + | $harga = $_POST["harga"][$key]; |
| 28 | - | } |
| 28 | + | $bayar = $_POST["bayar"][$key]; |
| 29 | - | } |
| 29 | + | $pembayaran = $_POST["pembayaran"][$key]; |
| 30 | - | |
| 30 | + | $supplier_id = $_POST["supplier_id"][$key]; |
| 31 | - | $sql= "INSERT INTO ppb(noppb,tgl,jenis,keperluan) |
| 31 | + | $rekening = $_POST["rekening"][$key]; |
| 32 | - | VALUES('$noppb','$tgl','$jenis','$keperluan')";
|
| 32 | + | $sql_hoby = "INSERT INTO desppb |
| 33 | - | $hasil=mysqli_query($koneksi,$sql); |
| 33 | + | (deskripsi, qty, satuan, harga, bayar, pembayaran, supplier_id, rekening, ppb_id) |
| 34 | - | $ppb_id=mysqli_insert_id($koneksi); |
| 34 | + | VALUES |
| 35 | - | if($hasil) |
| 35 | + | ('$deskripsi','$qty','$satuan','$harga','$bayar','$pembayaran','$supplier_id','$rekening','$ppb_id')";
|
| 36 | - | {
|
| 36 | + | $hasil_hoby = mysqli_query($koneksi, $sql_hoby)or die($sql_hoby."\n<br>error:".mysqli_error($koneksi); |
| 37 | - | proses_hoby($ppb_id); |
| 37 | + | } |
| 38 | - | redirect('ppb');
|
| 38 | + | } |
| 39 | - | } |
| 39 | + | } |
| 40 | - | else |
| 40 | + | |
| 41 | - | {
|
| 41 | + | $sql = "INSERT INTO ppb(noppb,tgl,jenis,keperluan) |
| 42 | - | echo "Data Gagal diinput"; |
| 42 | + | VALUES('$noppb','$tgl','$jenis','$keperluan')";
|
| 43 | - | } |
| 43 | + | $hasil = mysqli_query($koneksi, $sql)or die($sql ."\n<br>error:".mysqli_error($koneksi); |
| 44 | - | |
| 44 | + | $ppb_id = mysqli_insert_id($koneksi); |
| 45 | - | ?> |
| 45 | + | if ($hasil) |
| 46 | {
| |
| 47 | proses_hoby($ppb_id); | |
| 48 | redirect('ppb');
| |
| 49 | } | |
| 50 | else | |
| 51 | {
| |
| 52 | echo "Data Gagal diinput"; | |
| 53 | } | |
| 54 | ||
| 55 | ?> | |
| 56 |
