OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📁 assets	-	02/24/2025 12:08:08 PM	rwxr-xr-x
📄 back2_index.php	20.45 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 getAnalyticsData.php	1.45 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 index.php	18.97 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 index_before_analytics.php	11.83 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 index_old.php	5.81 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 lastb_index.php	27.85 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 pages	-	02/28/2025 05:33:15 AM	rwxrwxrwx
📁 process	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📄 script.js	19.15 KB	02/24/2025 12:20:58 PM	rw-r--r--
📄 style.css	11.13 KB	02/24/2025 12:20:58 PM	rw-r--r--
📄 template1.php	8.37 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 template2	-	02/24/2025 12:08:09 PM	rwxr-xr-x

Editing: getAnalyticsData.php

<?php
// Include your database connection here
include "../assets/php/db_config.php";

header('Content-Type: application/json');

// Get the page ID from the AJAX request
$pageId = $_POST['id'] ?? null;

// Make sure the page ID is valid
if (!$pageId) {
    echo json_encode(['success' => false, 'message' => 'Invalid page ID']);
    exit;
}

// Query the database to fetch the analytics data for the given page ID
$sql = "SELECT name, email, mobile, company, created_at, designation,query, state, city FROM user_landing_page_leads WHERE page_id = ?";
$stmt = $creamdb->prepare($sql);
$stmt->bind_param("i", $pageId);  // Bind the page ID to the query
$stmt->execute();
$result = $stmt->get_result();

// Check if data was found
if ($result->num_rows > 0) {
    $data = [];
    // Fetch all rows
    while ($row = $result->fetch_assoc()) {
        $data[] = [
            'name' => $row['name'],
            'email' => $row['email'],
            'mobile' => $row['mobile'],
            'company' => $row['company'],
            'created_at' => $row['created_at'],
            'designation' => $row['designation'],
            'query' => $row['query'],
            'state' => $row['state'],
            'city' => $row['city']
        ];
    }
    echo json_encode(['success' => true, 'data' => $data]);
} else {
    echo json_encode(['success' => false, 'message' => 'No data found for this page']);
}

$stmt->close();
$creamdb->close();
?>