Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
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
