Merchant Centre
| Follow us on
No notifications
Register
Login
Register
|
Login
×
×
$isFullList = true; if( (isset($_GET['query'])) ) { $isFullList = false; $searchQuery = $_GET['query']; $strSQL = "SELECT * FROM product WHERE item_brand LIKE '%{$searchQuery}%'AND item_status = 'active' OR item_name LIKE '%{$searchQuery}%' AND item_status = 'active' "; $prepared = $conn3->prepare($strSQL); $prepared->execute(array($searchQuery)); if($prepared->rowCount() > 0){ $prepared->setFetchMode(PDO::FETCH_ASSOC); ?>
You have searched for '' product(s)
while($row= $prepared->fetch()){ ?>
RM 0.00
} } else { ?>
Sorry, product you're looking for is not found.
} } else { echo " "; } ?>
include('footer.php'); ?>