刪除資料是高風險操作,必須包含確認機制、權限驗證、稽核軌跡。本文涵蓋:前端確認對話框、AJAX 非同步刪除、後端 PDO 實作、軟刪除模式、CSRF 保護與權限控制。
<a href="delete.php?id=123"
onclick="return confirm('確定要刪除這筆記錄嗎?此操作無法復原!')"
>刪除</a>
<!-- 觸發按鈕 -->
<button type="button" class="btn btn-danger btn-sm"
data-bs-toggle="modal" data-bs-target="#deleteModal"
data-id="123" data-name="重要文件">
刪除
</button>
<!-- Modal -->
<div class="modal fade" id="deleteModal" tabindex="-1">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title">確認刪除</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal"></button>
</div>
<div class="modal-body">
確定要刪除 嗎?此操作無法復原。
<input type="hidden" id="deleteItemId">
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">取消</button>
<button type="button" class="btn btn-danger" id="confirmDelete">確定刪除</button>
</div>
</div>
</div>
</div>
<script>
const modal = document.getElementById('deleteModal');
modal.addEventListener('show.bs.modal', e => {
const btn = e.relatedTarget;
document.getElementById('deleteItemId').value = btn.dataset.id;
document.getElementById('deleteItemName').textContent = btn.dataset.name;
});
document.getElementById('confirmDelete').addEventListener('click', () => {
const id = document.getElementById('deleteItemId').value;
fetch('delete_api.php', {
method: 'POST',
headers: {'Content-Type': 'application/x-www-form-urlencoded'},
body: 'id=' + encodeURIComponent(id) + '&csrf_token=' + csrfToken
}).then(r => r.json()).then(res => {
if (res.success) {
location.reload();
} else {
alert('刪除失敗: ' + res.message);
}
});
bootstrap.Modal.getInstance(modal).hide();
});
</script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
document.querySelectorAll('.delete-btn').forEach(btn => {
btn.addEventListener('click', e => {
e.preventDefault();
Swal.fire({
title: '確定刪除?',
text: '此操作無法復原!',
icon: 'warning',
showCancelButton: true,
confirmButtonColor: '#d33',
cancelButtonColor: '#3085d6',
confirmButtonText: '確定刪除',
cancelButtonText: '取消'
}).then(result => {
if (result.isConfirmed) {
window.location.href = btn.href;
}
});
});
});
</script>
<?php
require 'config.php';
require 'Database.php';
header('Content-Type: application/json');
// 僅接受 POST
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
http_response_code(405);
echo json_encode(['success' => false, 'message' => '方法不允許']);
exit;
}
// CSRF 驗證
$csrfToken = $_POST['csrf_token'] ?? '';
if (!hash_equals($_SESSION['csrf_token'] ?? '', $csrfToken)) {
http_response_code(403);
echo json_encode(['success' => false, 'message' => 'CSRF Token 無效']);
exit;
}
// 參數驗證
$id = (int)($_POST['id'] ?? 0);
if ($id <= 0) {
echo json_encode(['success' => false, 'message' => '無效 ID']);
exit;
}
try {
$db = Database::getInstance(require 'config.php')->getPdo();
// 權限檢查 (示例:只有擁有者或管理員可刪除)
$stmt = $db->prepare("SELECT user_id FROM records WHERE id = ?");
$stmt->execute([$id]);
$record = $stmt->fetch();
if (!$record) {
echo json_encode(['success' => false, 'message' => '記錄不存在']);
exit;
}
$currentUserId = $_SESSION['user_id'] ?? 0;
$isAdmin = $_SESSION['is_admin'] ?? false;
if (!$isAdmin && $record['user_id'] !== $currentUserId) {
echo json_encode(['success' => false, 'message' => '權限不足']);
exit;
}
// 執行刪除 (軟刪除模式:更新 deleted_at)
$stmt = $db->prepare("UPDATE records SET deleted_at = NOW() WHERE id = ?");
$stmt->execute([$id]);
// 真刪除模式:
// $stmt = $db->prepare("DELETE FROM records WHERE id = ?");
// $stmt->execute([$id]);
if ($stmt->rowCount() > 0) {
// 記錄稽核日誌
$logStmt = $db->prepare("INSERT INTO audit_logs (user_id, action, target_table, target_id, ip) VALUES (?, 'DELETE', 'records', ?, ?)");
$logStmt->execute([$currentUserId, $id, $_SERVER['REMOTE_ADDR']]);
echo json_encode(['success' => true, 'message' => '刪除成功']);
} else {
echo json_encode(['success' => false, 'message' => '刪除失敗,資料可能已不存在']);
}
} catch (PDOException $e) {
error_log("Delete error: " . $e->getMessage());
echo json_encode(['success' => false, 'message' => '伺服器錯誤']);
}
?>
CREATE TABLE records (
id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
user_id BIGINT UNSIGNED NOT NULL,
title VARCHAR(200) NOT NULL,
content TEXT,
deleted_at DATETIME NULL DEFAULT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
INDEX idx_user_deleted (user_id, deleted_at)
);
<?php
// 使用 Global Scope 概念 (需框架支援) 或手動加條件
// 手動方式:
$stmt = $db->prepare("SELECT * FROM records WHERE deleted_at IS NULL AND user_id = ?");
$stmt->execute([$userId]);
// 封裝到 Model
class Record {
private $db;
public function __construct(PDO $db) { $this->db = $db; }
public function all($userId) {
$stmt = $this->db->prepare("SELECT * FROM records WHERE deleted_at IS NULL AND user_id = ? ORDER BY created_at DESC");
$stmt->execute([$userId]);
return $stmt->fetchAll();
}
public function find($id, $userId = null) {
$sql = "SELECT * FROM records WHERE id = ? AND deleted_at IS NULL";
$params = [$id];
if ($userId) { $sql .= " AND user_id = ?"; $params[] = $userId; }
$stmt = $this->db->prepare($sql);
$stmt->execute($params);
return $stmt->fetch();
}
public function softDelete($id, $userId) {
$stmt = $this->db->prepare("UPDATE records SET deleted_at = NOW() WHERE id = ? AND user_id = ? AND deleted_at IS NULL");
return $stmt->execute([$id, $userId]);
}
public function restore($id, $userId) {
$stmt = $this->db->prepare("UPDATE records SET deleted_at = NULL WHERE id = ? AND user_id = ? AND deleted_at IS NOT NULL");
return $stmt->execute([$id, $userId]);
}
public function forceDelete($id) {
$stmt = $this->db->prepare("DELETE FROM records WHERE id = ?");
return $stmt->execute([$id]);
}
}
?>
ON DELETE RESTRICT 防止刪除被引用資料<button type="button"> 而非 <a>,語意正確且可攜帶 data-* 屬性