Pertama pastikan anda sudah menginstal Xampp dan Sql yoq sebagai server..
buat data base terlebis dahulu dengan nama db_akademik lalu membuat tabel tb_mhs
seperti di gambar bawah ini :
langkah ke dua buat folder baru dengan nama datamhs di C > xampp >htdocs > datamhs
lalu di folder datamhs buat file seperti di bawah ini pake notepad saja biar gampang jangan lupa simpan file dengan .php contoh : edit.php
isikan file file tersebut dengan sourcode di bawah ini :
connect.php
<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$dbname = 'db_akademik';
$connect = mysql_connect($host, $user, $pass) or die(mysql_error());
$dbselect = mysql_select_db($dbname);
?>
delete.php
<?php
include('connect.php');
$id = $_GET['id'];
$query = mysql_query("delete from tb_mhs where user_id='$id'") or die(mysql_error());
if ($query) {
header('location:view.php?message=delete');
}
?>
edit.php
<?php
include('connect.php');
?>
<html>
<head>
<title>edit</title>
<style>
body{
background: #FFF ;
}
#header{
padding:2px;
background-color: #F63;
}
h1{
float:inherit;
font-size:34px;
background-color: #0F0;
border:2px solid;
border-color: #090;
}
form {
border:2px solid;
background-color: #0F3 ;
border-color: #090;
padding:0px;
margin-top:2px;
width:300px;
float:center;
}
</style>
</head>
<body>
<h1>Form Edit Data</h1>
<?php
$id = $_GET['id'];
$query = mysql_query("select * from Tb_mhs where user_id='$id'") or die(mysql_error());
$data = mysql_fetch_array($query);
?>
<form name="update_data" action="update.php" method="post">
<input type="hidden" name="user_id" value="<?php echo $id; ?>" />
<table border="0" cellpadding="5" cellspacing="0">
<tbody>
<td>Nim</td>
<td>:</td>
<td><input type="text" name="nim" maxlength="20" required value="<?php echo $data['nim']; ?>" disabled /></td>
</tr>
<tr>
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" maxlength="30" required value="<?php echo $data['nama']; ?>" /></td>
</tr>
<tr>
<td>Prodi</td>
<td>:</td>
<td><input type="text" name="prodi" maxlength="25" required value="<?php echo $data['prodi']; ?>" /></td>
</tr>
<td>kelas</td>
<td>:</td>
<td><input type="text" name="kelas" maxlength="35" required value="<?php echo $data['kelas']; ?>" /></td>
</tr>
<td align="right" colspan="3"><input type="submit" name="submit" value="Simpan" /></td>
</tr>
</tbody>
</table>
</form>
<a href="view.php">Lihat Data</a>
</body>
</html>
index.php
<?php
?>
<html>
<head>
<title>input</title>
<style>
body{
background: #FFF ;
}
#header{
padding:2px;
background-color: #F63;
}
h1{
float:inherit;
font-size:34px;
background-color: #0F0;
border:2px solid;
border-color: #090;
}
form {
border:2px solid;
background-color: #0f0;
border-color:#090;
padding:0px;
margin-top:2px;
width:300px;
float:center;
}
</style>
</head>
<body>
<h1>Form Input Data</h1>
<p>
<?php
if (!empty($_GET['message']) && $_GET['message'] == 'success') {
echo '<h3>sukses menambah data!</h3>';
}
?>
</p>
<form name="input_data" action="insert.php" method="post">
<table width="279" border="0" cellpadding="5" cellspacing="0">
<tbody>
<tr>
<td>Nim</td>
<td>:</td>
<td><input type="text" name="nim" maxlength="10" required /></td>
</tr>
<tr>
<tr>
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" maxlength="30" required /></td>
</tr>
<tr>
<td>Prodi</td>
<td>:</td>
<td><input type="text" name="prodi" maxlength="25" required /></td>
</tr>
<tr>
<td>kelas</td>
<td>:</td>
<td><input type="text" name="kelas" maxlength="5" required /></td>
</tr>
<tr>
<td align="right" colspan="3"> <input type="submit" name="submit" value="Simpan" /> </td>
</tr>
</tbody>
</table>
</form>
<a href="view.php">Lihat Data</a>
</body>
</html><?php
?>
<html>
<head>
<title>input</title>
<style>
body{
background: #FFF ;
}
#header{
padding:2px;
background-color: #F63;
}
h1{
float:inherit;
font-size:34px;
background-color: #0F0;
border:2px solid;
border-color: #090;
}
form {
border:2px solid;
background-color: #0f0;
border-color:#090;
padding:0px;
margin-top:2px;
width:300px;
float:center;
}
</style>
</head>
<body>
<h1>Form Input Data</h1>
<p>
<?php
if (!empty($_GET['message']) && $_GET['message'] == 'success') {
echo '<h3>sukses menambah data!</h3>';
}
?>
</p>
<form name="input_data" action="insert.php" method="post">
<table width="279" border="0" cellpadding="5" cellspacing="0">
<tbody>
<tr>
<td>Nim</td>
<td>:</td>
<td><input type="text" name="nim" maxlength="10" required /></td>
</tr>
<tr>
<tr>
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" maxlength="30" required /></td>
</tr>
<tr>
<td>Prodi</td>
<td>:</td>
<td><input type="text" name="prodi" maxlength="25" required /></td>
</tr>
<tr>
<td>kelas</td>
<td>:</td>
<td><input type="text" name="kelas" maxlength="5" required /></td>
</tr>
<tr>
<td align="right" colspan="3"> <input type="submit" name="submit" value="Simpan" /> </td>
</tr>
</tbody>
</table>
</form>
<a href="view.php">Lihat Data</a>
</body>
</html>
insert.php
<?php
include('connect.php');
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$prodi = $_POST['prodi'];
$kelas = $_POST['kelas'];
$query = mysql_query("insert into tb_mhs values('', '$nim', '$nama', '$prodi', '$kelas')") or die(mysql_error());
if ($query) {
header('location:index.php?message=success');
}
?>
update.php
<?php
include('connect.php');
$id = $_POST['user_id'];
$nama = $_POST['nama'];
$prodi = $_POST['prodi'];
$kelas = $_POST['kelas'];
$query = mysql_query("update tb_mhs set nama='$nama', prodi='$prodi', kelas='$kelas' where user_id='$id'") or die(mysql_error());
if ($query) {
header('location:view.php?message=success');
}
?>
view.php
<?php
include('connect.php');
?>
<html>
<head>
<title>Data</title>
<style>
}
h1{
float:inherit;
font-size:34px;
background-color: #0F0;
border:2px solid;
border-color: #090;
}
table{
width:;
margin:;
border-collapse: collapse;
box-shadow: #FF0 3px;
background-color: # FFF;
}
thead tr {
background-color: #0C0;
}
</style>
</head>
<body>
<h1>Form Data</h1>
<?php
if (!empty($_GET['message']) && $_GET['message'] == 'success') {
echo '<h3>Sukses meng update data!</h3>';
} else if (!empty($_GET['message']) && $_GET['message'] == 'delete') {
echo '<h3>Sukses Menghapus data!</h3>';
}
?>
<p><a href="index.php">Tambah data </a>
<table border="1" cellpadding="2" cellspacing="0">
<thead>
<tr>
<td>No</td>
<td>Nim</td>
<td>Nama</td>
<td>Prodi</td>
<td>Kelas</td>
<td>Opsi</td>
</tr>
</thead>
<tbody>
<?php
$query = mysql_query("select * from tb_mhs");
$no = 1;
while ($data = mysql_fetch_array($query)) {
?>
<tr>
<td><?php echo $no; ?></td>
<td><?php echo $data['nim']; ?></td>
<td><?php echo $data['nama']; ?></td>
<td><?php echo $data['prodi']; ?></td>
<td><?php echo $data['kelas']; ?></td>
<td>
<a href="edit.php?id=<?php echo $data['user_id']; ?>">Edit</a> ||
<a href="delete.php?id=<?php echo $data['user_id']; ?>">Hapus</a>
</td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
</body>
</html>
JIKA SUDAH SELESAI BUKA CROMEE ATAU MOZILA
KETIK ALAMAT LOCALHOST/DATAMHS UNTUK MENAMPILKAN
HASIL PROGRAM TADI :
SELAMAT MENCOBA
Komentar
Posting Komentar