faizadie

add_produk.php

Dec 4th, 2018
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.19 KB | None | 0 0
  1. <?php
  2.  
  3. session_start();
  4. include "../secure/connect.php";
  5.  
  6. $q = "SELECT * FROM mst_user";
  7. $e = mysqli_query($id_mysql, $q);
  8.  
  9. $status = "+";
  10. $user = @$_SESSION['email'];
  11.  
  12. $kode_produk = $_GET['kode_produk'];
  13. $nama_produk = $_GET['nama_produk'];
  14. $satuan = $_GET['satuan'];
  15. $ukuran = $_GET['ukuran'];
  16. // $gambar = $_GET['gambar'];
  17. $minimal_produk = $_GET['minimal_produk'];
  18. $harga_pembelian = $_GET['harga_pembelian'];
  19. $tanggal = $_GET['tanggal'];
  20. $kode_kategori = $_GET['kategori'];
  21. $kode_merk = $_GET['kode_merk'];
  22. $kode_supplier = $_GET['kode_supplier'];
  23. $kode_gudang = $_GET['kode_gudang'];
  24. $deskripsi_produk = $_GET['deskripsi_produk'];
  25.  
  26. ///////////////////////////////////////
  27. // $kode_produk = $_REQUEST['kode_produk'];
  28.  
  29. $key = $_GET['key'];
  30.  
  31. $img = "SELECT itemname FROM tmp_item_filename WHERE key = '$key' ";
  32. $st = mysqli_query($id_mysql,$img);
  33. while ($row = mysqli_fetch_row($st)) {
  34. $filename = $row[0];
  35. }
  36.  
  37. move_uploaded_file($_FILES['imgname']['tmp_name'],'../images/'.$filename);
  38. $faizganteng;
  39. $q = "INSERT INTO produk(kode_produk,nama_produk,satuan,ukuran,minimal_produk,harga_pembelian,tanggal,kode_kategori,kode_merk,kode_supplier,kode_gudang,deskripsi_produk,gambar,status,user) VALUES('$kode_produk','$nama_produk','$satuan','$ukuran','$minimal_produk','$harga_pembelian','$tanggal','$kategori','$kode_merk','$kode_supplier','$kode_gudang','$deskripsi_produk','$filename','$status','$user')";
  40.  
  41. if (mysqli_query($id_mysql,$q)) {
  42. ?>
  43. <!-- <script src="../js/lib/sweetalert/sweetalert.min.js"></script>
  44. <script src="../js/lib/sweetalert/sweetalert.init.js"></script> -->
  45. <img src='../images/purrClose.png' onload ='swal({
  46. title: "Hey, Good job !!",
  47. text: "You Successfully Add Product !!",
  48. type: "success",
  49. showCancelButton: false,
  50. confirmButtonColor: "#75B12E",
  51. closeOnConfirm: true,
  52. closeOnCancel: false
  53. },
  54. function(isConfirm){
  55. if (isConfirm) {
  56. window.location="../data_produk"
  57. }
  58. });'/>
  59.  
  60. <?php
  61.  
  62. }else{
  63. echo "Error:" .$q ."<br>" .mysqli_error($id_mysql);
  64. }
  65. mysqli_close($id_mysql);
  66.  
  67. ?>
Advertisement
Add Comment
Please, Sign In to add comment