Simpan, Edit dan Hapus Data MySQL dengan PHP secara Simple

Tutorial seperti ini sebenarnya gak penting banget, berhubung gak punya ide buat posting, ya diposting aja. :D

1. Siapkan database MySQL terlebih dahulu, disini akan digunakan sebagai contoh nama database adalah : test

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 21, 2014 at 02:32 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

 --
-- Database: `test`
--

 -- --------------------------------------------------------

 --
-- Table structure for table `mhsasia`
--

 CREATE TABLE IF NOT EXISTS `mhsasia` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nama` text NOT NULL,
  `alamat` char(30) NOT NULL,
  `nim` char(8) NOT NULL,
  `email` char(28) NOT NULL,
  `no_telpon` char(18) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=17 ;

 --
-- Dumping data for table `mhsasia`
--

 INSERT INTO `mhsasia` (`id`, `nama`, `alamat`, `nim`, `email`, `no_telpon`) VALUES
(1, 'Samari Sulfin', 'Jln. Panguripan 36A Gg. IIIB', '08201167', 'sam_caem@yahoo.co.id', '089121474836'),
(2, 'Daniel Noor', 'Jln. Kedangagung 12', '07201127', 'daniel_nur88@gmail.com', '08916600663'),
(3, 'Cah Pucanglaban', 'Jln. Asia Selatan No. 10C', '08201144', 'huda_caem12@yahoo.com', '08992213660'),
(4, 'Moor Gand UL', 'Jln. Panarukan 11B Wedangan', '08201078', 'gandaasiaselatan@yahoo.com', '0899333767'),
(5, 'Hehen Pengend di Manja', '', '127', '', '0'),
(6, 'Noor Manny', '', '127', '', '0'),
(7, 'Dloow Jail', '', '127', '', '0'),
(8, 'Paijo Romeo', '', '127', '', '0'),
(9, 'Moammar Khaniv', '', '127', '', '0');

 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Copy aja Query diatas ke Notepad dan jadikan mhsasia.sql

2. Buat file koneksi.php, yang simple aja.

<?php
$host="localhost";

$user="root";

$pass="";

$db="test";

$koneksi=mysql_connect($host,$user,$pass);
mysql_select_db($db,$koneksi);
?>

3. Buat file tambah data. dengan nama index.php

<center><h1>Tambah Data</h1></center>

<form method="post" action="simpan.php">

<table align="center" frame="box" bgcolor="#CCCCCC">

<tr><td>ID</td>

<td><input type="text" name="id" size="8" /></td>

</tr>

<tr><td>Nama</td>

<td><input type="text" name="nama" size="20" /></td>

</tr>

<tr><td>Alamat </td>

<td><input type="text" name="alamat" size="30" /></td>

</tr>

<tr>

<td>NIM</td>

<td><input type="text" name="nim" size="10" /></td>

</tr>

<tr>

<td>Email</td>

<td><input type="text" name="email" size="28" /></td>

</tr>

<tr><td>No Telp</td>

<td><input type="text" name="no_telpon" size="18" /></td>

</tr>

<tr> 

<td><input type="submit" name="simpan" value="Simpan"></td>

<td><input type="reset" name="reset" value="Reset"></td>

</tr>

</table>

</form>

<?php

echo ("<center>Lihat Data <a href=\"view.php\">OK</a></center>");

?>

4. Buat file simpan.php

<?php

include("koneksi.php");

$id = $_POST['id'];

$nama = $_POST['nama'];

$alamat = $_POST['alamat'];

$nim = $_POST['nim'];

$email = $_POST['email'];

$no_telpon = $_POST['no_telpon'];

$query = mysql_query("insert into mhsasia values  ('$id','$nama','$alamat','$nim','$email','$no_telpon')");

echo ("<center>Data Telah di Simpan<br><a href=\"index.php\">Kembali</a></center><br>");

echo ("<center>Lihat Data !!! <a href=\"view.php\">OK</a></center>");

?>

5. Buat file view.php

<?php

include "koneksi.php";

$perintah="select*from mhsasia order by id asc";

 $hasil=mysql_query($perintah);

 echo("<table border='1' align='center'>");

 echo("<tr><center><h3>Data Mahasiswa</h3></center></tr>

  <tr><th>No.</th><th>ID</th><th>Nama</th><th>Alamat</th><th>NIM</th><th>Email</th><th>No Telpon</th></tr>");

$no=1;

while($row=mysql_fetch_array($hasil))

{

echo("<tr>");

echo("<td>$no</td>");

 list($id,$nama,$alamat,$nim,$email,$no_telpon)=$row;

      echo("<td>$id</td><td>$nama</td><td>$alamat</td><td>$nim</td><td>$email</td><td>$no_telpon</td>");

 echo("<td><font size='1'><a href=\"edit.php?id=$id\">Edit</a></font></td>");

 echo("<td><font size='1'><a href=\"hapus.php?id=$id\">Hapus</a></font></td></tr>");

echo("</tr>");

$no++;

$end;

}

echo("</table>");

echo ("<br><center>Tambah Data <a href=\"index.php\">OK</a></center>");

?>

6. Buat file edit.php

<?php

include "koneksi.php";

$id = $_GET['id'];

$perintah = "select * from mhsasia where id='$id'";

$hasil =  mysql_query($perintah, $koneksi) or die("gagal melakukan query");

     $row = mysql_fetch_array($hasil);

                 mysql_close($koneksi);

?>

<form method="post" action="update.php">

<table align="center" bordercolor="#999999" bgcolor="#CCCCCC">

<tr><td>ID</td><td><input type="text" name="id" value="<?php echo $row['id']; ?>"></td></tr>

<tr><td>Nama</td><td><input type="text" name="nama" value="<?php echo $row['nama']; ?>"></td></tr>

<tr><td>Alamat</td><td><input type="text" name="alamat" value="<?php echo $row['alamat']; ?>" size="30"></td></tr>

<tr><td>NIM</td><td><input type="text" name="nim" value="<?php echo $row['nim']; ?>"></td></tr>

<tr><td>Email</td><td><input type="text" name="email" value="<?php echo $row['email']; ?>"></td></tr>

<tr><td>No. telpon</td><td><input type="text" name="no_telpon" value="<?php echo $row['no_telpon']; ?>"></td></tr>

<tr><td><input value="Simpan" type="submit" name="submit"/></td>

<td><input type="button" value="Kembali" onClick="self.history.back()"></td></tr>

</table>

</form>

7. Buat file update.php

<?php

include("koneksi.php");

$id = $_POST['id'];

$nama = $_POST['nama'];

$alamat = $_POST['alamat'];

$nim = $_POST['nim'];

$email = $_POST['email'];

$no_telpon = $_POST['no_telpon'];

$query = mysql_query("update mhsasia set nama='$nama', alamat='$alamat', nim='$nim', email='$email',no_telpon='$no_telpon' where id='$id'");

echo "<center><h2><strong>Data Telah di Update</strong></h2><br><hr><a href=\"view.php\">OK</a></center>";

?>

8. Buat file hapus.php

<?php

include("koneksi.php");

mysql_query("DELETE from mhsasia WHERE id='$_GET[id]'");

echo"<center><h2><strong>Data Telah di Hapus</strong></h2><br><hr><a href=\"view.php\">OK</a></center>";

?>

Simpan dalam satu folder, panggil seperti biasa, tampilan sederhana dan simple.

Selesai.

Share this

typhun