- Beranda
- Programmer Forum
PHP MYSQL Ada data yang tidak masuk ke DB
...
![clonningdash](https://s.kaskus.id/user/avatar/2011/01/28/avatar2527886_18.gif)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
TS
clonningdash
PHP MYSQL Ada data yang tidak masuk ke DB
Halo gan...
Ane mempunya form inputan tambah produk .
Ada salah satu inputan menggunakan checkbox, ketika dklik 1 atau lebih seharus nya masuk.
Tapi ini ane ada salah satu inputan yang tidak masuk gan ...
bisa bantu kah?
berikut source nya
Ane mempunya form inputan tambah produk .
Ada salah satu inputan menggunakan checkbox, ketika dklik 1 atau lebih seharus nya masuk.
Tapi ini ane ada salah satu inputan yang tidak masuk gan ...
bisa bantu kah?
berikut source nya
Code:
<?php
error_reporting(0);
include "../../../koneksi.php";
$ids = trim($_POST['ids']);
$mode = trim($_POST['mode']);
$kode = trim($_POST['kode']);
$nama = trim($_POST['nama']);
$deskripsi = trim($_POST['deskripsi']);
$harga = trim($_POST['harga']);
$stok = trim($_POST['stok']);
$berat = trim($_POST['berat']);
$sts = trim($_POST['sts']);
//gambar
//id_kategori
$id_kategori = trim($_POST['id_kategori']);
//id_brands
$id_brand = trim($_POST['id_brand']);
//diskon
$diskon = trim($_POST['diskon']);
/*db yg pengaruh
m_produk
m_produk_kategori
set_produk_disc
m_produk_gambar
*/
if($mode == "TAMBAH"){
$idnowquery = mysql_fetch_array(mysql_query("SELECT id FROM m_produk ORDER BY id DESC"));
$idn = $idnowquery['id'];
$idnow = $idn+1;
$results1 = mysql_query("INSERT INTO m_produk(
`id`,`kode`,`nama`,`deskripsi`,`stok`,`harga`,`berat`,`sts`) VALUES(
'$idnow','$kode','$nama','$deskripsi','$stok','$harga','$berat','$sts')") or die (mysql_error());
$kats = explode(',', $id_kategori);
foreach($kats as $kat){
$result2 = mysql_query("INSERT INTO m_produk_kategori(`id_produk`,`id_kategori`) VALUES('$idnow','$kat')");
}
$brands = explode(',', $id_brand);
foreach($brands as $brand){
$result5 = mysql_query("INSERT INTO m_produk_subject(`id_produk`,`id_brand`) VALUES('$idnow','$brand')");
}
$result3 = mysql_query("INSERT INTO set_produk_disc(`id_produk`,`disc_persen`) VALUES('$idnow','$diskon')");
//Loop through each file
for($i=0; $i<count($_FILES['gambar']['name']); $i++) {
$gambar = $_FILES['gambar']['name'][$i];
$gambar = "produk_".rand().".".pathinfo($gambar, PATHINFO_EXTENSION);
$sourcePath = $_FILES['gambar']['tmp_name'][$i]; // Storing source path of the file in a variable
$targetPath = "../../../images/produk/".$gambar; // Target path where file is to be stored
move_uploaded_file($sourcePath,$targetPath);
//if(move_uploaded_file($sourcePath,$targetPath)/;)/{// Moving Uploaded file
/*$gambar_sekarang = trim($_POST['gambar_sekarang'][$i]);
$gambar = $_FILES['gambar']['name'][$i];
if($gambar == ""){
$gambar = $gambar_sekarang;
}else{
$gambar = "produk_".rand().".".pathinfo($gambar, PATHINFO_EXTENSION);
}
$sourcePath = $_FILES['gambar']['tmp_name'][$i]; // Storing source path of the file in a variable
$targetPath = "../../../images/produk/".$gambar; // Target path where file is to be stored
move_uploaded_file($sourcePath,$targetPath) ; // Moving Uploaded file*/
$result4 = mysql_query("INSERT INTO m_produk_gambar(`id_produk`,`gambar`) VALUES('$idnow','$gambar')");
//}
}
echo "OKTAMBAH";
}else if($mode == "UBAH"){
$results1 = mysql_query("UPDATE m_produk SET
`id_brand`='$id_brand',`kode`='$kode',`nama`='$nama',`deskripsi`='$deskripsi',`stok`='$stok',`harga`='$harga',`berat`='$berat',`sts`='$sts' WHERE id = '$ids'") or die (mysql_error());
$result12 = mysql_query("DELETE FROM m_produk_kategori WHERE `id_produk` = '$ids'");
$kats = explode(',', $id_kategori);
foreach($kats as $kat){
$result2 = mysql_query("INSERT INTO m_produk_kategori(`id_produk`,`id_kategori`) VALUES('$ids','$kat')");
}
$result3 = mysql_query("UPDATE set_produk_disc SET `disc_persen`='$diskon' WHERE `id_produk`='$ids'");
$gmbrada = '';
//Loop through each file
for($i=0; $i<count($_FILES['gambar']['name']); $i++) {
//cek ke db m_produk_gambar WHERE gambar = gambar_sekarang
//kalau ada lanjut ke update normal WHERE id = id yg diambil dari select pertama
//kalau gak ada insert baru
//tiap loop masukkan / append $gambar ke $gmbrada
//diluar forloop select m_produk_gambar WHERE gambar != $gmbrada[x] AND ...
//lalu query delete dan unlink
$gambar_sekarang = trim($_POST['gambar_sekarang'][$i]);
$cekgmbr = mysql_fetch_array("SELECT * FROM m_produk_gambar WHERE gambar = '$gambar_sekarang' AND id_produk = '$ids'");
$adagmbr = 0;//0 ada, 1 gak ada
if(mysql_num_rows($cekgmbr) == 0){
$adagmbr = 1;
}else{
$idgmbrold = $cekgmbr['id'];
}
$gambar = $_FILES['gambar']['name'][$i];
if($gambar == ""){
$gambar = $gambar_sekarang;
}else{
$gambar = "produk_".rand().".".pathinfo($gambar, PATHINFO_EXTENSION);
}
$sourcePath = $_FILES['gambar']['tmp_name'][$i]; // Storing source path of the file in a variable
$targetPath = "../../../images/produk/".$gambar; // Target path where file is to be stored
move_uploaded_file($sourcePath,$targetPath) ; // Moving Uploaded file
if($sourcePath != ""){
unlink("../../../images/produk/".$gambar_sekarang);
}
if($adagmbr == 1 && $sourcePath != ""){
$result4 = mysql_query("INSERT INTO m_produk_gambar(`id_produk`,`gambar`) VALUES('$ids','$gambar')");
}else{
$result4 = mysql_query("UPDATE m_produk_gambar SET `gambar` = '$gambar' WHERE `id` = '$idgmbrold'");
}
$gmbrada .= "AND `gambar` != '$gambar' ";
}
if($gmbrada != ""){
$sisagmbrq = mysql_query("SELECT * FROM m_produk_gambar WHERE `id_produk` = '$ids' $gmbrada");
while($sisagmbr = mysql_fetch_array($sisagmbrq)){
$idsisagmbr = $sisagmbr['id'];
$gambarsisagmbr = $sisagmbr['gambar'];
$results5 = mysql_query("DELETE FROM m_produk_gambar WHERE id = '$idsisagmbr'") or die (mysql_error());
unlink("../../../images/produk/".$gambarsisagmbr);
}
}
echo "OKUBAH";
}else if($mode == "HAPUS"){
/*db yg pengaruh
m_produk
m_produk_kategori
set_produk_disc
m_produk_gambar
*/
$idd = explode(",",$ids);
foreach($idd as $ide){
$results1 = mysql_query("DELETE FROM m_produk WHERE id = '$ide'") or die (mysql_error());
$results2 = mysql_query("DELETE FROM m_produk_kategori WHERE id_produk = '$ide'") or die (mysql_error());
$results3 = mysql_query("DELETE FROM set_produk_disc WHERE id_produk = '$ide'") or die (mysql_error());
$gmbrq = mysql_query("SELECT gambar FROM m_produk_gambar WHERE id_produk = '$ide'");
while($gmbr = mysql_fetch_array($gmbrq)){
if($gmbr['gambar'] != ""){
unlink("../../../images/produk/".$gmbr['gambar']);
}
}
$results4 = mysql_query("DELETE FROM m_produk_gambar WHERE id_produk = '$ide'") or die (mysql_error());
}
echo "OKHAPUS";
}
?>
![nona212](https://s.kaskus.id/user/avatar/2020/02/23/avatar10811649_15.gif)
nona212 memberi reputasi
1
507
2
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
![Programmer Forum](https://s.kaskus.id/r200x200/ficon/image-176.png)
Programmer Forum![KASKUS Official KASKUS Official](https://s.kaskus.id/kaskus-next/next-assets/images/icon-official-badge.svg)
20.2KThread•4.4KAnggota
Urutkan
Terlama
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya