-- phpMyAdmin SQL Dump
-- version 4.1.6
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Nov 21, 2018 at 07:58 AM
-- Server version: 5.5.36
-- PHP Version: 5.4.25
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: `latihanphp`
--
-- --------------------------------------------------------
--
-- Table structure for table `mahasiswa`
--
CREATE TABLE IF NOT EXISTS `mahasiswa` (
`nim` varchar(12) NOT NULL,
`nama` varchar(100) NOT NULL,
`alamat` text NOT NULL,
`kota` varchar(50) NOT NULL,
`jk` char(1) NOT NULL,
PRIMARY KEY (`nim`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `mahasiswa`
--
INSERT INTO `mahasiswa` (`nim`, `nama`, `alamat`, `kota`, `jk`) VALUES
('12345', 'nia y', 'medan', 'binjai', 'P'),
('09', 'binjai', 'binjai', 'binjai', 'L'),
('1', 'darman', 'medan', 'medan', 'L'),
('900', 'dara', 'medan', 'medan', 'P'),
('ghfHTR', 'j', 'kk', 'k', 'P'),
('as', 's', 's', 's', 'P'),
('9009', 'rara', 'begumit', 'binjai', 'P'),
('9034', 'dea', 'binjai', 'binjai', 'P'),
('9001', 'aiai', 'binai', 'madsf', 'P'),
('', '', '', '', '');
/*!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 */;
tambah.php
<h4> tambah data </h4>
<form method="post" action ="t_tambah.php">
<table border ="1">
<tr>
<td> Nim </td>
<td> : </td>
<td> <input type="texyt" name ="nim"> </td>
</tr
<tr>
<td> Nama </td>
<td> : </td>
<td> <input type="texyt" name ="nama"> </td>
</tr
<tr>
<td> Alamat </td>
<td> : </td>
<td> <input type="texyt" name ="alamat"> </td>
</tr
<tr>
<td> Kota </td>
<td> : </td>
<td> <input type="texyt" name ="kota"> </td>
</tr
<tr>
<td> JK </td>
<td> : </td>
<td> <input type="radio" name ="jk" value="L">L
<input type="radio" name ="jk" value="P">P </td>
</tr
<tr>
<td> <input type ="submit" value="simpan"> </td>
</tr>
</table>
</form>
<table border=1>
<tr>
<th> No </th>
<th> Nim </th>
<th> Nama </th>
<th> Alamat </th>
<th> Kota </th>
<th> JK </th>
<th colspan="2"> Aksi </th>
</tr>
<?php
include "koneksi.php";
$i = 1;
$sql = mysql_query ("select * from mahasiswa");
while ($data = mysql_fetch_array($sql)) {
echo "
<tr>
<td> $i </td>
<td> $data[nim] </td>
<td> $data[nama] </td>
<td> $data[alamat] </td>
<td> $data[kota] </td>
<td> $data[jk] </td>
<td> <a href=edit.php?nim=$data[nim]> edit </a>
</td>
<td> <a href=hapus.php?nim=$data[nim]> hapus </a>
</td>
</tr>";
$i++;
}
?>
</table>
<br>
<br>
<br>
<table border=1>
<tr>
<th> no </th>
<th> nama </th>
<th> alamat </th>
<th> kota </th>
<th> jk </th>
<th colspan="2"> aksi </th>
</tr>
<?php
include "koneksi.php";
$i = 1;
$sql = mysql_query ("select * from mahasiswa");
while ($data = mysql_fetch_array($sql)) {
echo "
<tr>
<td> $i </td>
<td> $data[nama] </td>
<td> $data[alamat] </td>
<td> $data[kota] </td>
<td> $data[jk] </td>
<td> <a href=edit.php?nim=$data[nim]> edit </a>
</td>
<td> <a href=hapus.php?nim=$data[nim]> hapus </a>
</td>
</tr>";
$i++;
}
?>
</table>
t_tambah.php
<?php
//sertakan file koneksi
include "koneksi.php";
// ubah post menjadi variabel
$nim = $_POST ['nim'];
$nama = $_POST ['nama'];
$alamat = $_POST ['alamat'];
$kota = $_POST ['kota'];
$jk = $_POST ['jk'];
// proses penyiimpanan kedalam data base
$sql = mysql_query ("insert into mahasiswa
(nim,nama,alamat,kota,jk)
values ('$nim','$nama','$alamat','$kota','$jk')");
// jika pemyimpanan berhasil
if ($sql) {
echo "berhasil disimpan";
// skrip penyimpanan otomatis
echo "<meta http-equiv='refresh' content='0;
url=tambah.php'>";
}
// jika gagal
else {
echo "gagal disimpan";
}
?>
edit.php
<?php
include "koneksi.php";
// tangkap variabel dari url
$nim = $_GET['nim'];
// ambil data
$data = mysql_fetch_array (mysql_query ("select * from mahasiswa
where nim='$nim'"));
if ($data[jk] ==L) {
$a = checked;
}
else {
$a = "";
}
if ($data[jk] == P) {
$b = checked;
}
else {
$b = "";
}
?>
<h4> mengubah data </h4>
<form method="post" action=t_edit.php?nim=<?php echo "$nim"; ?>>
<table border="1">
<tr>
<td> nama </td>
<td> : </td>
<td> <input type="text" name="nama" value="<?php echo
"$data[nama]"; ?>"> </td>
</tr>
<tr>
<td> alamat </td>
<td> : </td>
<td> <input type="text" name="alamat" value="<?php echo
"$data[alamat]"; ?>"> </td>
</tr>
<tr>
<td> kota </td>
<td> : </td>
<td> <input type="text" name="kota" value="<?php echo
"$data[kota]"; ?>"> </td>
</tr>
<tr>
<td> jk </td>
<td> : </td>
<td> <input type="radio" name="jk" value="L" <?php echo
"$a"; ?>>L <input type="radio" name="jk" value="P"
<?php echo "$b"; ?>>P </td>
</tr>
<tr>
<td> <input type="submit" value="ubah"> </td>
</tr>
</table>
</form>
t_edit.php
<?php
include "koneksi.php";
//tangkap variabel
$nim = $_GET['nim'];
// ubah parameter POST menjadi variabel
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];
$kota = $_POST['kota'];
$jk = $_POST['jk'];
$ubah = mysql_query ("update mahasiswa set nama='$nama',
alamat='$alamat',
kota='$kota',
jk='$jk'
where nim='$nim'");
if ($ubah) {
echo "<meta http-equiv='refresh' content='0;
url=tambah.php'>";
}
else {
echo "proses ubah gagal";
}
?>
koneksi.php
<?php
mysql_connect ("localhost","root","");
mysql_select_db ("latihanphp");
?>
hapus.php
<?php
include "koneksi.php";
$nim = $_GET['nim'];
$hapus = mysql_query ("delete from mahasiswa where nim='$nim'");
if ($hapus) {
echo "<meta http-equiv='refresh' content='0;
url=tambah.php'>";
}
else {
echo "proses hapus gagal";
}
?>
