- Beranda
- Programmer Forum
PHP MYSQL Ada data yang tidak masuk ke DB
...
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 memberi reputasi
1
507
2
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•4.4KAnggota
Urutkan
Terlama
Komentar yang asik ya