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