<?php
mysql_connect("localhost","root","");
mysql_select_db("latihanweb");
?>
Koneksi
<?php
class database {
var $host = "localhost";
var $user = "root";
var $pass = "";
var $db = "database_april";
function __construct(){
$koneksi = mysql_connect($this->host, $this->user, $this->pass);
$database = mysql_select_db($this->db);
}
function tampil_data(){
$data = mysql_query("select * from user");
if(mysql_num_rows($data) > 0){
while ($d = mysql_fetch_array($data)) {
$hasil[] = $d;
}
return $hasil;
}
}
function input($username, $password, $nama){
mysql_query("insert into user values('', '$username', '$password', '$nama')");
}
function hapus($id){
mysql_query("delete from user where id = '$id'");
}
function update($id, $username, $password, $nama){
mysql_query("update user set username = '$username', password = '$password',
nama = '$nama' where id = '$id'");
}
function edit($id){
$data = mysql_query("select * from user where id = '$id'");
while ($d = mysql_fetch_array($data)){
$hasil[] = $d;
}
return $hasil;
}
}
?>
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
<?php
include 'database.php';
$db = new database ();
?>
<h1>CRUD OOP</h1>
<h3>Data User</h3>
<a href="input.php">Input Data</a>
<table border ="1">
<tr>
<th>No</th>
<th>ID</th>
<th>Username</th>
<th>Password</th>
<th>Nama</th>
<th>Opsi</th>
</tr>
<?php
$no=1;
if(!empty ($db->tampil_data())) {
foreach ($db->tampil_data() as $d) {?>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $d['id']; ?></td>
<td><?php echo $d['username']; ?></td>
<td><?php echo $d['password']; ?></td>
<td><?php echo $d['nama']; ?></td>
<td>
<a href="edit.php?id=<?php echo $d['id']; ?>&aksi=edit">Edit</a>
<a href="proses.php?id=<?php echo $d['id']; ?>&aksi=hapus">Hapus</a>
</td>
</tr>
<?php }} ?>
</table>
tampil
<!DOCTYPE html>
<html>
<head>
<title>tambah data user</title>
</head>
<body>
<h2> Form tambah user </h2>
<from name="tambah_user" merhod="POST" action"proses.php?aksi=tambah">
<tr>
<td>Username</td>
<td><input type ="text"name="username"></td>
</tr>
<tr>
<td>password</td>
<td><input type="password" name ="password"></td>
</tr>
<tr>
<td>Nama</td>
<td><input type="text" name="nama"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value=" Simpan">
</tr>
</table>
</from>
</body>
</html>
input
<?php
include 'database.php';
$db = new database();
$aksi = $_GET['aksi'];
if ($aksi=="tambah") {
$db->input($_POST['username'],md5($_POST['[password']),$_POST['nama']);
header("location:tampil.php");
}elseif ($aksi == "hapus"){
# code...
$db->hapus ($_GET['id']);
header("location:tampil.php");
}elseif ($aksi=="update"){
$db->update ($_POST['id'],$_POST['username'],md5($_POST['password']), $_POST['nama']);
header("location:tampil.php");
}
?>
proses
<?php
include 'database.php';
$db = new database();
?>
<h3>Edit Data</h3>
<form action="proses.php?aksi=update" method="POST">
<?php
foreach($db->edit ($_GET['id']) as $d) { ?>
<tr>
<td>Username</td>
<td>
<input type="hidden" name="id" value="<?php echo $d['id'] ?>">
<input type="text" name="username" value="<?php echo $d['username'] ?>">
</td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="password" value="<?php echo $d ['password'] ?>"></td>
</tr>
<tr>
<td>Nama</td>
<td><input type= "text" name="nama"value="<?php echo $d['nama'] ?>"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Simpan"></td>
</tr>
</table>
<?php } ?>
</form>
edit
Komentar
Posting Komentar