Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u184721437

Directory:

/home/u184721437/domains/bago-holdings.com/public_html/admin

Free Space:

7.12 TB

🔧 Quick Actions

✏️ Editing: solutions.php

<?php
include('function.php');
include('header.php');

if (isset($_POST['submit'])) {
    include('../dbcon.php');
    
    // Collecting data from POST request
    $submenu = $_POST['submenu'];
    $title = $_POST['title'];
    $subtitle1 = $_POST['subtitle1'];
    $insurence = $_POST['insurence'];
    $features = $_POST['features'];
    $page_title = $_POST['page_title'];
    $description = $_POST['description'];
    $keywords = $_POST['keywords'];
    $robots = $_POST['robots'];
    $canonical = $_POST['canonical'];

$aboutimagename = $_FILES['aboutimage']['name'];
    $tempname = $_FILES['aboutimage']['tmp_name'];

$titleslug = slug($title);

// Begin transaction
    mysqli_begin_transaction($conn);

try {
        // Insert main solution data
        $qry = "INSERT INTO `solution` (`title`, `submenu`, `titleslug`, `page_title`, `description`, `keywords`, `robots`, `canonical`, `subtitle1`, `insurence`, `features`, `image`) 
                VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        $stmt = mysqli_prepare($conn, $qry);
        
        if ($stmt) {
            mysqli_stmt_bind_param($stmt, "ssssssssssss", $title, $submenu, $titleslug, $page_title, $description, $keywords, $robots, $canonical, $subtitle1, $insurence, $features, $aboutimagename);

// Upload the image
            if (move_uploaded_file($tempname, './dataimg/' . $aboutimagename)) {
                $run = mysqli_stmt_execute($stmt);

if ($run) {
                    // Get the inserted project ID
                    $project_id = mysqli_insert_id($conn);

// Insert service entry images with texts
                    if (isset($_FILES['serviceentryimage']) && !empty($_FILES['serviceentryimage']['tmp_name'])) {
                        // Prepare the SQL query for inserting images with their respective texts
                        $qry = "INSERT INTO `service_entry_images` (`service_content_id`, `image_path`, `image_text`, `created_at`) VALUES (?, ?, ?, ?)";
                        $stmt = mysqli_prepare($conn, $qry);
                    
                        if ($stmt) {
                            // Loop through each uploaded image
                            foreach ($_FILES['serviceentryimage']['tmp_name'] as $key => $tempname) {
                                if (is_uploaded_file($tempname)) {
                                    // Generate a unique image name
                                    $imageName = uniqid() . "_" . basename($_FILES['serviceentryimage']['name'][$key]);
                                    $targetFile = "./dataimg/" . $imageName;  // Image upload path
                    
                                    // Move the uploaded file
                                    if (move_uploaded_file($tempname, $targetFile)) {
                                        // Handle associated image text
                                        $imageTexts = isset($_POST['image_text'][$key]) ? $_POST['image_text'][$key] : [];
                    
                                        // Insert image-text pairs
                                        foreach ($imageTexts as $text) {
                                            $imageText = $text ?: ""; // Default to empty string if text is empty
                                            $createdAt = date('Y-m-d H:i:s'); // Current timestamp
                    
                                            // Bind parameters for the image-text insert
                                            mysqli_stmt_bind_param($stmt, "ssss", $project_id, $imageName, $imageText, $createdAt);
                    
                                            // Execute the statement
                                            if (!mysqli_stmt_execute($stmt)) {
                                                error_log("MySQL Error: " . mysqli_stmt_error($stmt));
                                            }
                                        }
                                    } else {
                                        error_log("Failed to upload image: " . $_FILES['serviceentryimage']['name'][$key]);
                                    }
                                }
                            }
                    
                            // Close the statement
                            mysqli_stmt_close($stmt);
                        } else {
                            error_log("Prepared statement error: " . mysqli_error($conn));
                        }
                    }

// Insert features with images into 'service_features'
                    if (isset($_FILES['image']) && !empty($_FILES['image']['tmp_name'])) {
                        $qry = "INSERT INTO `service_features` (`service_content_id`, `image`, `features_list`, `created_at`) VALUES (?, ?, ?, ?)";
                        $stmt = mysqli_prepare($conn, $qry);

if ($stmt) {
                            // Loop through each uploaded image
                            foreach ($_FILES['image']['tmp_name'] as $key => $tempname) {
                                if (is_uploaded_file($tempname)) {
                                    // Generate a unique image name
                                    $imageName = uniqid() . "_" . basename($_FILES['image']['name'][$key]);
                                    $targetFile = "./dataimg/" . $imageName;  // Upload path

// Move the uploaded file
                                    if (move_uploaded_file($tempname, $targetFile)) {
                                        // Check if features_list is set
                                        if (isset($_POST['features_list'][$key])) {
                                            $featuresList = $_POST['features_list'][$key];
                                            $createdAt = date('Y-m-d H:i:s'); // Current timestamp

// Insert feature-text pairs
                                            foreach ($featuresList as $text) {
                                                $featureText = $text ?: ""; // Default to empty string if text is empty

// Bind parameters for the feature insert
                                                mysqli_stmt_bind_param($stmt, "isss", $project_id, $imageName, $featureText, $createdAt);

// Execute the statement
                                                if (!mysqli_stmt_execute($stmt)) {
                                                    error_log("MySQL Error: " . mysqli_stmt_error($stmt));
                                                }
                                            }
                                        }
                                    } else {
                                        error_log("Failed to upload feature image: " . $_FILES['image']['name'][$key]);
                                    }
                                }
                            }

// Close the statement
                            mysqli_stmt_close($stmt);
                        } else {
                            error_log("Prepared statement error: " . mysqli_error($conn));
                        }
                    }

// Insert FAQ data if provided
                    if (!empty($_POST['faqs'])) {
                        $qry = "INSERT INTO `service_faqs` (`service_content_id`, `question`, `answer`) VALUES (?, ?, ?)";
                        $stmt = mysqli_prepare($conn, $qry);
                        foreach ($_POST['faqs'] as $faq) {
                            $question = $faq['question'];
                            $answer = $faq['answer'];
                            mysqli_stmt_bind_param($stmt, "iss", $project_id, $question, $answer);
                            mysqli_stmt_execute($stmt);
                        }
                    }

// Insert Insurence Tab data if provided
                    if (!empty($_POST['insurence_tab'])) {
                        $qry = "INSERT INTO `insurence_tab` (`service_content_id`, `question`, `answer`) VALUES (?, ?, ?)";
                        $stmt = mysqli_prepare($conn, $qry);
                        foreach ($_POST['insurence_tab'] as $faq) {
                            $question = $faq['question'];
                            $answer = $faq['answer'];
                            mysqli_stmt_bind_param($stmt, "iss", $project_id, $question, $answer);
                            mysqli_stmt_execute($stmt);
                        }
                    }

// Commit the transaction
                    mysqli_commit($conn);
                    echo '<script>alert("Data and Media Uploaded Successfully");</script>';
                } else {
                    throw new Exception('Main record insert failed.');
                }
            } else {
                throw new Exception('Image upload failed.');
            }
        } else {
            throw new Exception('Prepared statement error: ' . mysqli_error($conn));
        }
    } catch (Exception $e) {
        // Rollback the transaction in case of an error
        mysqli_rollback($conn);
        echo '<script>alert("Error: ' . $e->getMessage() . '");</script>';
    }
}
?>

<div class="container">
    <div class="title">Solution</div>
    <script src="https://cdn.ckeditor.com/4.16.2/standard/ckeditor.js"></script>
    <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="post" enctype="multipart/form-data">
        
        <div class="form-group">
            <label for="title">Title</label>
            <input type="text" class="form-control" name="title" placeholder="Title" required>
        </div>

<div class="form-group">
            <label for="submenu">Sub Menu Name</label>
            <input type="text" class="form-control" name="submenu" placeholder="Sub Menu Name" required>
        </div>

<div class="form-group">
            <label for="page_title">Page Title</label>
            <input type="text" class="form-control" name="page_title" placeholder="Page Title" required>
        </div>

<div class="form-group">
            <label for="description">Description</label>
            <textarea class="form-control" name="description" placeholder="Description" required></textarea>
        </div>

<div class="form-group">
            <label for="keywords">Keywords</label>
            <input type="text" class="form-control" name="keywords" placeholder="Keywords">
        </div>

<div class="form-group">
            <label for="robots">Robots</label>
            <input type="text" class="form-control" name="robots" placeholder="Robots">
        </div>

<div class="form-group">
            <label for="canonical">Canonical</label>
            <input type="text" class="form-control" name="canonical" placeholder="Canonical">
        </div>

<div class="form-group">
            <label for="subtitle1">Content</label>
            <textarea id="subtitle1" name="subtitle1"></textarea>
        </div>

<div class="form-group">
            <label for="insurence">Insurance Policy</label>
            <textarea id="insurence" name="insurence"></textarea>
        </div>

<div class="form-group">
            <label for="insurance-tab">Insurance Tab</label>
            <div id="insurance-tab">
                <div class="field-group">
                    <label for="question-0">Question</label>
                    <input type="text" name="insurence_tab[0][question]" placeholder="Enter question" class="form-control" required>
                    <label for="answer-0">Answer</label>
                    <textarea name="insurence_tab[0][answer]" placeholder="Enter answer" class="form-control" required></textarea>
                    <button type="button" class="btn btn-danger" onclick="deleteField(this)">Delete</button>
                </div>
            </div>
            <button type="button" class="btn btn-success" onclick="addInsuranceField()">Add More Insurance Tabs</button>
        </div>

<div class="form-group">
            <label for="aboutimage">Image</label>
            <input type="file" class="form-control" name="aboutimage" required>
        </div>

<div class="form-group">
    <label for="serviceentryimage">Service Entry Image With Text (Multiple Uploads)</label>
    <div id="service-entry-images">
        <div class="field-group">
            <label>Image:</label>
            <input type="file" class="form-control" name="serviceentryimage[]" required>
            
            <div class="image-texts">
                <label>Image Text (Optional):</label>
                <input type="text" class="form-control" name="image_text[0][]" placeholder="Enter image description">
            </div>

<button type="button" class="btn btn-success btn-sm" onclick="addImageText(this)">Add More Image Text</button>
            <button type="button" class="btn btn-danger" onclick="deleteField(this)">Delete</button>
        </div>
    </div>
    <button type="button" class="btn btn-success" onclick="addField('service-entry-images')">Add More Service Entry Images</button>
</div>

<div class="form-group">
            <label for="features">Features Content</label>
            <textarea id="features" name="features"></textarea>
        </div>

<div class="form-group">
    <label for="featureslist">Features List with Image</label>
    <div id="featureslist">
        <div class="field-group">
            <label>Image:</label>
            <input type="file" class="form-control" name="image[]" required>
            <label>Features List</label>
            <input type="text" class="form-control" name="features_list[0]" placeholder="Enter image description">
            <button type="button" class="btn btn-success btn-sm" onclick="addFeaturesList(this)">Add More Features List</button>
            <button type="button" class="btn btn-danger" onclick="deleteField(this)">Delete</button>
        </div>
    </div>
    <button type="button" class="btn btn-success" onclick="addFieldContainer('featureslist')">Add More Features List</button>
</div>

<div class="form-group">
            <label for="servicefaqs">Service FAQs</label>
            <div id="service-faqs">
                <div class="field-group">
                    <label for="faq-question">Question</label>
                    <input type="text" name="faqs[0][question]" placeholder="Enter question" class="form-control" required>
                    <label for="faq-answer">Answer</label>
                    <textarea name="faqs[0][answer]" placeholder="Enter answer" class="form-control" required></textarea>
                    <button type="button" class="btn btn-danger" onclick="deleteField(this)">Delete</button>
                </div>
            </div>
            <button type="button" class="btn btn-success" onclick="addFaqField()">Add More FAQs</button>
        </div>

<button type="submit" name="submit" class="btn btn-primary">Submit</button>
    </form>
</div>
    <script>
        CKEDITOR.replace('subtitle1');
        CKEDITOR.replace('insurence');
        CKEDITOR.replace('features');
// Add a new insurance tab field
function addInsuranceField() {
    let index = document.querySelectorAll('#insurance-tab .field-group').length;
    let newField = `
        <div class="field-group">
            <label for="question-${index}">Question</label>
            <input type="text" name="insurence_tab[${index}][question]" placeholder="Enter question" class="form-control" required>
            <label for="answer-${index}">Answer</label>
            <textarea name="insurence_tab[${index}][answer]" placeholder="Enter answer" class="form-control" required></textarea>
            <button type="button" class="btn btn-danger" onclick="deleteField(this)">Delete</button>
        </div>
    `;
    document.getElementById('insurance-tab').insertAdjacentHTML('beforeend', newField);
}

// Function to add an image text input field dynamically
function addImageText(button) {
    let parent = button.closest('.field-group'); // Find the closest field-group
    let index = parent.querySelectorAll('.image-texts input').length; // Get current number of image text inputs
    
    // Create new input field for image text
    let newTextInput = `
        <input type="text" class="form-control" name="image_text[${index}][]" placeholder="Enter image description">
    `;
    
    // Append the new image text input to the .image-texts container
    parent.querySelector('.image-texts').insertAdjacentHTML('beforeend', newTextInput);
}

// Function to add a new field for image and text dynamically
function addField(containerId) {
    let container = document.getElementById(containerId);
    let index = container.querySelectorAll('.field-group').length; // Get current number of field groups

// Create new field for image and text
    let newField = `
        <div class="field-group">
            <label>Image:</label>
            <input type="file" class="form-control" name="serviceentryimage[]" required>
            
            <div class="image-texts">
                <label>Image Text (Optional):</label>
                <input type="text" class="form-control" name="image_text[${index}][]" placeholder="Enter image description">
            </div>

<button type="button" class="btn btn-success btn-sm" onclick="addImageText(this)">Add More Image Text</button>
            <button type="button" class="btn btn-danger" onclick="deleteField(this)">Delete</button>
        </div>
    `;
    
    // Append the new field to the container
    container.insertAdjacentHTML('beforeend', newField);
}

// Function to delete a field group (image + features list)
function deleteField(button) {
    let fieldGroup = button.closest('.field-group');
    fieldGroup.remove();
}
// Add a new FAQ field
function addFaqField() {
    let index = document.querySelectorAll('#service-faqs .field-group').length;
    let newField = `
        <div class="field-group">
            <label for="faq-question-${index}">Question</label>
            <input type="text" name="faqs[${index}][question]" placeholder="Enter question" class="form-control" required>
            <label for="faq-answer-${index}">Answer</label>
            <textarea name="faqs[${index}][answer]" placeholder="Enter answer" class="form-control" required></textarea>
            <button type="button" class="btn btn-danger" onclick="deleteField(this)">Delete</button>
        </div>
    `;
    document.getElementById('service-faqs').insertAdjacentHTML('beforeend', newField);
}

// Delete a field
function deleteField(button) {
    button.closest('.field-group').remove();
}

// Function to add more features list input fields
// Function to add more features list input fields
function addFeaturesList(button) {
    let parent = button.closest('.field-group');
    let index = parent.parentElement.querySelectorAll('.field-group').length; // This counts the number of field groups

let newTextInput = `
        <input type="text" class="form-control" name="features_list[${index}]" placeholder="Enter Features List">
    `;

let imageTextContainer = parent.querySelector('.image-texts');
    if (!imageTextContainer) {
        imageTextContainer = document.createElement('div');
        imageTextContainer.classList.add('image-texts');
        parent.appendChild(imageTextContainer);
    }

imageTextContainer.insertAdjacentHTML('beforeend', newTextInput);
}

// Function to add a new field container for image and feature list
function addFieldContainer(containerId) {
    let container = document.getElementById(containerId);
    let index = container.querySelectorAll('.field-group').length; // Get the number of field groups in this container

let newField = `
        <div class="field-group">
            <label>Features List</label>
            <input type="text" class="form-control" name="features_list[${index}]" placeholder="Enter Features List">
            <button type="button" class="btn btn-success btn-sm" onclick="addFeaturesList(this)">Add More Features List</button>
            <label>Image:</label>
            <input type="file" class="form-control" name="image[]" required>
            <button type="button" class="btn btn-danger" onclick="deleteField(this)">Delete</button>
        </div>
    `;
    
    container.insertAdjacentHTML('beforeend', newField);
}

</script>
</div>

<script src="../assets/vendor/libs/jquery/jquery.js"></script>
    <script src="../assets/vendor/libs/popper/popper.js"></script>
    <script src="../assets/vendor/js/bootstrap.js"></script>
    <script src="../assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.js"></script>

<script src="../assets/js/main.js"></script>

<script async defer src="https://buttons.github.io/buttons.js"></script>
  </body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: solutions.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation