CRUD APLIKASI BERITA Menggunakan PHP-7 dan MySql-5
1. Koneksi.PHP
Skrip
<?php
$host = "localhost";
$user = "root";
$password = "";
$database = "profnews";
$koneksi = mysqli_connect($host, $user, $password, $database);
?>
2. Input_Berita.php
Skrip
<?php
include "koneksi.php";
//proses input berita
if (isset($_POST['Input'])) {
$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']));
//insert ke tabel
$query = mysqli_query($koneksi,"INSERT INTO berita (id_berita,id_kategori,judul,headline,isi,pengirim,tanggal) values ('','$kategori','$judul','$headline','$isi_berita','$pengirim',now())");
if($query){
echo "<h2><font color=blue>Berita telah berhasil ditambahkan</font></h2>";
} else {
echo "<h2><font color=red>Berita gagal ditambahkan</font></h2>";
}
}
?>
<html>
<head><title>Input 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>Input Berita</h2></td>
</tr>
<tr>
<td width="200">Judul Berita</td>
<td>: <input type="text" name="judul" size="30"></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");
//$sql = mysql_query ($query);
while ($hasil = mysqli_fetch_array ($query)) {
echo "<option value='$hasil[id_kategori]'>$hasil[nm_kategori]</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Headline</td>
<td><textarea name="headline" cols="50" rows="4"> </textarea></td>
</tr>
<tr>
<td>Isi Berita</td>
<td>: <textarea name="isi" cols="50" rows="10"> </textarea></td>
</tr>
<tr>
<td>Pengirim</td>
<td>: <input type="text" name="pengirim" size="20"></td>
</tr>
<tr>
<td> </td>
<td> <input type="submit" name="Input" value="Input Berita">
<input type="reset" name="reset" value="Cancel">
</td>
</tr>
</table>
</FORM>
</body>
</html>
3. 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>
<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='index.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>
4. 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>
Selamat mencoba...!
No comments:
Post a Comment