Create delete php dengan OOP
simpan script di bawah ini dengan file database.php dan buatkan database dengan nama mhs
<?php
/**
*
*/
class Database
{
private $host;
private $username;
private $password;
private $db_c;
function __construct ($a,$b,$c,$d){
$this->host = $a;
$this->username = $b;
$this->password = $c;
$this->db_c=$d;
}
public function sambungan(){
mysql_connect($this->host,$this->username,$this->password);
mysql_select_db($this->db_c);
}
public function tambahdata($nim,$nama,$alamat){
$query = "insert into mhs (nim,nama,alamat) values ('$nim','$nama',
'$alamat')";
$sql = mysql_query($query);
if ($sql) {
echo "Berhasil";
}
else{
echo "Gagal";
}
}
public function getData($nim){
$query = "select * from mhs where nim=$nim";
$getData = mysql_query($query);
while($data = mysql_fetch_row($getData)){
$hasil['nim'] = $data[0];
$hasil['nama'] = $data[1];
$hasil['alamat'] = $data[2];
}
return $hasil;
}
public function tampildata(){
$query = "select * from mhs";
$sql = mysql_query($query);
$i = 0;
while($data = mysql_fetch_array($sql)){
echo "<tr>";
echo "<td>".$i."</td>";
echo "<td>".$data['0']."</td>";
echo "<td>".$data['1']."</td>";
echo "<td>".$data['2']."</td>";
echo "<td> <a href='simpan.php?aksi=hapus&nim=".$data['0']."'>Hapus</a>
</td>";
echo "</tr>";
$i++;
}
}
public function hapus($nim){
$query = "delete from mhs where nim=".$nim;
$sql = mysql_query($query);
if($sql)
echo "Berhasil<br>";
else
echo "Gagal Hapus <br>";
}
}
?>
simpan script dibawah dengan nama index.php
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form action="simpan.php?aksi=tambah" method="POST">
nim:<input type="text" name="nim"/><br>
nama:<input type="text" name="nama"/><br>
alamat: <input type="textarea" name="alamat"/><br>
<input type="submit" value="simpan"/><br>
</form>
<a href="simpan.php?aksi=tampil"><button>Tampil</button></a>
</body>
</html>
simpan script dibawah dengan nama simpan.php
<?php
include "databases.php";
$host = 'localhost';
$username = 'root';
$password = '';
$db_c = 'prak4';
$db = new Database($host,$username,$password,$db_c);
$db->sambungan();
$aksi = $_GET['aksi'];
if ($aksi=='tambah') {
$db->tambahdata($_POST['nim'],$_POST['nama'],$_POST['alamat']);
}
elseif ($aksi =='tampil') {
include "tampil.php";
}
elseif ($aksi=='hapus') {
$db->hapus($_GET['nim']);
}
?>
simpan script di bawah dengan nama tampil.php
<html>
<head>
</head>
<body>
<table border="1">
<tr>
<th>No</th>
<th>NIM</th>
<th>NAMA</th>
<th>ALAMAT</th>
<th>AKSI</th>
</tr>
<?php
$db->tampildata();
?>
</table>
</body>
</html>
ABOUT THE AUTHOR
Hello We are OddThemes, Our name came from the fact that we are UNIQUE. We specialize in designing premium looking fully customizable highly responsive blogger templates. We at OddThemes do carry a philosophy that: Nothing Is Impossible
0 komentar:
Posting Komentar