File "delete_harvest.php"

Full Path: /home/leadltht/fastlinkinternet.com/administrator/data-provider/admin/delete_harvest.php
File size: 664 bytes
MIME-type: text/x-php
Charset: utf-8

<?php
// Database connection
$conn = new mysqli("server329", "leadltht_prazey1982", "prazey1982123456", "leadltht_fastlinkinternet");
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if (isset($_GET['id'])) {
    $id = $_GET['id'];
    $query = "DELETE FROM harvest_collection WHERE id = ?";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("i", $id);

    if ($stmt->execute()) {
        $message = "Harvest record deleted successfully.";
    } else {
        $message = "Error: " . $stmt->error;
    }

    $stmt->close();
}

$conn->close();
header("Location: view_harvests.php");
exit();
?>