OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📁 NW_images	-	03/13/2025 09:27:20 AM	rwxrwxrwx
📁 assets	-	03/13/2025 09:27:20 AM	rwxr-xr-x
📄 db_gallery.php	292 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 edit_template.php	658 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 fetch_data.php	773 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 fetch_titles.php	0 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 form.js	7.64 KB	03/13/2025 09:27:10 AM	rw-r--r--
📄 getAnalyticsData.php	1.45 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 images2	-	03/13/2025 10:38:29 AM	rwxr-xr-x
📁 images3	-	03/13/2025 10:38:30 AM	rwxr-xr-x
📁 images4	-	03/13/2025 10:38:31 AM	rwxr-xr-x
📄 index.php	11.42 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 load_template.php	2.21 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 nleditor_navbar.php	22.6 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 pages	-	03/13/2025 09:27:22 AM	rwxrwxrwx
📁 process	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📄 process.js	30.77 KB	03/15/2025 04:35:27 AM	rw-r--r--
📄 processb.js	31.21 KB	03/13/2025 09:27:11 AM	rw-r--r--
📄 save-template.php	2.69 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 savedPages.php	21.06 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 script.js	34.02 KB	03/13/2025 09:27:11 AM	rw-r--r--
📄 styles.css	2.43 KB	03/13/2025 09:27:11 AM	rw-r--r--
📄 upload.php	858 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📁 uploads	-	06/05/2025 11:43:53 AM	rwxrwxrwx

Editing: load_template.php

<?php
// Database connection settings
include 'db_gallery.php';

// Ensure that the 'category' parameter is passed
if (isset($_GET['category'])) {
    $category = $_GET['category'];

// Prepare SQL query to fetch the template path, image path, and template name based on the category
    $stmt = $conn->prepare("SELECT template_name, image_path, template_path FROM leadPageTemplates WHERE category = ?");
    $stmt->bind_param("s", $category); 
    $stmt->execute();

// Get the result
    $stmt->store_result();

// Check if templates exist for the specified category
    if ($stmt->num_rows > 0) {
        // Bind the result to variables
        $stmt->bind_result($templateName, $imagePath, $templatePath);

// Start building the response
        $response = '';

// Fetch and display all matching templates
        while ($stmt->fetch()) {
            // Check if the image path is a valid URL
            if (filter_var($imagePath, FILTER_VALIDATE_URL)) {
                // Build the HTML for each template dynamically
                $response .= '
                    <div class="template" data-template="' . htmlspecialchars($templateName, ENT_QUOTES, 'UTF-8') . '" data-template-path="' . htmlspecialchars($templatePath, ENT_QUOTES, 'UTF-8') . '" data-category="' . htmlspecialchars($category, ENT_QUOTES, 'UTF-8') . '">
                        <img src="' . htmlspecialchars($imagePath, ENT_QUOTES, 'UTF-8') . '" alt="' . htmlspecialchars($templateName, ENT_QUOTES, 'UTF-8') . '">
                        <span>' . htmlspecialchars($templateName, ENT_QUOTES, 'UTF-8') . '</span>
                    </div>
                ';
            } else {
                // Error if the image path is invalid
                $response .= '<p>Error: Invalid image path for template ' . htmlspecialchars($templateName, ENT_QUOTES, 'UTF-8') . '</p>';
            }
        }

echo $response;
    } else {
        echo '<p>No templates found for this category.</p>';
    }

$stmt->close();
} else {
    // Return an error if the 'category' parameter is not provided
    echo '<p>Error: No category specified.</p>';
}

// Close the database connection
$conn->close();