1.Edit.php
<!DOCTYPE html>
<html>
<head><title>EDIT FORMULIR</title>
</head>
<body bgcolor="blue">
<?php
include "konek.php";
$no = $_GET['no'];
$cari = "select * from formulir where no='$no'";
$kueri = mysql_query($cari);
$ambil = mysql_fetch_array($kueri);
?>
<fieldset>
<form action="inputedit.php" method="POST" name="edit">
<input type="hidden" name="no" value="<?php echo $ambil['no']; ?>" />
<table border="0" width="500px">
<tr>
<td>Urutan KE</td>
<td>:</td>
<td><?php echo $ambil['no']; ?></td>
<td>Data Sebelumnya</td>
</tr>
<tr>
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" value="<?php echo $ambil['nama']; ?>" /></td>
<td><?php echo $ambil['nama']; ?></td>
</tr>
<tr>
<td>NIM</td>
<td>:</td>
<td><input type="text" name="nim" value="<?php echo $ambil['nim']; ?>" /></td>
<td><?php echo $ambil['nim']; ?></td>
</tr>
<tr>
<td>Fakultas</td>
<td>:</td>
<td><Select name="fakultas">
<option>Komunikasi</option>
<option>Informatika</option>
</select>
</td>
<td><?php echo $ambil['fakultas']; ?></td>
</tr>
<tr>
<td>Jenis Kelamin</td>
<td>:</td>
<td><input type="radio" name="jk" value="Laki-Laki" checked/>Laki-Laki <input type="radio" name="jk" value="perempuan" /> Perempuan </td>
<td><?php echo $ambil['jk']; ?></td>
</tr>
<tr>
<td>NO HP</td>
<td>:</td>
<td><input type="text" name="hp" value="<?php echo $ambil['hp']; ?>" /></td>
<td><?php echo $ambil['hp']; ?></td>
</tr>
<tr>
<td>Alamat</td>
<td>:</td>
<td><textarea name="alamat" value="<?php echo $ambil['alamat']; ?>"></textarea></td>
<td><?php echo $ambil['alamat']; ?></td>
</tr>
<tr>
<td><input type="submit" value="KIRIM" name="submit"/></td>
<td colspan="2"><input type="reset" value="Ulangi" /></td>
<td><a href="index.php" alt="Kembali ke HOME">KEMBALI KE HOME</a></td>
</tr>
</table>
</form>
</fieldset>
</body>
</html>
2.formulir.sql
-- phpMyAdmin SQL Dump
-- version 4.0.4.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 20, 2014 at 12:44 PM
-- Server version: 5.5.32
-- PHP Version: 5.4.19
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: `data_mahasiswa`
--
-- --------------------------------------------------------
--
-- Table structure for table `formulir`
--
CREATE TABLE IF NOT EXISTS `formulir` (
`no` int(3) NOT NULL AUTO_INCREMENT,
`nama` text NOT NULL,
`nim` text NOT NULL,
`fakultas` text NOT NULL,
`jk` text NOT NULL,
`hp` text NOT NULL,
`alamat` text NOT NULL,
PRIMARY KEY (`no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `formulir`
--
INSERT INTO `formulir` (`no`, `nama`, `nim`, `fakultas`, `jk`, `hp`, `alamat`) VALUES
(6, 'Reza', 'L200130179', 'Informatika', 'Laki-Laki', '98786876', 'solo'),
(8, 'Darto Helm', '69', 'Komunikasi', 'perempuan', '666', 'solo');
/*!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 */;
3.Hapus.php
<?php
include "konek.php";
$no = $_GET['no'];
mysql_query("delete from formulir where no='$no'") or die("Gagal menghapus data.");
echo "<script> alert(' Data Telah Berhasil Di HAPUS' ) </script>";
echo" <meta http-equiv='refresh' content='0;url=index.php' />";
?>
4.Index.php
<!DOCTYPE html>
<html>
<head><title>Formulir Data Mahasiswa</title></head>
<body bgcolor="blue">
<fieldset>
<form action="input.php" method="POST">
<table border="0" width="500px">
<font size="36">PROFIL</font>
<hr>
<tr>
<td>Nama</td>
<td>:</td>
<td>Reza Benarivo</td>
</tr>
<tr>
<td>NIM</td>
<td>:</td>
<td>L200130179</td>
</tr>
<tr>
<td>Kelas</td>
<td>:</td>
<td>E</td>
</tr>
<tr>
<td>Fakultas</td>
<td>:</td>
<td>Teknik Informatika</td>
</tr>
<br>
<hr>
<font size="36">KONTAK</font>
<hr>
<tr>
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" value="Nama" /></td>
</tr>
<tr>
<td>NIM</td>
<td>:</td>
<td><input type="text" name="nim" value="NIM" /></td>
</tr>
<tr>
<td>Fakultas</td>
<td>:</td>
<td><Select name="fakultas">
<option>Komunikasi</option>
<option>Informatika</option>
</select>
</td>
<tr>
<td>Jenis Kelamin</td>
<td>:</td>
<td><input type="radio" name="jk" value="Laki-Laki" checked/>Laki-Laki <input type="radio" name="jk" value="perempuan" /> Perempuan</td>
</tr>
<tr>
<td>NO HP</td>
<td>:</td>
<td><input type="text" name="hp" value="Nomor HP" /></td>
</tr>
<tr>
<td>Alamat</td>
<td>:</td>
<td><textarea name="alamat"></textarea></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="KIRIM" /></td>
<td><input type="reset" value="Ulangi" /></td>
</tr>
</table>
</form>
</fieldset>
<br>
<br>
<table border="1" width="800px">
<tr>
<td>NO</td>
<td>NAMA</td>
<td>NIM</td>
<td>FAKULTAS</td>
<td>JENIS KELAMIN</td>
<td>NO HP</td>
<td>ALAMAT</td>
<td>ACTION</td>
<tr>
<tr>
<?php
include "konek.php";
$cari="select * from formulir";
$kueri=mysql_query($cari);
while ($ambil=mysql_fetch_array($kueri)){
?>
<tr>
<td><?php echo $ambil['no']; ?></td>
<td><?php echo $ambil['nama']; ?></td>
<td><?php echo $ambil['nim']; ?></td>
<td><?php echo $ambil['fakultas']; ?></td>
<td><?php echo $ambil['jk']; ?></td>
<td><?php echo $ambil['hp']; ?></td>
<td><?php echo $ambil['alamat']; ?></td>
<td><a href="edit.php?no=<?php echo $ambil['no']; ?>">Edit</a> |
<a href="hapus.php?no=<?php echo $ambil['no']; ?>">Hapus</a></td>
</tr>
<?php
};
mysql_close();
?>
</table>
</body>
</html>
5.Input.php
<?php
include "konek.php";
$nama=$_POST['nama'];
$nim=$_POST['nim'];
$fakultas=$_POST['fakultas'];
$jk=$_POST['jk'];
$hp=$_POST['hp'];
$alamat=$_POST['alamat'];
$kirim="INSERT INTO formulir(nama, nim, fakultas, jk, hp, alamat) VALUES('$nama','$nim','$fakultas','$jk','$hp','$alamat')";
mysql_query($kirim);
echo "<script> alert(' Data Telah Berhasil Di upload' ) </script>";
echo" <meta http-equiv='refresh' content='0;url=index.php' />";
mysql_close();
?>
6.Inputedit.php
<?php
include "konek.php";
$no=$_POST['no'];
$nama=$_POST['nama'];
$nim=$_POST['nim'];
$fakultas=$_POST['fakultas'];
$jk=$_POST['jk'];
$hp=$_POST['hp'];
$alamat=$_POST['alamat'];
$kirim="UPDATE formulir SET nama='$nama', nim='$nim', fakultas='$fakultas', jk='$jk', hp='$hp', alamat='$alamat' where no='$no'";
mysql_query($kirim);
mysql_close();
echo "<script> alert(' Data Telah Berhasil Di EDIT' ) </script>";
echo" <meta http-equiv='refresh' content='0;url=index.php' />";
?>
7.Konek.php
<?php
$host = "localhost";
$user = "root";
$pass = "";
$database = "data_mahasiswa";
$konek = mysql_connect($host, $user, $pass) or die ('Gagal Konek!');
mysql_select_db($database);
?>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>SELESAI<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
