Postingan lainnya
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
cara update gambar
bagaimana cara update gambar, tetapi jika saya tidak mengganti gambarnya saya masih pakai gambar yang lama ? ini saya sudah coba seperti ini, tapi gambar kok menjadi ilang ya saat update? moghon bantuan gan, trimkasih
form editnya
<?php require_once "core-admin/init-admin.php";
if( !isset($_SESSION['user_admin']) ){
$_SESSION['msg'] = ' silahkan login';
header('Location: login_admin.php');
}
$error=' ';
if( isset($_POST['submit']) ){
$id = $_GET['id'];
$isi_revisi = $_POST['isi_revisi'];
$gambar_desain = $_FILES['gambar_desain'];
$tipe_file = $_FILES['gambar_desain'] ['type'];
$tmp_file = $_FILES['gambar_desain']['tmp_name'];
$ukuran_file = $_FILES['gambar_desain'] ['size'];
if(!empty(trim($isi_revisi)) ) {
if(!empty($_FILES['gambar_desain']['tmp_name']) ){
if($tipe_file === "image/jpeg" || $tipe_file === "image/png" || $tipe_file === "image/jpg" ){
if($ukuran_file <= 4000000){
if(edit_data_detail($id, $isi_revisi, $gambar_desain)) {
$error= "berhasil upload desain";
}else{
$error= "gagal upload desain";
}
}else{
$error= "ukuran gambar yang d upload harus kurang dari 4 mb";
}
}else{
$error= "tipe gambar harus .jpeg .jpg atau .png";
}
}else{
$error= "gambar tidak boleh kosong";
}
}else{
$error= 'tolong lengkapi form yang belum terisi';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title></title>
<!-- Latest compiled and minified css -->
<link rel="stylesheet" href="../view/css/bootstrap.min.css">
<!-- optional theme-->
<link rel="stylesheet" href="../view/css/bootstrap-theme.min.css">
<!--my custom css-->
<link rel="stylesheet" href="../view/css/style.css">
<!--font-awesome-->
<link rel="stylesheet" href="../view/font-awesome/css/font-awesome.min.css">
<!---------------------------------->
<style>
body{
font-family: arial monospace;
background-color :#eee;
}
.container{
display: flex;
align-items: center;
justify-content: center;}
.page{
padding:5px;
margin-top: 40px;
margin-bottom: 40px;
height: 510px;
width: 400px;
background: #fff;
}
.content{
height: 100%;
padding: 40px;
display: flex;
align-items: center;
justify-content: center;
text-align: center;
}
.logo-register h2{
font-family:Chaparral Pro Light;
font-weight: bold;
}
.logo-register h5{
font-family: calibri;
color:#808080;
border-bottom:1px solid #eee;
padding-bottom: 5px;
}
.form-group .form-control{
border-radius: 0;
border:1px solid #eee;
padding: 5px;
}
.bawah-submit h5{ font-family: calibri;
color:#808080;}
.punya-akun h5{font-family: calibri;
color:#808080;}
#error{color: rgb(212, 19, 65);
}
</style>
</head>
<body>
<div class="container">
<div class="page">
<div class="content">
<div class="row">
<div class="logo-register">
<h2><a href="daftar_detail.php">Admin Wherco</a></h2>
<h5>Update data detail</h5>
</div>
<?php $result = tampil_per_id_detail($_GET['id']);
while($row = mysqli_fetch_assoc($result)) { ?>
<?php if($error != ' '){ ?>
<div id="error">
<?php echo $error; ?>
</div>
<?php } ?>
<form class="form-horizontal" action="" method="post" enctype="multipart/form-data">
<div class="form-group">
<input type="text" class="form-control" name="id_det" value="<?php echo $row['id_detail']?>" readonly>
</div>
<div class="form-group">
<textarea class="form-control" rows="3" name="isi_revisi" placeholder="isi revisi" Required><?php echo $row['isi_revisi']?></textarea>
</div>
<div class="form-group">
<input type="file" accept="image/*" name="gambar_desain" value="<?php echo $row['gambar_desain']?>" placeholder="">
</div>
<div class="form-group">
<input type="submit" name="submit" class="btn btn-primary btn-block" value="update">
</div>
</form>
<div class="bawah-submit">
<h5>Untuk perubahan data order
harus ada <br> permohonan oleh pelanggan</h5>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
</body>
</html>
functions nya
<?php
function tampil_data_detail(){
global $connect;
$query ="SELECT detail.id_detail , order_jasa.id_order , order_jasa.username ,
order_jasa.jenis_package , order_jasa.jumlah_transfer , order_jasa.nama_bank , detail.status_revisi ,
detail.isi_revisi , detail.gambar_desain , detail.waktu_revisi FROM detail
INNER JOIN order_jasa on order_jasa.id_order = detail.id_order ";
$result = mysqli_query($connect, $query) or die('query tampil gagal');
return $result;
}
function tambah_detail($id_detail, $id_order, $status_revisi, $isi_revisi, $gambar_desain){
global $connect;
//mencegah sql injection
$id_detail = mysqli_real_escape_string($connect, $id_detail);
$id_order = mysqli_real_escape_string($connect, $id_order);
$status_revisi = mysqli_real_escape_string($connect, $status_revisi);
$isi_revisi = mysqli_real_escape_string($connect, $isi_revisi);
$filePath = "gambar_desain/".basename($gambar_desain["name"]);
move_uploaded_file($gambar_desain["tmp_name"], $filePath);
$query = "INSERT INTO detail (id_detail, id_order, status_revisi, isi_revisi, gambar_desain) VALUES ('$id_detail', '$id_order', '$status_revisi', '$isi_revisi', '$filePath')";
if( mysqli_query($connect, $query) ){
return true;
}else{
return false;
}
}
function hasil_cari_detail($cari){
global $connect;
$query = "SELECT detail.id_detail , order_jasa.id_order , order_jasa.username ,
order_jasa.jenis_package , order_jasa.jumlah_transfer , order_jasa.nama_bank , detail.status_revisi ,
detail.isi_revisi , detail.gambar_desain , detail.waktu_revisi FROM detail INNER JOIN order_jasa on order_jasa.id_order = detail.id_order WHERE id_detail LIKE '%$cari%' OR order_jasa.id_order LIKE '%$cari%' OR username LIKE '%$cari%'";
$result = mysqli_query($connect, $query) or die('gagal mencari data');
return $result;
}
function tampil_per_id_detail($id){
global $connect;
$query = "SELECT * FROM detail WHERE id_detail = '$id'";
$result = mysqli_query($connect, $query) or die('query tampil per id gagal');
return $result;
}
function edit_data_detail($id, $isi_revisi, $gambar_desain){
global $connect;
$isi_revisi = mysqli_real_escape_string($connect, $isi_revisi);
$filePath = "gambar_desain/".basename($gambar_desain["name"]);
move_uploaded_file($gambar_desain["tmp_name"], $filePath);
$query= "UPDATE detail SET isi_revisi = '$isi_revisi', gambar_desain= '$filePath' WHERE id_detail = '$id'";
if( mysqli_query($connect, $query) ){
return true;
}else{
return false;
}
}
?>
tolong di koreksi ya jika ada kode yang salah.
0
1 Jawaban:
berikutnya kalo nampilin kode yang relevan sama pertanyaan aja gan, ngga usah semua kode, kasihan harus dibaca semua yang mau bantu jawab, hehe.
Agan disini menguji
if(!empty($_FILES['gambar_desain']['tmp_name']) )
kalo kosong dia bakal error, berarti harusnya orang ngga bisa submit kalo gambarnya ngga diupload di bagian editnya,
0