bnmbertsurheoppojkjkkjjkjkjjkkjkjooooopoopopdf'tdfg

hjkhghopjkkjjkjkjkjkkjkjppoopoirh bnmbertsurheoppojkjkkjjkjkjjkkjkjooooopoopopdf'tdfg

<?php
include("admin-control/classes/Crud.php");
$crud = new Crud();
$dt = $crud->escape_string($_GET['dt']); 
if(empty($dt)){null;}else{ ?>
<ul class="searchDrop">
    <?php
    $query = $crud->getData("SELECT * FROM products WHERE oem_number LIKE '%{$dt}%' and status=1");
    foreach ($query as $data){ ?>
    <li><a href="product/?seo=<?php echo $data['seo'];?>&productid=<?php echo $data['seoid'];?>"><?php echo $data['oem_number'];?></a></li>
    <?php } ?>
     <?php
    $query = $crud->getData("SELECT * FROM products WHERE skucode LIKE '%{$dt}%' and status=1");
    foreach ($query as $data){ ?>
    <li><a href="../product/?seo=<?php echo $data['seo'];?>&productid=<?php echo $data['seoid'];?>"><?php echo $data['skucode'];?></a></li>
    <?php } ?>
    <?php
    $query = $crud->getData("SELECT * FROM products WHERE name LIKE '%{$dt}%' and status=1");
    foreach ($query as $data){ ?>
    <li><a href="product/?seo=<?php echo $data['seo'];?>&productid=<?php echo $data['seoid'];?>"><?php echo $data['name'];?></a></li>
    <?php } ?>
    <?php
    $query = $crud->getData("SELECT * FROM main_category WHERE name LIKE '%{$dt}%' and status=1");
    foreach ($query as $data){ 
        $data2 = $crud->getData("SELECT * FROM category WHERE id='$data[category]'");    
    ?>
    <li><a href="main-products/?seo=<?php echo $data['seo'];?>&brandid=<?php echo $data['seoid'];?>"><?php echo $data['name'];?> (<?php echo $data2[0]['name'];?>)</a></li>
    <?php } ?>
    <?php
    $query = $crud->getData("SELECT * FROM category WHERE name LIKE '%{$dt}%' and status=1");
    foreach ($query as $data){ ?>
    <li><a href="brands/?seo=<?php echo $data['seo'];?>"><?php echo $data['name'];?></a></li>
    <?php } ?>
</ul>
<?php } ?>