ajaxserach.php

<?php

$search_val = $_POST["search"];

session_start();
include("connect.php");
$id = $_SESSION['vender_id'];
$sql = "SELECT * FROM tbl_product WHERE (p_name LIKE '%{$search_val}%' OR s_no LIKE '%{$search_val}%') AND vid = '$id'";
$result = mysqli_query($connect, $sql) or die("SQL FAIELD");

$output = "";
$button = "";
$i = 0;
if (mysqli_num_rows($result) > 0) {
    $output = '<table   margin-top: 20px border-radius: 10px overflow: hidden box-shadow: 0px 0px 10px rgba(0, 0, 0, 0.1)>
        <thead>
        <tr>
            <th>#</th>
            <th>Serial Number</th>
            <th>Product Name</th>
            <th>Product Image</th>
            <th>Product Details</th>
            <th>Category</th>
            <th>Quantity</th>
            <th>Price</th>
            <th>Action</th>
        </tr>
        </thead>';

    while ($row = mysqli_fetch_assoc($result)) {
        $i++;
        $output .= "<tr><td>$i</td><td>{$row["s_no"]}</td>
        <td>{$row["p_name"]}</td><td><img src='{$row["p_image"]}' height='100px' width='100px' class='img'></td>
        <td>{$row["p_detail"]}</td><td>{$row["category"]}</td>
        <td>{$row["p_quantity"]}</td><td>{$row["p_price"]}</td>
        <td class='i'> &nbsp &nbsp<button class='auction-btn' data-id='{$row["product_id"]}'><span class='ri-auction-line'></span><span class='tooltiptext'>Auction</span></button> &nbsp 
        &nbsp <button class='edit-btn'  data-id='{$row["product_id"]}'><span class='material-symbols-outlined' id='edit'><a href='editproduct.php?pid={$row["product_id"]}'>edit</a></span> <span class='tooltiptext'>Edit Product</span></button>&nbsp
        <button class='delete-btn' data-id='{$row["product_id"]}'><span class='material-symbols-outlined' >delete</span> <span class='tooltiptext'>Delete Product</span></button>&nbsp</td></tr>";
    }


    $output .= "</table>";

    mysqli_close($connect);

    echo $output;
} else {
    echo '<h1 style="color:white">NO PRODUCTS ARE FOUND</h1>';
}