|
Server IP : 103.191.208.227 / Your IP : 18.117.156.153 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/mhmsfzcs/vflyorions.com/../gemsandpearl.com/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'db.php';
if (isset($_POST['query'])) {
$searchQuery = $_POST['query'];
$sql = "SELECT * FROM gemstone_products WHERE name LIKE '%$searchQuery%' LIMIT 5";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$pid=$row['pid'];
$cat_id=$row['category_id'];
$sub_cat_id=$row['sub_cat_id'];
echo '<div><a href="product-details.php?pid=' . $pid . '&cat_id=' . $cat_id . '&sub_cat_id=' . $sub_cat_id . '">' . htmlspecialchars($row['name']) . '</a></div>';
}
} else {
echo '<div>No products found</div>';
}
}
$conn->close();
?>