search.php

<?php
// Include the database connection
include("database.php");

// Define the size mapping
$sizeMapping = [
    'XS' => 'Extra Small',
    'S' => 'Small',
    'M' => 'Medium',
    'L' => 'Large',
    'XL' => 'Extra Large',
    // Add more sizes as necessary
];

// Get the search query from the request
$searchQuery = isset($_GET['query']) ? trim($_GET['query']) : '';

// Initialize an array to hold the results
$results = [];
$suggestions = [];

// Check if the search query is not empty
if (!empty($searchQuery)) {
    // Convert size abbreviations in the search query to full names
    foreach ($sizeMapping as $abbreviation => $fullName) {
        $searchQuery = str_replace($fullName, $abbreviation, $searchQuery);
    }

    // Prepare a statement to search for products
    $stmt = $connect->prepare("SELECT * FROM products WHERE ProductName LIKE ? OR ProductType LIKE ? OR Color LIKE ? OR Size LIKE ?");
    $likeQuery = "%" . $searchQuery . "%";
    $stmt->bind_param("ssss", $likeQuery, $likeQuery, $likeQuery, $likeQuery);
    $stmt->execute();
    $result = $stmt->get_result();

    // Fetch results
    while ($row = $result->fetch_assoc()) {
        $results[] = $row;
    }

    // If no results found, suggest similar products
    if (empty($results)) {
        // Prepare a statement to find similar products
        $stmt = $connect->prepare("SELECT * FROM products WHERE ProductName LIKE ? OR Color LIKE ? OR Size LIKE ?");
        $similarQuery = "%" . substr($searchQuery, 0, strlen($searchQuery) - 1) . "%"; // Remove last character for suggestion
        $stmt->bind_param("sss", $similarQuery, $similarQuery, $similarQuery);
        $stmt->execute();
        $result = $stmt->get_result();

        // Fetch suggestions
        while ($row = $result->fetch_assoc()) {
            $suggestions[] = $row;
        }
    }
}

// Return results as JSON
header('Content-Type: application/json');
echo json_encode(['results' => $results, 'suggestions' => $suggestions]);
?>