1. Arsip_berita.php
skrip
<?php
include "koneksi.php";
?>
<html>
<head><title>Arsip Berita</title>
<link rel="stylesheet" href="style.css">
<script language="javascript">
function tanya() {
if (confirm ("Apakah Anda yakin akan menghapus berita ini ?")) {
return true;
} else {
return false;
}
}
</script>
</head>
<body>
<a href="index.php">Halaman Depan</a> |
<a href="arsip_berita.php">Arsip Berita</a> |
<a href="input_berita.php">Input Berita</a> |
<a href="laporan_PDF.php">Laporan dengan FPDF</a> |
<a href="laporan_berita.php">Laporan dengan DOMPDF</a>;
<br><br>
<ol>
<?php
$query = mysqli_query($koneksi,"SELECT A.id_berita, B.nm_kategori, A.judul,A.pengirim, A.tanggal FROM berita A, kategori B WHERE A.id_kategori=B.id_kategori ORDER BY A.id_berita DESC");
while ($hasil = mysqli_fetch_array ($query)) {
$id_berita = $hasil['id_berita'];
$kategori = stripslashes ($hasil['nm_kategori']);
$judul = stripslashes ($hasil['judul']);
$pengirim = stripslashes ($hasil['pengirim']);
$tanggal = stripslashes ($hasil['tanggal']);
//
//tampilkan arsip berita
echo "<li><a href='berita_lengkap.php?id=$id_berita'>$judul</a><br>";
echo "<small>Berita dikirimkan oleh <b>$pengirim</b> pada tanggal <b>$tanggal</b> dalam kategori <b>$kategori</b><br>";
echo "<b>Action : </b><a href='edit_berita.php?halaman=editberita&id=$id_berita'>Edit</a>| ";
echo "<a href='delete_berita.php?id=$id_berita' onClick='return tanya()'>Delete</a> | ";
echo "</small></li><br><br>";
}
?>
</ol>
</body>
</html>
2. Edit_berita.php
skrip
<?php
include "koneksi.php";
if (isset($_GET['id'])) {
$id_berita = $_GET['id'];
} else {
die ("Error. No Id Selected! ");
}
$query = mysqli_query($koneksi,"SELECT id_berita, id_kategori, judul, headline, isi,pengirim, tanggal FROM berita WHERE id_berita='$id_berita'");
$hasil = mysqli_fetch_array ($query);
$id_berita = $hasil['id_berita'];
$id_kategori = stripslashes ($hasil['id_kategori']);
$judul = stripslashes ($hasil['judul']);
$headline = stripslashes ($hasil['headline']);
$isi = stripslashes ($hasil['isi']);
$pengirim = stripslashes ($hasil['pengirim']);
$tanggal = stripslashes ($hasil['tanggal']);
//proses edit berita
if (isset($_POST['Edit'])) {
$id_berita = $_POST['hidberita'];
$judul = addslashes (strip_tags ($_POST['judul']));
$kategori = $_POST['kategori'];
$headline = addslashes (strip_tags ($_POST['headline']));
$isi_berita = addslashes (strip_tags ($_POST['isi']));
$pengirim = addslashes (strip_tags ($_POST['pengirim']));
//update berita
$query = mysqli_query($koneksi,"UPDATE berita SET id_kategori='$kategori',judul='$judul',headline='$headline',isi='$isi_berita',pengirim='$pengirim' WHERE id_berita='$id_berita'");
if ($query) {
echo "<h2><font color=blue>Berita telah berhasil diedit</font></h2>";
} else {
echo "<h2><font color=red>Berita gagal diedit</font></h2>";
}
}
?>
<html>
<head><title>Edit Berita</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<a href="index.php">Halaman Depan</a> |
<a href="arsip_berita.php">Arsip Berita</a> |
<a href="input_berita.php">Input Berita</a>
<br><br>
<FORM ACTION="" METHOD="POST" NAME="input">
<table cellpadding="0" cellspacing="0" border="0" width="700">
<tr>
<td colspan="2"><h2>Edit Berita</h2></td>
</tr>
<tr>
<td width="200">Judul Berita</td>
<td>: <input type="text" name="judul" size="30" value="<?php echo $judul ?>"></td>
</tr>
<tr>
<td>Kategori</td>
<td>:
<select name="kategori">
<?php
$query = mysqli_query ($koneksi,"SELECT id_kategori, nm_kategori FROM kategori ORDER BY nm_kategori");
while ($hasil = mysqli_fetch_array($query)) {
$selected = ($hasil['id_kategori']==$id_kategori) ? "selected" : "";
echo "<option value='$hasil[id_kategori]' $selected>$hasil[nm_kategori]</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Headline Berita</td>
<td>: <textarea name="headline" cols="50" rows="4"><?php echo $headline ?></textarea></td>
</tr>
<tr>
<td>Isi Berita</td>
<td>: <textarea name="isi" cols="50" rows="10"><?php echo $isi ?></textarea></td>
</tr>
<tr>
<td>Pengirim</td>
<td>: <input type="text" name="pengirim" size="20" value="<?php echo $pengirim ?>"></td>
</tr>
<tr>
<td> </td>
<td>
<input type="hidden" name="hidberita" value="<?php echo $id_berita ?>">
<input type="submit" name="Edit" value="Edit Berita">
<input type="reset" name="reset" value="Cancel"></td>
</tr>
</table>
</FORM>
</body>
</html>
3. Delete_berita.PHP
skrip
<?php
include "koneksi.php";
if (isset($_GET['id'])) {
$id_berita = $_GET['id'];
} else {
die ("Error. No Id Selected! ");
}
?>
<html>
<head><title>Delete Berita</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<a href="index.php">Halaman Depan</a> |
<a href="arsip_berita.php">Arsip Berita</a> |
<a href="input_berita.php">Input Berita</a>
<br><br>
<?php
//proses delete berita
if (!empty($id_berita) && $id_berita != "") {
$query = mysqli_query($koneksi,"DELETE FROM berita WHERE id_berita='$id_berita'");
if ($query) {
echo "<h2><font color=blue>Berita telah berhasil dihapus</font></h2>";
} else {
echo "<h2><font color=red>Berita gagal dihapus</font></h2>";
}
echo "Klik <a href='arsip_berita.php'>di sini</a> untuk kembali ke halaman arsip berita";
} else {
die ("Access Denied");
}
?>
</body>
</html>
No comments:
Post a Comment