File Manager

Editing:search.php

<?php
require_once __DIR__ . '/../includes/functions.php';
header('Content-Type: application/json');

$query = trim($_GET['q'] ?? '');

if (strlen($query) < 2) {
    echo json_encode(['success' => false, 'data' => []]);
    exit;
}

try {
    $stmt = $db->prepare("SELECT id, name, slug, regular_price, sale_price, thumbnail 
                          FROM products 
                          WHERE status = 1 AND (name LIKE ? OR short_description LIKE ? OR tags LIKE ?) 
                          ORDER BY name ASC LIMIT 10");
    $search_term = '%' . $query . '%';
    $stmt->execute([$search_term, $search_term, $search_term]);
    $products = $stmt->fetchAll();
    
    $data = [];
    foreach ($products as $p) {
        $price = $p['sale_price'] > 0 ? $p['sale_price'] : $p['regular_price'];
        $image = SITE_URL . 'assets/images/no-image.jpg';
        if ($p['thumbnail']) {
            if (file_exists(UPLOADS_PATH . 'products/' . $p['thumbnail'])) {
                $image = UPLOADS_URL . 'products/' . $p['thumbnail'];
            } elseif (file_exists(UPLOADS_PATH . 'settings/' . $p['thumbnail'])) {
                $image = UPLOADS_URL . 'settings/' . $p['thumbnail'];
            }
        }
        $data[] = [
            'id' => $p['id'],
            'name' => $p['name'],
            'url' => SITE_URL . 'pages/product.php?slug=' . $p['slug'],
            'image' => function_exists('img_url') ? img_url($image) : $image,
            'price' => format_currency($price)
        ];
    }
    
    echo json_encode(['success' => true, 'data' => $data]);
} catch (Exception $e) {
    echo json_encode(['success' => false, 'message' => 'Search failed']);
}

Cancel

🤩 File Manager - Mr.X

Editing:search.php