萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> PHP 程式設計

PHP 刪除資料記錄完整實作:確認提示、AJAX 非同步、軟刪除模式

前言

刪除資料是高風險操作,必須包含確認機制、權限驗證、稽核軌跡。本文涵蓋:前端確認對話框、AJAX 非同步刪除、後端 PDO 實作、軟刪除模式、CSRF 保護與權限控制。

前端:三種確認提示方式

1. 內建 confirm() (最簡單)

<a href="delete.php?id=123" 
   onclick="return confirm('確定要刪除這筆記錄嗎?此操作無法復原!')"
>刪除</a>

2. 自訂 Modal 彈窗 (Bootstrap 5 範例)

<!-- 觸發按鈕 -->
<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>

3. SweetAlert2 美化確認框

<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>

後端:PDO 安全刪除實作 (delete_api.php)

<?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]);
    }
}
?>

資料庫層面防護

  1. 外鍵約束:ON DELETE RESTRICT 防止刪除被引用資料
  2. 觸發器稽核:資料庫層面記錄所有刪除操作
  3. 權限分離:應用帳號無 DROP/TRUNCATE 權限,僅有 DML
  4. 備份策略:定時完整備份 + Binlog 增量備份,支援時間點恢復

前端整合最佳實踐

  • 刪除按鈕使用 <button type="button"> 而非 <a>,語意正確且可攜帶 data-* 屬性
  • 載入狀態:按鈕點擊後 disabled + 顯示 spinner,防止重複提交
  • 成功後:移除對應 DOM 元素 (列表頁) 或導向列表頁 (詳情頁)
  • 失敗時:顯示具體錯誤訊息,提供重試選項
copyright © 萬盛學電腦網 all rights reserved