- Beranda
- Komunitas
- Tech
- Programmer Forum
Newbie Bertanya Tolong Bantuan nya
TS
gustori17
Newbie Bertanya Tolong Bantuan nya
tolong bantuan nya para sesepuh, ane newbie baru mulai2 nyoba belajar pemograman web. semoga yang jawab dapat pahala, amin.
ane nyoba belajar ngedit dan hapus di php dengan menggunakan data yang muncul ketika di panggil oleh combobox, cuma masalah nya gk bisa udah jajal cara2 laen ampe mentok, tolong dong solusi nya
nih contoh nya :
<?php
include "koneksi.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Generasi Terburuk</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width">
<link rel="stylesheet" href="css/admin-panel.css" />
<link rel="stylesheet" href="css/responsive.css" />
<!--[if lt IE 9]>
[removed][removed]
<![endif]-->
<title>Generasi Terburuk</title>
</head>
<body bgcolor="black">
<div class="wrapper">
<div class="admin-event">
<p>Event</p>
<a id="MyBtn-event"><img src="../img/event.png"></a>
<div id="myModalEvent" class="modal1">
<!-- Modal content -->
<div class="modal-content">
<span class="closeEvent">×</span>
<form action="submit-event.php" method="post" enctype="multipart/form-data">
<select name="event-list">
<option name="cmb_event" id="cmb_event" value="0" selected="selected">Silahkan Pilih</option>
<?php
$result = mysql_query("select * from tb_event order by id_event asc");
$jsArray = "var data_event = new Array();\n";
while ($row=mysql_fetch_array($result))
{
echo '<option value="' . $row['judul_event'] . '">' . $row['judul_event'] . '</option>';
$jsArray .= "data_event['" . $row['judul_event'] . "'] = {id_event:'" . addslashes($row['id_event']) . "',judul_event:'".addslashes($row['judul_event']) . "',gambar_event:'".addslashes($row['gambar_event']) . "',deskripsi_event:'".addslashes($row['deskripsi_event'])."'};\n";
}
?>
</select>
<p>Id Event</p>
<p><input type="text" name="id_event" id="id_event" value="<?php echo $row['id_event'];?>" placeholder="Masukan Id Event"/></p>
<p>Judul Event</p>
<p><input type="text" name="judul_event" id="judul_event" placeholder="Masukan Judul Event"/></p>
<p>Gambar Event</p>
<p><input type="file" name="gambar_event" id="gambar_event"/></p>
<p>Deskripsi Event</p>
<p><textarea name="deskripsi_event" id="deskripsi_event" rows="5" cols="60" maxlength="500" placeholder="Masukan Deskripsi Event"/></textarea></p>
<p><button name="submit-event" id="submit-event" class="submit" type="submit">Submit</button><button name="edit-event" id="edit-event" class="submit" type="button">Edit</button><button name="delete-event" id="delete-event" class="delete" type="button">Delete</button></p>
</form>
[removed]
<?php echo $jsArray; ?>
function changeValue(id_event)
{
document.getElementById('id_event').value = data_event[id_event].id_event;
document.getElementById('judul_event').value = data_event[id_event].judul_event;
document.getElementById('deskripsi_event').value = data_event[id_event].deskripsi_event;
};
[removed]
</div>
</div>
</div>
</body>
</html>
[removed][removed]
<?php
include "koneksi.php";
$cmb_event = $_POST['cmb_event'];
$id_event = $_POST['id_event'];
$judul_event = $_POST['judul_event'];
$deskripsi_event = $_POST['deskripsi_event'];
$folder = 'image/';
$gambar_event = $folder . basename($_FILES['gambar_event']['name']);
$proses = move_uploaded_file($_FILES['gambar_event']['tmp_name'], $gambar_event);
//update data ke table event
$update = " UPDATE tb_event SET id_event='$id_event', judul_event='$judul_event', gambar_event='$gambar_event', deskripsi_event='$deskripsi_event' WHERE judul_event='$cmb_event'";
$query_update =mysql_query($update);
if ($query_update)
{
?>
//Jika Sukses
[removed]
alert('Data Event Berhasil Diubah!');
document.location='admin-panel.php';
[removed]
<?php
}
else
{
//Jika Gagal
echo "[removed]alert('Data Event Gagal Diubah, Silahkan Diulangi!')[removed]";
echo "<meta http-equiv='refresh' content='1 url=admin-panel.php'>";
}
?>
<?php
include "koneksi.php";
$cmb_event = $_POST['cmb_event'];
$id_event = $_POST['id_event'];
$judul_event = $_POST['judul_event'];
$deskripsi_event = $_POST['deskripsi_event'];
mysql_query("DELETE FROM tb_event WHERE judul_event='$cmb_event'") or die (mysql_error());
//refresh halaman
echo "[removed]alert('Data Berhasil Dihapus !')[removed]";
echo "<meta http-equiv='refresh' content='1 url=admin-panel.php'>";
?>
nih tampilan nya pas mau di delete
sesudah nya
tolong dibantu agan2 yg dah mahir
ane nyoba belajar ngedit dan hapus di php dengan menggunakan data yang muncul ketika di panggil oleh combobox, cuma masalah nya gk bisa udah jajal cara2 laen ampe mentok, tolong dong solusi nya
nih contoh nya :
<?php
include "koneksi.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Generasi Terburuk</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width">
<link rel="stylesheet" href="css/admin-panel.css" />
<link rel="stylesheet" href="css/responsive.css" />
<!--[if lt IE 9]>
[removed][removed]
<![endif]-->
<title>Generasi Terburuk</title>
</head>
<body bgcolor="black">
<div class="wrapper">
<div class="admin-event">
<p>Event</p>
<a id="MyBtn-event"><img src="../img/event.png"></a>
<div id="myModalEvent" class="modal1">
<!-- Modal content -->
<div class="modal-content">
<span class="closeEvent">×</span>
<form action="submit-event.php" method="post" enctype="multipart/form-data">
<select name="event-list">
<option name="cmb_event" id="cmb_event" value="0" selected="selected">Silahkan Pilih</option>
<?php
$result = mysql_query("select * from tb_event order by id_event asc");
$jsArray = "var data_event = new Array();\n";
while ($row=mysql_fetch_array($result))
{
echo '<option value="' . $row['judul_event'] . '">' . $row['judul_event'] . '</option>';
$jsArray .= "data_event['" . $row['judul_event'] . "'] = {id_event:'" . addslashes($row['id_event']) . "',judul_event:'".addslashes($row['judul_event']) . "',gambar_event:'".addslashes($row['gambar_event']) . "',deskripsi_event:'".addslashes($row['deskripsi_event'])."'};\n";
}
?>
</select>
<p>Id Event</p>
<p><input type="text" name="id_event" id="id_event" value="<?php echo $row['id_event'];?>" placeholder="Masukan Id Event"/></p>
<p>Judul Event</p>
<p><input type="text" name="judul_event" id="judul_event" placeholder="Masukan Judul Event"/></p>
<p>Gambar Event</p>
<p><input type="file" name="gambar_event" id="gambar_event"/></p>
<p>Deskripsi Event</p>
<p><textarea name="deskripsi_event" id="deskripsi_event" rows="5" cols="60" maxlength="500" placeholder="Masukan Deskripsi Event"/></textarea></p>
<p><button name="submit-event" id="submit-event" class="submit" type="submit">Submit</button><button name="edit-event" id="edit-event" class="submit" type="button">Edit</button><button name="delete-event" id="delete-event" class="delete" type="button">Delete</button></p>
</form>
[removed]
<?php echo $jsArray; ?>
function changeValue(id_event)
{
document.getElementById('id_event').value = data_event[id_event].id_event;
document.getElementById('judul_event').value = data_event[id_event].judul_event;
document.getElementById('deskripsi_event').value = data_event[id_event].deskripsi_event;
};
[removed]
</div>
</div>
</div>
</body>
</html>
[removed][removed]
<?php
include "koneksi.php";
$cmb_event = $_POST['cmb_event'];
$id_event = $_POST['id_event'];
$judul_event = $_POST['judul_event'];
$deskripsi_event = $_POST['deskripsi_event'];
$folder = 'image/';
$gambar_event = $folder . basename($_FILES['gambar_event']['name']);
$proses = move_uploaded_file($_FILES['gambar_event']['tmp_name'], $gambar_event);
//update data ke table event
$update = " UPDATE tb_event SET id_event='$id_event', judul_event='$judul_event', gambar_event='$gambar_event', deskripsi_event='$deskripsi_event' WHERE judul_event='$cmb_event'";
$query_update =mysql_query($update);
if ($query_update)
{
?>
//Jika Sukses
[removed]
alert('Data Event Berhasil Diubah!');
document.location='admin-panel.php';
[removed]
<?php
}
else
{
//Jika Gagal
echo "[removed]alert('Data Event Gagal Diubah, Silahkan Diulangi!')[removed]";
echo "<meta http-equiv='refresh' content='1 url=admin-panel.php'>";
}
?>
<?php
include "koneksi.php";
$cmb_event = $_POST['cmb_event'];
$id_event = $_POST['id_event'];
$judul_event = $_POST['judul_event'];
$deskripsi_event = $_POST['deskripsi_event'];
mysql_query("DELETE FROM tb_event WHERE judul_event='$cmb_event'") or die (mysql_error());
//refresh halaman
echo "[removed]alert('Data Berhasil Dihapus !')[removed]";
echo "<meta http-equiv='refresh' content='1 url=admin-panel.php'>";
?>
nih tampilan nya pas mau di delete
sesudah nya
tolong dibantu agan2 yg dah mahir
Diubah oleh gustori17 07-12-2017 03:43
nona212 memberi reputasi
1
974
3
Komentar yang asik ya
Urutan
Terbaru
Terlama
Komentar yang asik ya
Komunitas Pilihan