❌ Uploaded file is not an image.";
} elseif (!in_array($imageFileType, ["jpg", "jpeg", "png", "gif", "webp", "svg"])) {
echo "
❌ Only JPG, JPEG, PNG, GIF, WEBP, and SVG are allowed.
"; } elseif (!move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) { echo "❌ Error uploading image.
"; } else { // Sanitize inputs $title = mysqli_real_escape_string($conn, $_POST['title']); $description = mysqli_real_escape_string($conn, $_POST['description']); $duration = mysqli_real_escape_string($conn, $_POST['duration']); $persons = mysqli_real_escape_string($conn, $_POST['persons']); $places_covered = mysqli_real_escape_string($conn, $_POST['places_covered']); // Itineraries $itinerary = []; for ($i = 1; $i <= 17; $i++) { $heading = mysqli_real_escape_string($conn, $_POST["itinery_heading_$i"] ?? ''); $desc = mysqli_real_escape_string($conn, $_POST["itinery_description_$i"] ?? ''); $itinerary["itinery_heading_$i"] = $heading; $itinerary["itinery_description_$i"] = $desc; } // Highlights $highlights = []; for ($i = 1; $i <= 5; $i++) { $highlight = mysqli_real_escape_string($conn, $_POST["highlight_$i"] ?? ''); $highlights["highlight_$i"] = $highlight; } // Prepare the INSERT query $columns = "title, image, description, duration, persons, places_covered"; $values = "'$title', '$target_file', '$description', '$duration', '$persons', '$places_covered'"; foreach ($itinerary as $key => $val) { $columns .= ", $key"; $values .= ", '$val'"; } foreach ($highlights as $key => $val) { $columns .= ", $key"; $values .= ", '$val'"; } $query = "INSERT INTO pilgrimage_package ($columns) VALUES ($values)"; if (mysqli_query($conn, $query)) { echo "✅ Record inserted successfully.
"; } else { echo "❌ Error: " . mysqli_error($conn) . "
"; } } } ?>Existing Packages
| ID | Image | Title | Duration | Persons | Places Covered | Itinerary | Highlights |
|---|---|---|---|---|---|---|---|
|
|
|
|