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 |