Script Hapus Data dan Edit Data pada html dan php
1. BUAT FILE tampil_anggota.php
<?php
mysql_connect("localhost","root","") or die (mysql_error());
mysql_select_db("latihan");
if($_GET['action'] == 'delete'){
mysql_query("delete from anggota where id='".mysql_real_escape_string($_GET['id'])."'");
}
$query = "select * from anggota order by id";
$rowSet = mysql_query($query);
echo '<table border="1" width="700">';
echo '<tr>';
echo '<td><center>ID</td>';
echo '<td><center>USer Name</td>';
echo '<td><center>Password</td>';
echo '<td><center>Nama Lengkap</td>';
echo '<td><center>Alamat</td>';
echo '<td><center>Email</td>';
echo '<td><center>Action</td>';
echo '</td>';
while($row = mysql_fetch_array($rowSet)){
echo '<tr>';
echo '<td><center>'.$row['id'].'</td>';
echo '<td><center>'.$row['user_name'].'</td>';
echo '<td><center>'.$row['user_pass'].'</td>';
echo '<td><center>'.$row['nama_lengkap'].'</td>';
echo '<td><center>'.$row['alamat'].'</td>';
echo '<td><center>'.$row['email'].'</td>';
echo '<td><center>';
echo '<a href="tampilanggota.php?id='.$row['id'].'&action=delete">Delete</a>';
echo ' | <a href="form_edit_anggota.html?id='.$row['id'].'">Edit</a>';
echo '</td>';
echo '</tr>';
}
echo '</table>';
?>
mysql_connect("localhost","root","") or die (mysql_error());
mysql_select_db("latihan");
if($_GET['action'] == 'delete'){
mysql_query("delete from anggota where id='".mysql_real_escape_string($_GET['id'])."'");
}
$query = "select * from anggota order by id";
$rowSet = mysql_query($query);
echo '<table border="1" width="700">';
echo '<tr>';
echo '<td><center>ID</td>';
echo '<td><center>USer Name</td>';
echo '<td><center>Password</td>';
echo '<td><center>Nama Lengkap</td>';
echo '<td><center>Alamat</td>';
echo '<td><center>Email</td>';
echo '<td><center>Action</td>';
echo '</td>';
while($row = mysql_fetch_array($rowSet)){
echo '<tr>';
echo '<td><center>'.$row['id'].'</td>';
echo '<td><center>'.$row['user_name'].'</td>';
echo '<td><center>'.$row['user_pass'].'</td>';
echo '<td><center>'.$row['nama_lengkap'].'</td>';
echo '<td><center>'.$row['alamat'].'</td>';
echo '<td><center>'.$row['email'].'</td>';
echo '<td><center>';
echo '<a href="tampilanggota.php?id='.$row['id'].'&action=delete">Delete</a>';
echo ' | <a href="form_edit_anggota.html?id='.$row['id'].'">Edit</a>';
echo '</td>';
echo '</tr>';
}
echo '</table>';
?>
Muncul tampilan seperti di bawah
2. BUAT FILE form_edit_anggota.html
<html>
<title>:::EDITDATA:::</title>
<body>
<h2><p align="center"><blink>EDIT DATA</h></p>
<form method="post" action="edit_anggota.php">
<table border="0" align="center">
<tr>
<td>id</td>
<td>:</td>
<td><input type="text" name="id">
</tr>
<tr>
<td>User Name</td>
<td>:</td>
<td><input type="text" name="user"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input type="password" name="pass"></td>
</tr>
<tr>
<td>Nama Lengkap</td>
<td>:</td>
<td><input type="text" name="nama"></td>
</tr>
<tr>
<td>Alamat</td>
<td>:</td>
<td><input type="text" name="alamat"></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><input type="text" name="email"></td>
</tr>
</table>
<br>
<table border="0" align="center">
<tr>
<td><input type="submit" value="save"></td>
<td><input type="reset" value="reset"></td>
</tr>
</table>
</from>
</body>
</html>
<title>:::EDITDATA:::</title>
<body>
<h2><p align="center"><blink>EDIT DATA</h></p>
<form method="post" action="edit_anggota.php">
<table border="0" align="center">
<tr>
<td>id</td>
<td>:</td>
<td><input type="text" name="id">
</tr>
<tr>
<td>User Name</td>
<td>:</td>
<td><input type="text" name="user"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input type="password" name="pass"></td>
</tr>
<tr>
<td>Nama Lengkap</td>
<td>:</td>
<td><input type="text" name="nama"></td>
</tr>
<tr>
<td>Alamat</td>
<td>:</td>
<td><input type="text" name="alamat"></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><input type="text" name="email"></td>
</tr>
</table>
<br>
<table border="0" align="center">
<tr>
<td><input type="submit" value="save"></td>
<td><input type="reset" value="reset"></td>
</tr>
</table>
</from>
</body>
</html>
2. BUAT FILEedit_anggota.php
$id=$_POST['id'];
$user=$_POST['user'];
$pass=$_POST['pass'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$email=$_POST['email'];
mysql_connect("localhost","root","")or die(mysql_error());
mysql_select_db("latihan")or die(mysql_error());
$query = "update anggota set user_name='$user', user_pass='$pass', nama_lengkap='$nama', alamat='$alamat', email='$email' where id='$id'";
$hasil = mysql_query($query);
if($hasil){
echo "Data Anggota Berhasil Di Edit <br> ";
echo '<a href=tampilanggota.php>LIHAT DATA ANGGOTA</a>';
}else{
echo "Error! gagal menyimpan Edit Data Anggota:".mysql_error();
}
?>
2 komentar:
thanks
Casino Site - Live - LuckyClub
Casino luckyclub.live site. Find your dream casino in Live! It's a perfect venue where everyone is dealt with their own casino gambling experience. Our experience is Rating: 4.5 · 17 votes
Posting Komentar