Pengaturan

Gambar

Lainnya

Tentang KASKUS

Pusat Bantuan

Hubungi Kami

KASKUS Plus

© 2024 KASKUS, PT Darta Media Indonesia. All rights reserved

clonningdashAvatar border
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
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
nona212 memberi reputasi
1
507
2
GuestAvatar border
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
Programmer ForumKASKUS Official
20.2KThread4.4KAnggota
Urutkan
Terlama
GuestAvatar border
Komentar yang asik ya
Ikuti KASKUS di
© 2023 KASKUS, PT Darta Media Indonesia. All rights reserved.