<?php
include("../include/config.php");

if(!empty(ltrim($_POST["keyword"]))) {
    $search_id = $_POST['search_id'];
    
    $keyword = mysqli_real_escape_string($GLOBALS['conn'], trim($_POST["keyword"]));

    $queryprod = $obj->query("
        SELECT p.id, product_name, p.photo_wide, s.photo, s.sectionid 
        FROM tbl_product p 
        LEFT JOIN stores s ON p.storeid = s.storeid 
        WHERE p.status=1 
          AND p.product_name LIKE '%$keyword%' 
        ORDER BY 
            (CASE 
                WHEN product_name LIKE '%$keyword%' THEN 1 
                ELSE 2 
            END) ASC 
        LIMIT 0,10
    ");
?>
<ul id="product-list">
<?php
while ($resultprod = $obj->fetchNextObject($queryprod)) { 
    if($resultprod->sectionid==24) { ?>
        <li class="listtype" onClick="selectCountry('<?php echo $resultprod->product_name; ?>','<?php echo $search_id;?>','<?php echo $resultprod->id; ?>');">
            <img src="https://www.quicklly.com/upload_images/product/wide/<?php echo $resultprod->photo_wide; ?>" style="border: 1px solid #eee; border-radius: 50%; width: 30px; height: 30px"> &nbsp
            <span style="top: -12px !important;position: relative;"><?php echo $resultprod->product_name; ?></span>
        </li>
<?php
    } else { ?>
        <li class="listtype" onClick="selectCountry('<?php echo $resultprod->product_name; ?>','<?php echo $search_id;?>','<?php echo $resultprod->id; ?>');">
            <img src="https://quicklly.com/seller/upload_images/store/thumb/<?php echo $resultprod->photo; ?>" style="border: 1px solid #eee; border-radius: 50%; width: 30px; height: 30px"> &nbsp
            <span style="top: -12px !important;position: relative;"><?php echo $resultprod->product_name; ?></span>
        </li>
<?php }
} ?>
</ul>
<?php }  ?>
