source code php mysql tambah edit hapus
TRANSCRIPT
7/23/2019 Source Code PHP Mysql Tambah Edit Hapus
http://slidepdf.com/reader/full/source-code-php-mysql-tambah-edit-hapus 1/8
SOURCE CODE PHP
TAMBAH, EDIT, HAPUS DATA
Contoh Source Code adalah sebagai berikut :
1. db.php-------------------------------------------
<?php
$conn = mysql_connect('localhost', 'root', '');
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("ksp", $conn);
?>
-------------------------------------------
2. index.php-------------------------------------------
<script language="javascript" src="ajax.js"></script>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Books</title>
</head>
<style type="text/css">
button {
margin: 2px;
position: relative;
padding: 4px 8px 4px 4px;
cursor: pointer;
list-style: none;}
button span.ui-icon {
float: left;
margin: 0 4px;
}
#menu-tombol {
padding-bottom:10px;
7/23/2019 Source Code PHP Mysql Tambah Edit Hapus
http://slidepdf.com/reader/full/source-code-php-mysql-tambah-edit-hapus 2/8
padding:5px 5px 5px 5px;
}
#tombol-tambah{
float:left;
width:250px;
}#tombol-cari{
float:right;
width:550px;
text-align:right;
}
#tampil_data{
margin-top:30px;
}
</style>
<body>
<form method="post">
<table width="100%">
<tr>
<td>No Id</td>
<td width="2%">:</td>
<td><input type="text" name="noid" size="15" maxlength="15" /></td>
</tr>
<tr>
<td>Nama :</td>
<td><input type="text" name="nama" size="50" maxlength="50" /></td></tr>
<tr>
<td>Tempat Lahir :</td>
<td><input type="text" name="tmplahir" size="20" maxlength="20" /></td>
</tr>
<tr>
<td>Tanggal Lahir :</td>
<td><input type="text" name="tgllahir" size="15" maxlength="15" /></td>
</tr>
<tr>
<td>Alamat :</td>
<td><input type="text" name="alamat" size="75" maxlength="75" /></td>
</tr>
<tr>
<td>Pekerjaan :</td>
<td><input type="text" name="kerjaan" size="20" maxlength="20" /></td>
</tr>
7/23/2019 Source Code PHP Mysql Tambah Edit Hapus
http://slidepdf.com/reader/full/source-code-php-mysql-tambah-edit-hapus 3/8
<tr>
<td> </td>
<td><input type="submit" name="submit" value="add" /></td>
</tr>
</table>
<?phpif (isset($_POST['submit']))
{
include 'db.php';
$noid=$_POST['noid'] ;
$nama= $_POST['nama'] ;
$tmplahir=$_POST['tmplahir'] ;
$tgllahir=$_POST['tgllahir'] ;
$alamat=$_POST['alamat'] ;
$kerjaan=$_POST['kerjaan'] ;
mysql_query("INSERT INTO
`nasabah`(noid_nas,nama_nas,temlah_nas,tanglah_nas,alamat_nas,pekerjaan_nas)
VALUES ('$noid','$nama','$tmplahir','$tgllahir','$alamat','$kerjaan')");
}
?>
</form>
<table border="1">
<?php
include("db.php");
$result=mysql_query("SELECT * FROM nasabah");
while($test = mysql_fetch_array($result))
{
$id = $test['noid_nas'];
echo "<tr align='center'>";
echo"<td><font color='black'>" .$test['noid_nas']."</font></td>";
echo"<td><font color='black'>" .$test['nama_nas']."</font></td>";
echo"<td><font color='black'>". $test['temlah_nas']. "</font></td>";
echo"<td><font color='black'>". $test['tanglah_nas'].
"</font></td>";
echo"<td><font color='black'>". $test['alamat_nas']. "</font></td>";
7/23/2019 Source Code PHP Mysql Tambah Edit Hapus
http://slidepdf.com/reader/full/source-code-php-mysql-tambah-edit-hapus 4/8
echo"<td><font color='black'>". $test['pekerjaan_nas'].
"</font></td>";
echo"<td> <a href ='view.php?noid_nas=$id'>Edit</a>";
echo"<td> <a href
='del.php?noid_nas=$id'><center>Delete</center></a>";
echo "</tr>";
}
mysql_close($conn);
?>
</table>
</body>
</html>
3. view.php-------------------------------------------
<?php
require("db.php");
$id =$_REQUEST['noid_nas'];
$result = mysql_query("SELECT * FROM nasabah WHERE noid_nas = '$id'");
$test = mysql_fetch_array($result);
if (!$result)
{
die("Error: Data not found..");
}
$noid_nas= $test['noid_nas'] ;
$nama_nas= $test['nama_nas'] ;
$temlah_nas=$test['temlah_nas'] ;
$tanglah_nas=$test['tanglah_nas'] ;
$alamat_nas=$test['alamat_nas'] ;
$pekerjaan_nas=$test['pekerjaan_nas'] ;
if(isset($_POST['simpan']))
{
$noid_save = $_POST['noid'];$nama_save = $_POST['nama'];
$tmplahir_save = $_POST['tmplahir'];
$tgllahir_save = $_POST['tgllahir'];
$alamat_save = $_POST['alamat'];
$kerjaan_save = $_POST['kerjaan'];
7/23/2019 Source Code PHP Mysql Tambah Edit Hapus
http://slidepdf.com/reader/full/source-code-php-mysql-tambah-edit-hapus 5/8
mysql_query("UPDATE nasabah SET noid_nas ='$noid_save', nama_nas
='$nama_save', temlah_nas ='$tmplahir_save', tanglah_nas ='$tgllahir_save',
alamat_nas ='$alamat_save',pekerjaan_nas ='$kerjaan_save' WHERE noid_nas
= '$id'")
or die(mysql_error());
echo "Saved!";
header("Location: index.php");
}
mysql_close($conn);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form method="post">
<table>
<tr>
<td>No Id :</td>
<td><input type="text" name="noid" value="<?php echo $noid_nas ?>"/></td>
</tr><tr>
<td>Nama :</td>
<td><input type="text" name="nama" value="<?php echo $nama_nas ?>"/></td>
</tr>
<tr>
<td>Tempat Lahir :</td>
<td><input type="text" name="tmplahir" value="<?php echo $temlah_nas
?>"/></td>
</tr>
<tr>
<td>Tanggal Lahir :</td>
<td><input type="text" name="tgllahir" value="<?php echo $tanglah_nas
?>"/></td>
</tr>
<tr>
<td>Alamat :</td>
7/23/2019 Source Code PHP Mysql Tambah Edit Hapus
http://slidepdf.com/reader/full/source-code-php-mysql-tambah-edit-hapus 6/8
<td><input type="text" name="alamat" value="<?php echo $alamat_nas
?>"/></td>
</tr>
<tr>
<td>Pekerjaan :</td>
<td><input type="text" name="kerjaan" value="<?php echo $pekerjaan_nas?>"/></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="simpan" value="Simpan" /></td>
</tr>
</table>
</body>
</html>
-------------------------------------------
4. Del.php-------------------------------------------
<?php
include("db.php");
$id =$_REQUEST['noid_nas'];
// sending query
mysql_query("DELETE FROM nasabah WHERE noid_nas = '$id'")
or die(mysql_error());
header("Location: index.php");
?>
-------------------------------------------
Semua file-file diatas disimpan dalam satu di folder, kemudian membuat databasenya denganmenggunakan phpmyadmin atau fasilitas yang lain. Dengan nama databasenya “ksp”,
sebelumnya simpan source code dibawah ini dengan nama : ksp.sql, kemudian export melalui
menu phpmyadmin.
Ksp.sql
-------------------------------------------
-- phpMyAdmin SQL Dump
7/23/2019 Source Code PHP Mysql Tambah Edit Hapus
http://slidepdf.com/reader/full/source-code-php-mysql-tambah-edit-hapus 7/8
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 28, 2014 at 01:18 PM
-- Server version: 5.5.36-- PHP Version: 5.4.27
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: `ksp`
--
-- --------------------------------------------------------
--
-- Table structure for table `nasabah`
--
CREATE TABLE IF NOT EXISTS `nasabah` (
`noid_nas` char(15) NOT NULL,
`nama_nas` varchar(150) NOT NULL,
`temlah_nas` varchar(50) NOT NULL,
`tanglah_nas` varchar(50) NOT NULL,
`alamat_nas` varchar(150) NOT NULL,
`pekerjaan_nas` varchar(100) NOT NULL,
`password_nas` varchar(100) NOT NULL,
PRIMARY KEY (`noid_nas`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `nasabah`
--
INSERT INTO `nasabah` (`noid_nas`, `nama_nas`, `temlah_nas`, `tanglah_nas`, `alamat_nas`,
`pekerjaan_nas`, `password_nas`) VALUES
7/23/2019 Source Code PHP Mysql Tambah Edit Hapus
http://slidepdf.com/reader/full/source-code-php-mysql-tambah-edit-hapus 8/8
('12346', 'Ahmad', 'Magelang', '02-02-1990', 'Jl. Kahuripan 18 Sumber Banjarsari', 'Wiraswata',
'323da337d138beb152eea70f203fcae1'),
('N001', 'haiban', 'magelang', '12-12-1989', 'Pucangan Kartasura SKH', 'Wiraswasta',
'1eebfc1a9a1183060d1f3ae75fa0b358');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`no_id` varchar(15) NOT NULL,
`user_id` varchar(100) NOT NULL,
`password` varchar(50) NOT NULL,
PRIMARY KEY (`no_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`no_id`, `user_id`, `password`) VALUES
('A001', 'admin', '$21232f297a57a5a743894a0e4a801fc3');
/*!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 */;
-------------------------------------------
Demikian sedikit souce code yang bisa kita tulis, selamat mencoba. Semoga berhasil…
Edited : Ahmad Haiban Wail
Email : [email protected]