Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache/2

System:

Linux 5.15.0-161-generic

PHP Version:

8.1.32

User:

myvacationholi

Directory:

/home/myvacationholi/public_html/admin

Free Space:

14.02 GB

🔧 Quick Actions

✏️ Editing: edit_package.php

<?php
include 'config.php';
include 'header.php';
include 'sidebar.php';

// Function to create a URL-friendly slug
function createSlug($string) {
    $slug = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $string), '-'));
    return $slug;
}

// Fetch package details
if (isset($_GET['id'])) {
    $id = intval($_GET['id']);

$query = "SELECT * FROM tour_package WHERE id = ?";
    $stmt = $conn->prepare($query);
    $stmt->bind_param('i', $id);
    $stmt->execute();
    $result = $stmt->get_result();

if ($result->num_rows > 0) {
        $package = $result->fetch_assoc();
        
        // Parse existing itinerary to extract day data
        $itinerary_days = [];
        $full_details = $package['full_details'];
        
        // Use regex to extract day titles and descriptions
        $pattern = '/<h6>(Day \d+:.*?)<\/h6>\s*<p>(.*?)<\/p>/s';
        preg_match_all($pattern, $full_details, $matches, PREG_SET_ORDER);
        
        foreach ($matches as $match) {
            $itinerary_days[] = [
                'title' => str_replace('Day ' . (count($itinerary_days) + 1) . ': ', '', $match[1]),
                'description' => $match[2]
            ];
        }
        
        // If no matches found, try alternative pattern
        if (empty($itinerary_days)) {
            $pattern = '/<h6>(.*?)<\/h6>\s*<p>(.*?)<\/p>/s';
            preg_match_all($pattern, $full_details, $matches, PREG_SET_ORDER);
            
            foreach ($matches as $match) {
                $itinerary_days[] = [
                    'title' => $match[1],
                    'description' => $match[2]
                ];
            }
        }
    } else {
        echo "<script>alert('Package not found!'); window.location.href='index.php';</script>";
        exit;
    }
} else {
    echo "<script>alert('Invalid request!'); window.location.href='index.php';</script>";
    exit;
}

// Update package details
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Collect POST data
    $package_name     = $_POST['package_name'] ?? '';
    $tour_destination = $_POST['tour_destination'] ?? '';
    $tour_price       = $_POST['tour_price'] ?? '';
    $tour_duration    = $_POST['tour_duration'] ?? '';
    $description       = $_POST['description'] ?? '';
    $inclusions       = $_POST['inclusions'] ?? '';
    $exclusions       = $_POST['exclusions'] ?? '';
    $weekend_trip = isset($_POST['weekend_trip']) ? 1 : 0;
    $fixed_departure = isset($_POST['fixed_departure']) ? 1 : 0; // New checkbox value

$slug             = createSlug($package_name); // Generate slug

// Build itinerary HTML from form data
    $full_details = '';
    if (isset($_POST['day_title']) && isset($_POST['day_description'])) {
        $day_titles = $_POST['day_title'];
        $day_descriptions = $_POST['day_description'];
        
        for ($i = 0; $i < count($day_titles); $i++) {
            $title = htmlspecialchars($day_titles[$i]);
            $description = htmlspecialchars($day_descriptions[$i]);
            $full_details .= "<h6>Day " . ($i+1) . ": " . $title . "</h6>";
            $full_details .= "<p>" . $description . "</p>";
        }
    }

// Image handling
    $targetDir = "image-of-tours/galleryimg/";
    $tour_image = $package['image']; // Default: keep existing image

if (!empty($_FILES['tour_image']['name'])) {
        $tour_image = basename($_FILES['tour_image']['name']);
        $tour_image_path = $targetDir . $tour_image;
        move_uploaded_file($_FILES['tour_image']['tmp_name'], $tour_image_path);
    }

// Prepare the update query - updated to include fixed_departure
    $updateQuery = "UPDATE tour_package 
    SET package_name = ?, 
        tour_destination = ?, 
        tour_price = ?, 
        tour_duration = ?, 
        description = ?, 
        full_details = ?, 
        inclusions = ?, 
        exclusions = ?, 
        image = ?, 
        url = ?, 
        weekend_trip = ?,
        fixed_departure = ?
    WHERE id = ?";

$updateStmt = $conn->prepare($updateQuery);

// Fix: Correct order & correct type string (10 strings + 3 integers)
    $updateStmt->bind_param(
        'ssssssssssiii',
        $package_name,
        $tour_destination,
        $tour_price,
        $tour_duration,
        $description,
        $full_details,
        $inclusions,
        $exclusions,
        $tour_image,
        $slug,
        $weekend_trip,
        $fixed_departure,
        $id
    );

if ($updateStmt->execute()) {
        echo "<script>alert('Package updated successfully!'); window.location.href='all-tours.php';</script>";
    } else {
        echo "<script>alert('Error updating package. Please try again.');</script>";
    }
}
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Edit Tour Package</title>
    
    <link href="https://fonts.googleapis.com/css?family=Ubuntu:400,500,700" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="assets/icon/themify-icons/themify-icons.css">

<link rel="stylesheet" type="text/css" href="assets/icon/icofont/css/icofont.css">

<link rel="stylesheet" type="text/css" href="assets/icon/simple-line-icons/css/simple-line-icons.css">

<link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap/css/bootstrap.min.css">

<link rel="stylesheet" type="text/css" href="assets/css/main.css">

<link rel="stylesheet" type="text/css" href="assets/css/responsive.css">

<script src="https://cdn.ckeditor.com/4.16.2/standard/ckeditor.js"></script>
    
    <style>
        .itinerary-day {
            border: 1px solid #ddd;
            border-radius: 5px;
            padding: 15px;
            margin-bottom: 15px;
            position: relative;
        }
        .day-header {
            display: flex;
            justify-content: space-between;
            align-items: center;
            margin-bottom: 10px;
            border-bottom: 1px solid #eee;
            padding-bottom: 10px;
        }
        .day-number {
            background-color: #FF5F5F;
            color: white;
            width: 30px;
            height: 30px;
            border-radius: 5px;
            display: flex;
            justify-content: center;
            align-items: center;
            font-weight: bold;
        }
        .remove-day {
            position: absolute;
            top: 10px;
            right: 10px;
            background: none;
            border: none;
            color: #dc3545;
            font-size: 18px;
            cursor: pointer;
        }
        .itinerary-container {
            margin-bottom: 20px;
        }
        .faq-page__accordion {
            margin-bottom: 20px;
        }
        .includes-list li {
            padding: 8px 0;
            border-bottom: 1px dashed #eee;
            font-size: 14px;
            line-height: 1.5;
        }
        .includes-list li:last-child {
            border-bottom: none;
        }
        .includes-list i {
            font-size: 16px;
            width: 20px;
            text-align: center;
        }
        /* CKEditor adjustments */
        .cke_chrome {
            border: 1px solid #ced4da !important;
            border-radius: 0.25rem !important;
        }
        .cke_top {
            background: #f8f9fa !important;
            border-bottom: 1px solid #ced4da !important;
        }
        /* Checkbox styling */
        .form-check {
            display: flex;
            align-items: center;
            margin-bottom: 0.5rem;
        }
        .form-check-input {
            margin-right: 0.5rem;
        }
        .checkbox-group {
            display: flex;
            gap: 2rem;
            margin-bottom: 1rem;
        }
        .checkbox-item {
            flex: 1;
        }
    </style>
</head>

<div class="content-wrapper">
            <div class="container-fluid">
                <div class="row">
                    <div class="main-header">
                        <h4>Edit Tour Package</h4>
                    </div>
                </div>

<div class="row">
                    <div class="col-sm-12">
                        <div class="card">
                            <div class="card-header">
                                <h5>Update Package Details</h5>
                            </div>
                            <div class="card-block">
                                <form method="POST" enctype="multipart/form-data" id="tourForm">
                                    
                                    <div class="form-group">
                                        <label for="package_name">Package Name</label>
                                        <input type="text" class="form-control" id="package_name" name="package_name" value="<?php echo htmlspecialchars($package['package_name']); ?>" required>
                                    </div>
                                    
                                    
                                    <div class="checkbox-group">
                                        
                                        <div class="checkbox-item">
                                            <div class="form-check">
                                                <input 
                                                    class="form-check-input" 
                                                    type="checkbox" 
                                                    id="weekend_trip" 
                                                    name="weekend_trip" 
                                                    value="1" 
                                                    <?php echo ($package['weekend_trip'] == 1) ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="weekend_trip">Weekend Trip</label>
                                            </div>
                                            <small class="form-text text-muted">Check if this package is a weekend trip.</small>
                                        </div>
                                        
                                        
                                        <div class="checkbox-item">
                                            <div class="form-check">
                                                <input 
                                                    class="form-check-input" 
                                                    type="checkbox" 
                                                    id="fixed_departure" 
                                                    name="fixed_departure" 
                                                    value="1" 
                                                    <?php echo (isset($package['fixed_departure']) && $package['fixed_departure'] == 1) ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="fixed_departure">Fixed Departure</label>
                                            </div>
                                            <small class="form-text text-muted">Check if this package has fixed departure dates.</small>
                                        </div>
                                    </div>

<div class="form-group">
                                        <label for="tour_destination">Destination</label>
                                        <input type="text" class="form-control" id="tour_destination" name="tour_destination" value="<?php echo htmlspecialchars($package['tour_destination']); ?>" required>
                                    </div>

<div class="form-group">
                                        <label for="tour_price">Price</label>
                                        <input type="text" class="form-control" id="tour_price" name="tour_price" value="<?php echo htmlspecialchars($package['tour_price']); ?>" required>
                                    </div>

<div class="form-group">
                                        <label for="tour_duration">Duration</label>
                                        <input type="text" class="form-control" id="tour_duration" name="tour_duration" value="<?php echo htmlspecialchars($package['tour_duration']); ?>" required>
                                    </div>
                                    
                                    <div class="form-group">
                                         <label>Description</label>
                                         <textarea class="form-control" id="mydescription" name="description" rows="3" ><?php echo htmlspecialchars($package['description']); ?> </textarea>
                                     </div>

<div class="form-group">
                                        <label>Itinerary</label>
                                        <div class="itinerary-container" id="itinerary-container">
                                            <?php if (!empty($itinerary_days)): ?>
                                                <?php foreach ($itinerary_days as $index => $day): ?>
                                                    <div class="itinerary-day">
                                                        <div class="day-header">
                                                            <div class="day-number"><?php echo $index + 1; ?></div>
                                                            <h5>Day <?php echo $index + 1; ?></h5>
                                                            <button type="button" class="remove-day" onclick="removeDay(this)">×</button>
                                                        </div>
                                                        <div class="form-group">
                                                            <label>Title</label>
                                                            <input type="text" class="form-control day-title" name="day_title[]" value="<?php echo htmlspecialchars($day['title']); ?>" >
                                                        </div>
                                                        <div class="form-group">
                                                            <label>Description</label>
                                                            <textarea class="form-control day-description" name="day_description[]" rows="3" ><?php echo htmlspecialchars($day['description']); ?></textarea>
                                                        </div>
                                                    </div>
                                                <?php endforeach; ?>
                                            <?php else: ?>
                                                
                                                <div class="itinerary-day">
                                                    <div class="day-header">
                                                        <div class="day-number">1</div>
                                                        <h5>Day 1</h5>
                                                        <button type="button" class="remove-day" onclick="removeDay(this)">×</button>
                                                    </div>
                                                    <div class="form-group">
                                                        <label>Title</label>
                                                        <input type="text" class="form-control day-title" name="day_title[]" >
                                                    </div>
                                                    <div class="form-group">
                                                        <label>Description</label>
                                                        <textarea class="form-control day-description" name="day_description[]" rows="3" ></textarea>
                                                    </div>
                                                </div>
                                            <?php endif; ?>
                                        </div>
                                        <button type="button" id="add-day" class="btn btn-primary">Add Day</button>
                                    </div>

<div class="form-group">
                                        <label>Inclusions</label>
                                        <div class="faq-page__accordion faq-accordion gotur-accordion p-0 p-md-4" data-grp-name="gotur-accordion">
                                            <div class="accordion wow fadeInUp px-4 py-3 rounded" style="box-shadow: rgb(28 137 177) 0px 1px 3px, rgb(28 137 177) 0px 1px 2px; color: black; animation: none;">
                                                <textarea class="form-control" id="inclusions" name="inclusions" rows="5"  placeholder="Enter inclusions (one per line)"><?php echo htmlspecialchars($package['inclusions']); ?></textarea>
                                                <small class="form-text text-muted">Enter each inclusion on a new line</small>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    
                                    <div class="form-group">
                                        <label>Exclusions</label>
                                        <div class="faq-page__accordion faq-accordion gotur-accordion p-0 p-md-4" data-grp-name="gotur-accordion">
                                            <div class="accordion wow fadeInUp px-4 py-3 rounded" style="box-shadow: rgb(28 137 177) 0px 1px 3px, rgb(28 137 177) 0px 1px 2px; color: black; animation: none;">
                                                <textarea class="form-control" id="exclusions" name="exclusions" rows="5"  placeholder="Enter exclusions (one per line)"><?php echo htmlspecialchars($package['exclusions']); ?></textarea>
                                                <small class="form-text text-muted">Enter each exclusion on a new line</small>
                                            </div>
                                        </div>
                                    </div>

<div class="form-group">
                                        <label for="tour_image">Tour Image</label>
                                        <input type="file" class="form-control" id="tour_image" name="tour_image">
                                        <?php if (!empty($package['image'])): ?>
                                            <small>Current Image: <a href="image-of-tours/galleryimg/<?php echo htmlspecialchars($package['image']); ?>" target="_blank">View</a></small>
                                        <?php endif; ?>
                                    </div>

<button type="submit" class="btn btn-success">Update Package</button>
                                    <a href="dashboard.php" class="btn btn-secondary">Cancel</a>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

<script src="assets/plugins/Jquery/dist/jquery.min.js"></script>
    <script src="assets/plugins/jquery-ui/jquery-ui.min.js"></script>
    <script src="assets/plugins/tether/dist/js/tether.min.js"></script>

<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>

<script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.js"></script>
    <script src="assets/plugins/jquery.nicescroll/jquery.nicescroll.min.js"></script>

<script src="assets/plugins/classie/classie.js"></script>

<script src="assets/plugins/notification/js/bootstrap-growl.min.js"></script>

<script type="text/javascript" src="assets/js/main.min.js"></script>
    <script type="text/javascript" src="assets/pages/dashboard.js"></script>
    <script type="text/javascript" src="assets/pages/elements.js"></script>
    <script src="assets/js/menu.min.js"></script>

<script>
        // Initialize CKEditor for inclusions
        CKEDITOR.replace('exclusions', {
            height: 150,
            toolbar: [
                { name: 'basicstyles', items: [ 'Bold', 'Italic', 'Underline', 'Strike', 'Subscript', 'Superscript', '-', 'CopyFormatting', 'RemoveFormat' ] },
                { name: 'paragraph', items: [ 'NumberedList', 'BulletedList', '-', 'Outdent', 'Indent', '-', 'Blockquote', '-', 'JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyBlock' ] },
                { name: 'links', items: [ 'Link', 'Unlink', 'Anchor' ] },
                { name: 'insert', items: [ 'Image', 'Table', 'HorizontalRule', 'SpecialChar' ] },
                { name: 'styles', items: [ 'Styles', 'Format', 'Font', 'FontSize' ] },
                { name: 'colors', items: [ 'TextColor', 'BGColor' ] },
                { name: 'tools', items: [ 'Maximize', 'ShowBlocks' ] }
            ]
        });
        
        CKEDITOR.replace('inclusions', {
            height: 150,
            toolbar: [
                { name: 'basicstyles', items: [ 'Bold', 'Italic', 'Underline', 'Strike', 'Subscript', 'Superscript', '-', 'CopyFormatting', 'RemoveFormat' ] },
                { name: 'paragraph', items: [ 'NumberedList', 'BulletedList', '-', 'Outdent', 'Indent', '-', 'Blockquote', '-', 'JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyBlock' ] },
                { name: 'links', items: [ 'Link', 'Unlink', 'Anchor' ] },
                { name: 'insert', items: [ 'Image', 'Table', 'HorizontalRule', 'SpecialChar' ] },
                { name: 'styles', items: [ 'Styles', 'Format', 'Font', 'FontSize' ] },
                { name: 'colors', items: [ 'TextColor', 'BGColor' ] },
                { name: 'tools', items: [ 'Maximize', 'ShowBlocks' ] }
            ]
        });
        
        CKEDITOR.replace('mydescription', {
            height: 150,
            toolbar: [
                { name: 'basicstyles', items: [ 'Bold', 'Italic', 'Underline', 'Strike', 'Subscript', 'Superscript', '-', 'CopyFormatting', 'RemoveFormat' ] },
                { name: 'paragraph', items: [ 'NumberedList', 'BulletedList', '-', 'Outdent', 'Indent', '-', 'Blockquote', '-', 'JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyBlock' ] },
                { name: 'links', items: [ 'Link', 'Unlink', 'Anchor' ] },
                { name: 'insert', items: [ 'Image', 'Table', 'HorizontalRule', 'SpecialChar' ] },
                { name: 'styles', items: [ 'Styles', 'Format', 'Font', 'FontSize' ] },
                { name: 'colors', items: [ 'TextColor', 'BGColor' ] },
                { name: 'tools', items: [ 'Maximize', 'ShowBlocks' ] }
            ]
        });

// Add day functionality
        document.getElementById('add-day').addEventListener('click', function() {
            const container = document.getElementById('itinerary-container');
            const dayCount = container.children.length + 1;
            
            const dayElement = document.createElement('div');
            dayElement.className = 'itinerary-day';
            dayElement.innerHTML = `
                <div class="day-header">
                    <div class="day-number">${dayCount}</div>
                    <h5>Day ${dayCount}</h5>
                    <button type="button" class="remove-day" onclick="removeDay(this)">×</button>
                </div>
                <div class="form-group">
                    <label>Title</label>
                    <input type="text" class="form-control day-title" name="day_title[]" required>
                </div>
                <div class="form-group">
                    <label>Description</label>
                    <textarea class="form-control day-description" name="day_description[]" rows="3" required></textarea>
                </div>
            `;
            
            container.appendChild(dayElement);
            
            // Initialize CKEditor for the new day description
            const newTextarea = dayElement.querySelector('.day-description');
            CKEDITOR.replace(newTextarea, {
                height: 150,
                toolbar: [
                    { name: 'basicstyles', items: [ 'Bold', 'Italic', 'Underline', 'Strike', 'Subscript', 'Superscript', '-', 'CopyFormatting', 'RemoveFormat' ] },
                    { name: 'paragraph', items: [ 'NumberedList', 'BulletedList', '-', 'Outdent', 'Indent', '-', 'Blockquote', '-', 'JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyBlock' ] },
                    { name: 'links', items: [ 'Link', 'Unlink', 'Anchor' ] },
                    { name: 'insert', items: [ 'Image', 'Table', 'HorizontalRule', 'SpecialChar' ] },
                    { name: 'styles', items: [ 'Styles', 'Format', 'Font', 'FontSize' ] },
                    { name: 'colors', items: [ 'TextColor', 'BGColor' ] },
                    { name: 'tools', items: [ 'Maximize', 'ShowBlocks' ] }
                ]
            });
        });
        
        // Remove day functionality
        function removeDay(button) {
            const dayElement = button.closest('.itinerary-day');
            const textarea = dayElement.querySelector('.day-description');
            
            // Destroy CKEditor instance before removing the element
            const editorInstance = CKEDITOR.instances[textarea.id];
            if (editorInstance) {
                editorInstance.destroy();
            }
            
            dayElement.remove();
            updateDayNumbers();
        }
        
        // Update day numbers after removal
        function updateDayNumbers() {
            const container = document.getElementById('itinerary-container');
            const days = container.querySelectorAll('.itinerary-day');
            
            days.forEach((day, index) => {
                const dayNumber = day.querySelector('.day-number');
                const dayTitle = day.querySelector('h5');
                const dayNum = index + 1;
                
                dayNumber.textContent = dayNum;
                dayTitle.textContent = `Day ${dayNum}`;
            });
        }
        
        // Form submission validation
        document.getElementById('tourForm').addEventListener('submit', function(event) {
            const dayTitles = document.querySelectorAll('input[name="day_title[]"]');
            
            if (dayTitles.length === 0) {
                event.preventDefault();
                alert('Please add at least one day to the itinerary.');
            }
            
            // Update all CKEditor instances before form submission
            for (instance in CKEDITOR.instances) {
                CKEDITOR.instances[instance].updateElement();
            }
        });
    </script>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit_package.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation