2016

Create Read Update Delete using PHP MySql

CRUD TABEL ALUMNI DWI SETIYA NINGSIH // 210 315 70 25

[COMPANY NAME] | [Company address]

SS Program

Gambar 1.1 Tampilan index.php

Gambar 2.1 Tampilan edit.php berupa form pengeditan data

Gambar 2.2 Tampilan index.php setelah data berhasil di edit

Gambar 3.1 Tampilan input.php berupa form entry data baru, ketika “Input Data” di klik

Gambar 3.2 Tampilan index.php setelah data baru berhasil ditambahkan

Gambar 4.1 Tampilan delete.php kotak dialog konfirmasi atas penghapusan data terpilih

Gambar 3.1 Tampilan index.php setelah data berhasil dihapus

Source Code Koneksi.php
$dbnm = "school"; $conn = mysql_connect ($host, $user, $pass); if ($conn) { $buka = mysql_select_db ($dbnm); if (!$buka) { die ("Database tidak dapat dibuka"); } } else { die ("Server MySQL tidak terhubung"); } ?>

Index.php

Tampil.php

<style> h3{ text-align:center; } table { border-collapse:collapse; border-spacing:0; font-family:Arial, sans-serif; font-size:16px; padding-left:300px; margin:auto; } table th { font-weight:bold; padding:10px; color:white; background-color:blue; border-top:1px black solid; border-bottom:1px black solid;} table td { padding:10px; font: comicsans; border-top:2px navy solid; border-bottom:2px navy solid; text-align:center; } tr:nth-child(even) { background-color: white; } tr:nth-child(2n+1) { background-color: deepskyblue; }

Input.php
$nim = addslashes (strip_tags ($_POST['nim'])); $nama = addslashes (strip_tags ($_POST['nama'])); $prodi = $_POST['prodi']; $lulus = $_POST['lulus']; $kerja = $_POST['kerja'];

if (strlen ($nim) != 5) { echo"<script>alert('NIM harus 5 digit !',document.location.href='index.php?page=input')"; } $query = "INSERT INTO alumni VALUES('$nim','$nama','$prodi','$lulus','$kerja')"; $sql = mysql_query ($query) or die (mysql_error()); if ($sql) { echo"<script>alert('Data Alumni telah berhasil ditambahkan !',document.location.href='index.php')"; } else { echo"<script>alert('Data Alumni gagal ditambahkan !',document.location.href='index.php')"; } } ?>

Edit.php
$lulus = stripslashes ($hasil['lulus']); $kerja = stripslashes ($hasil['kerja']); if (isset($_POST['Edit'])) { $nim = $_POST['hnim']; $nama = addslashes (strip_tags ($_POST['nama'])); $prodi = addslashes (strip_tags ($_POST['prodi'])); $lulus = addslashes (strip_tags ($_POST['lulus'])); $kerja = addslashes (strip_tags ($_POST['kerja']));

$query = "UPDATE alumni SET nama='$nama',prodi='$prodi',lulus='$lulus', kerja='$kerja' WHERE nim='$nim'"; $sql = mysql_query ($query); if ($sql) { echo"<script>alert('Data Alumni telah berhasil diedit !',document.location.href='index.php')"; } else { echo"<script>alert('Data Alumni gagal diedit !',document.location.href='index.php')"; } } ?>

Delete.php
header("Location: index.php"); } else { header("Location: index.php"); } ?>