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/domains/myvacationholidays.in/private_html/admin

Free Space:

14.02 GB

🔧 Quick Actions

✏️ Editing: add_tour.php

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

$query = "SELECT id, category AS name FROM tour_category";
 $result = $conn->query($query);

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Collect POST data
    $tour_type   = $_POST['tour_type'] ?? '';
    $package_name    = $_POST['package_name'] ?? '';
    $location        = $_POST['tour_destination'] ?? '';
    $price           = $_POST['tour_price'] ?? '';
    $days            = $_POST['tour_duration'] ?? '';
    $description           = $_POST['description'] ?? '';
    $inclusion       = $_POST['inclusions'] ?? '';
    $exclusion       = $_POST['exclusions'] ?? '';
    $weekend_trip = isset($_POST['weekend_trip']) ? 1 : 0;
    $fixed_departure = isset($_POST['fixed_departure']) ? 1 : 0; // New checkbox value

// Create URL slug from package name
    $url = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $package_name), '-'));

// Handle image upload
    $targetDir = "image-of-tours/galleryimg/";
    $tour_image_path = '';

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);
    }

// Build itinerary HTML from form data
    $tour_plan = '';
    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]);
            $tour_plan .= "<h6>Day " . ($i+1) . ": " . $title . "</h6>";
            $tour_plan .= "<p>" . $description . "</p>";
        }
    }

// Insert query - updated to include fixed_departure
    $insertQuery = "INSERT INTO tour_package (tour_type, package_name, tour_destination, tour_price, tour_duration, description, full_details, inclusions, exclusions, image, url, weekend_trip, fixed_departure) 
                    VALUES (?, ?, ?, ?, ?,?, ?, ?,?,?, ?, ?, ?)";
    $stmt = $conn->prepare($insertQuery);
    $stmt->bind_param(
        'isssssssssiii',
        $tour_type,
        $package_name,
        $location,
        $price,
        $days,
        $description,
        $tour_plan,
        $inclusion,
        $exclusion,
        $tour_image,
        $url,
        $weekend_trip,
        $fixed_departure
    );

if ($stmt->execute()) {
        echo "<script>alert('Tour package added successfully!'); window.location.href='all-tours.php';</script>";
    } else {
        echo "<script>alert('Error adding tour 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>Add 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/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>Add Tour Package</h4>
                    </div>
                </div>

<div class="row">
                    <div class="col-sm-12">
                        <div class="card">
                            <div class="card-header">
                                <h5>New Tour Package</h5>
                            </div>
                            <div class="card-block">
                                <form method="POST" action="" enctype="multipart/form-data" id="tourForm">
                                    
                                    <div class="form-group">
                                        <label for="tour_type">Tour Category</label>
                                        <select class="form-control" id="tour_type" name="tour_type" required>
                                            <?php while ($row = $result->fetch_assoc()) { ?>
                                                <option value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                            <?php } ?>
                                        </select>
                                    </div>

<div class="form-group">
                                        <label for="package_name">Package Name</label>
                                        <input type="text" class="form-control" id="package_name" name="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">
                                                <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">
                                                <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">Location</label>
                                        <input type="text" class="form-control" id="tour_destination" name="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" required>
                                    </div>

<div class="form-group">
                                        <label for="tour_duration">Duration</label>
                                        <input type="text" class="form-control" id="tour_duration" name="tour_duration" required>
                                    </div>
                                    <div class="form-group">
                                        <label>Description</label>
                                        <textarea class="form-control day-description" id="mydescription" name="description" rows="3" required></textarea>
                                    </div>

<div class="form-group">
                                        <label>Itinerary</label>
                                        <div class="itinerary-container" id="itinerary-container">
                                            
                                            <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[]" required>
                                                </div>
                                                <div class="form-group">
                                                    <label>Description</label>
                                                    <textarea class="form-control day-description" name="day_description[]" rows="3" required></textarea>
                                                </div>
                                            </div>
                                        </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" required placeholder="Enter inclusions (one per line)"></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" required placeholder="Enter exclusions (one per line)"></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" required>
                                    </div>

<button type="submit" class="btn btn-success">Add Package</button>
                                    <a href="index.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 type="text/javascript" src="assets/js/main.min.js"></script>
    <script type="text/javascript" src="assets/pages/dashboard.js"></script>
    <script src="assets/js/menu.min.js"></script>

<script type="text/javascript">
        // Initialize CKEditor for inclusions
        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('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('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' ] }
            ]
        });

// Initialize CKEditor for initial day description
        CKEDITOR.replace($('.day-description')[0], {
            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: add_tour.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation