0xn0l

📂 /home/brightbrai/public_html/income/api

✎ EDIT: delete_transaction.php ← BACK

<?php
// Include the database connection file
require_once 'db.php';

// Get the JSON data from the request body
$data = json_decode(file_get_contents('php://input'), true);

// Basic validation
if (empty($data['id'])) {
    http_response_code(400); // Bad Request
    echo json_encode(['error' => 'Transaction ID is required.']);
    exit;
}

$id = (int) $data['id'];

try {
    // Use a prepared statement to prevent SQL injection
    $sql = "DELETE FROM transactions WHERE id = :id";
    $stmt = $pdo->prepare($sql);
    
    // Bind the ID parameter
    $stmt->bindParam(':id', $id, PDO::PARAM_INT);
    
    // Execute the statement
    if ($stmt->execute()) {
        // Check if any row was actually deleted
        if ($stmt->rowCount() > 0) {
            echo json_encode(['success' => true, 'message' => 'Transaction deleted successfully.']);
        } else {
            // No row was deleted, likely because the ID was not found
            http_response_code(404); // Not Found
            echo json_encode(['error' => 'Transaction not found.']);
        }
    } else {
        throw new Exception("Statement execution failed.");
    }
    
} catch (\PDOException $e) {
    http_response_code(500);
    echo json_encode(['error' => 'Failed to delete transaction: ' . $e->getMessage()]);
}
?>

0xn0l - 0011000001111000011011100011000001101100