Hello lahsoona,
for listing products you have to simply run select query in you database table and display data.
See below code For list products with their price.
[php]
<?
$con = mysql_connect("localhost", "username","password") or die('Sorry, could not connect to database server');
mysql_select_db("databsaename", $con) or die('Sorry, could not connect to database');
if (!$con)
{
echo "
Sorry, we cannot process your request at this time, please try again later
\n";
}
else
{
$result = mysql_query("SELECT * FROM products");
while($row = mysql_fetch_array($result))
{
echo $row['product_name'] . " " . $row['price'];
echo "
";
}
}
?>
[/php]
For search bar do below code
[php]
<?
$con = mysql_connect("localhost", "username","password") or die('Sorry, could not connect to database server');
mysql_select_db("databsaename", $con) or die('Sorry, could not connect to database');
if (!$con)
{
echo "
Sorry, we cannot process your request at this time, please try again later
\n";
}
else
{
if($REQUEST_METHOD == "POST")
{
if(!empty($_POST['product_name']))
{
$sql = 'SELECT * FROM products WHERE product_name LIKE "%'.$_POST['product_name'].'%"';
$search_result = mysql_query($sql);
while($row_search = mysql_fetch_array($search_result))
{
echo $row_search['product_name'] . " " . $row_search['price'];
echo "
";
}
}
}
}
?>
Search:
[/php]
I hope this will helpful for you.
Reply Your feed back…
SR
