| Server IP : 212.252.79.165 / Your IP : 216.73.216.24 [ Web Server : Apache System : Linux 212-252-79-165.cprapid.com 5.15.0-153-generic #163-Ubuntu SMP Thu Aug 7 16:37:18 UTC 2025 x86_64 User : cehaburo ( 1001) PHP Version : 8.1.33 Disable Function : exec,passthru,shell_exec,system Domains : 48 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/cehaburo/public_html/admin/ |
Upload File : |
<?php
include 'lib/include.php';
$qr_query = $ceha->query("SELECT tbl_qr.id, tbl_qr.title, tbl_qr_category.name as category_name FROM tbl_qr LEFT JOIN tbl_qr_category ON tbl_qr.category_id = tbl_qr_category.id");
include 'header.php';
?>
<div class="container">
<div class="row align-items-center mb-3">
<div class="col-6">
<h4 class="card-title">QR Sayfalar</h4>
</div>
<div class="col-6 text-right">
<a href="qr-create.php">
<button class="btn btn-primary" style="width: 200px;">Yeni</button>
</a>
</div>
</div>
<div class="row">
<div class="col-md-12 grid-margin stretch-card">
<div class="card">
<div class="card-body">
<div class="table-responsive">
<table class="table">
<thead>
<tr>
<th>Başlık</th>
<th>Kategori</th>
<th>İşlemler</th>
</tr>
</thead>
<tbody>
<?php
while ($qr = $qr_query->fetch_assoc()) {
echo '<tr class="clickable-row" data-href="qr-update.php?id=' . $qr['id'] . '">';
echo '<td>' . htmlspecialchars($qr['title'], ENT_QUOTES, 'UTF-8') . '</td>';
echo '<td>' . htmlspecialchars($qr['category_name'], ENT_QUOTES, 'UTF-8') . '</td>';
echo '<td width="25px"><button class="btn btn-primary btn-sm delete-qr" data-id="' . $qr['id'] . '"><i class="mdi mdi-delete"></i></button></td>';
echo '</tr>';
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include 'footer.php'; ?>
<style>
.clickable-row:hover {
cursor: pointer;
background: #f5f5f5;
}
</style>
<script>
document.addEventListener('DOMContentLoaded', function() {
document.querySelectorAll('.delete-qr').forEach(function(deleteButton) {
deleteButton.addEventListener('click', function(event) {
event.preventDefault();
event.stopPropagation(); // Prevent row click event
var qrId = this.getAttribute('data-id');
if (confirm('Bu QR sayfasını silmek istediğinize emin misiniz?')) {
fetch('dba/qr-delete.php', {
method: 'POST',
headers: {
'Content-Type': 'application/json'
},
body: JSON.stringify({ id: qrId })
})
.then(response => response.json())
.then(data => {
if (data.success) {
// Remove the row from the table
this.closest('tr').remove();
} else {
alert('QR sayfası silinirken bir hata oluştu: ' + data.error);
}
})
.catch(error => console.error('Error:', error));
}
});
});
document.querySelectorAll('.clickable-row').forEach(function(row) {
row.addEventListener('click', function() {
window.location.href = this.getAttribute('data-href');
});
});
});
</script>