<?php
require_once 'db.php';

if (isset($_POST['letter'])) {
    $letter = $_POST['letter'];
    $query = "";

    if ($letter === 'all') {
        // Fetch all products
        $query = "SELECT * FROM products";
    } else {
        // Fetch products starting with the selected letter
        $query = "SELECT * FROM products WHERE product_name LIKE '$letter%'";
    }

    $result = mysqli_query($link, $query);
    $products = [];

    while ($row = mysqli_fetch_assoc($result)) {
        $products[] = [
            'product_name' => $row['product_name'],
        
        ];
    }

    header('Content-Type: application/json');
    echo json_encode($products);
}
?>