<?php
require("db.php");
require("header.php");
$search = $_POST['search'];
$result = "SELECT id, cat_id, name, description, long_description, image, price
FROM products
WHERE name LIKE '%$search%'
OR description LIKE '%$search%'
OR long_description LIKE '%$search%' ";
$prodcatres = mysql_query($result);
// echneme pre istotu error
echo mysql_error();
if(mysql_num_rows($prodcatres)>0) {
while($prodrow = mysql_fetch_assoc($prodcatres))
{
echo "<div id='product'>";
echo "<a href='product.php?id=". $prodrow['id'] . "'><h3>" . $prodrow['name'] . "</h3></a>";
if(empty($prodrow['image'])) {
echo "<center><img
src='./productimages/no_image.jpg' width='100px' height='100px' alt='"
. $prodrow['name'] . "'></center>";
}
else {
echo "<center><img src='./productimages/" . $prodrow['image']
. "' width='100px' height='100px' alt='"
. $prodrow['name'] . "'></center>";
}
echo "<p>" . $prodrow['description'] . " ...";
echo "<p><strong><span>PRICE : </span>£"
. sprintf('%.2f', $prodrow['price']) . "</strong>";
echo "<a href='addtobasket.php?id="
. $prodrow['id'] . "'><span style='float:right;font-size:14px;font-weight:bold;text-decoration:none;'>BUY</span></a></p>";
echo "</div>";
}
} else {
echo "Nic som nenasiel";
}
require("footer.php");
?>
