<?php
include("connection.php");

if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['order'])) {
    $orderData = $_POST['order'];

    foreach ($orderData as $item) {
        $id = intval($item['id']);
        $priority = intval($item['priority']);

        // Simple update query
        $query = "UPDATE project SET priority = '$priority' WHERE id = '$id'";
        $result = mysqli_query($con, $query);

        if (!$result) {
            echo "Error updating record: " . mysqli_error($con);
        }
    }

    echo "Priority updated successfully.";
} else {
    echo "Invalid request.";
}
?>