Order must be a valid integer.";
exit();
}
// Prepare the SQL statement
$stmt = $conn->prepare("INSERT INTO menus (parent_id, name, link, `order`) VALUES (?, ?, ?, ?)");
$stmt->bind_param("issi", $parent_id, $name, $link, $order); // "i" for integer, "s" for string
// Execute the query and handle the result
if ($stmt->execute()) {
// Redirect to the view_menu page after successful insertion
header("Location:view_menu.php");
exit(); // Stop further execution of the script
} else {
echo "
Error adding menu item: " . $stmt->error . "
";
}
// Close the prepared statement
$stmt->close();
} else {
echo "