Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
CRUD tidak muncul error
tidak muncul error pas di button delete
Viewusers.php
<?php
include "class/pengarsipan.php";
$pengarsipan = new pengarsipan();
?>
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<ol class="breadcrumb">
<li><a href="application.php"><i class="fa fa-tachometer-alt"></i> Dashboard</a></li>
<li><a href=""><i class="fa fa-user"></i> Manajemen Users</a></li>
<li><i class="fa fa-address-card"></i> Daftar Users</li>
</ol>
</div>
</div>
<div class="row">
<div class="col-lg-12">
<div class="table-responsive">
<?php
$no = 1;
?>
<table class="table table-bordered table-hover table-striped tablesorter">
<thead>
<tr>
<th width="5%" style="text-align: center;">No</th>
<th>Nama Lengkap</th>
<th>Username</th>
<th>Password</th>
<th>Hak Akses User</th>
<th colspan="3" style="text-align: center;">Aksi</th>
</tr>
</thead>
<tbody>
<?php $result = $pengarsipan->getDataLogin(); ?>
<?php while ($data = $result->fetch_assoc()) :?>
<tr>
<td width="5%" style="text-align: center;"><?php echo $no++; ?></td>
<td><?php echo $data['nama']; ?></td>
<td><?php echo $data['username']; ?></td>
<td><?php echo $data['password']; ?></td>
<td><?php echo $data['hak']; ?></td>
<td width="8%"><a href="application.php?page=profileusers&username=<?php echo $data['username'];?>" class="btn btn-success">Detail</a></td>
<td width="8%"><a href="application.php?page=updateusers&username=<?php
echo $data['username'];
?>" class="btn btn-primary">Ubah</a></td>
<td width="8%"><a href="application.php?page=datausers" class="btn btn-danger" onclick="deleteThis(<?php echo $data['username']; ?>)">Hapus</a></td>
</tr>
</tbody>
<?php endwhile; ?>
</table>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function() {
$('#dataTables-example').DataTable({
responsive: true
});
});
</script>
<script>
function deleteThis(username){
if (confirm("Are you sure to delete this data?")) {
$.ajax({
type: 'post',
url: 'controllers/users/delete.php',
data: {username:username},
succes : function(data){
if(data){
alert('data deleted');
window.location="application.php?page=datausers";
} else {
alert ("Can't delete data row" )
}
}
})
}
}
</script>
delete.php
<?php
include "/../../class/pengarsipan.php";
$pengarsipan = new pengarsipan();
//mengisi atribut dengan js delete
$pengarsipan->username = $_POST['username'];
//menampung hasil dari method hapus
$error = $pengarsipan->delete();
//pengecekan eror atau berhasil, !$error = berhasil
if(!$error){
//memanggil tampilan data
header("location: ../../application.php?page=datausers");
} else {
//membuat session untuk menampilkan pesan error bernama message
session_start();
$_SESSION['message'] = $error;
//memanggil data kembali
header("location: ../../application.php?page=datausers");
}
?>
pengarsipan.php
public function delete(){
$db = new Database();
//membuka koneksi
$dbConnect = $db->connect();
//querry menghapus data
$sql = "DELETE FROM login Where username = '{$this->username}'";
//eksekusi querry diatas
$data - $dbConnect->query($sql);
//menampung error query simpan data
$error = $dbConnect->error;
//menutup koneksi
$dbConnect = $db->close();
//mengembalikan nilai error
return $error;
}
0
3 Jawaban:
coba di die dump bro diquery deletenya di file pengarsipan.php, itu $this->username dapet drmn?
0
Emang bs gan cara kayak gitu? Klo mau dijadiin parameter di method deletenya. Jd kyk gini <pre> $username = $_POST['username']; $error = $pengarsipan->delete($username); //nah di file pengarsipannya tinggal dioper dah parameternya </pre>
0