Ecommerce Functions2 for Ecommerce Layout3

<?php


$db=mysqli_connect("localhost","root","","ecommerce");



function getPro(){

global $db;

if (!isset($_GET['cat'])){

    if (!isset($_GET['brand'])){

$get_products="select * from products order by rand() LIMIT 0,6";
$run_products=mysqli_query($con,$get_products);
while($row_products=mysqli_fetch_array($run_products)){

$pro_id=$row_products['product_id'];
$pro_title=$row_products['product_title'];
$pro_cat=$row_products['cat_id'];
$pro_brand=$row_products['brand_id'];
$pro_desc=$row_products['product_desc'];
$pro_price=$row_products['product_price'];
$pro_image=$row_products['product_img1'];

echo"<div id='single_product'>
<h3>$pro_title</h3>
<img src='admin_area/product_images/$pro_image'width='180' height='180'/><br/>
<p><b>Price:Rs: $pro_price</b></p>
<a href='details.php?pro_id=$pro_id' style='float:left;'>Details</a>
<a href='index.php?add_cart=$pro_id'>
<button style="float:right">Add to cart</button></a></div>";

}




}
}
}



function getCatPro(){

global $db;

if (isset($_GET['cat'])){

   $cat_id=$_GET['cat'];

$get_cat_pro="select * from products where cat_id='$cat_id'";
$run_cat_pro=mysqli_query($con,$get_cat_pro);
while($row_cat_pro=mysqli_fetch_array($row_cat_pro)){

$pro_id=$row_cat_pro['product_id'];
$pro_title=$row_cat_pro['product_title'];

$pro_desc=$row_cat_pro['product_desc'];
$pro_price=$row_cat_pro['product_price'];
$pro_image=$row_cat_pro['product_img1'];

echo"<div id='single_product'>
<h3>$pro_title</h3>
<img src='admin_area/product_images/$pro_image'width='180' height='180'/><br/>
<p><b>Price:Rs: $pro_price</b></p>
<a href='details.php?pro_id=$pro_id' style='float:left;'>Details</a>
<a href='index.php?add_cart=$pro_id'>
<button style="float:right">Add to cart</button></a></div>";

}




}

}


function getBrandPro(){

global $db;

if (isset($_GET['brand'])){

   $brand_id=$_GET['brand'];

$get_brand_pro="select * from products where brand_id='$brand_id'";
$run_brand_pro=mysqli_query($con,$get_brand_pro);

$count=mysqli_num_rows($run_brand_pro);
if ($count==0){ echo"<h2>No Products found in this brand</h2>";}
while($row_brand_pro=mysqli_fetch_array($row_brand_pro)){

$pro_id=$row_brand_pro['product_id'];
$pro_title=$row_brand_pro['product_title'];

$pro_desc=$row_brand_pro['product_desc'];
$pro_price=$row_brand_pro['product_price'];
$pro_image=$row_brand_pro['product_img1'];

echo"<div id='single_product'>
<h3>$pro_title</h3>
<img src='admin_area/product_images/$pro_image'width='180' height='180'/><br/>
<p><b>Price:Rs: $pro_price</b></p>
<a href='details.php?pro_id=$pro_id' style='float:left;'>Details</a>
<a href='index.php?add_cart=$pro_id'>
<button style="float:right">Add to cart</button></a></div>";

}




}

}


















function getBrands(){

global $db;





$get_brands="select * from brands";
$run_brands=mysqli_query($con,$get_brands);
while($row_brands=mysqli_fetch_array($run_brands)){

$brand_id=$row_brands['brand_id'];
$brand_title=$row_brands['brand_title'];
  echo"<li><a href='index.php?brand=$brand_id'>$brand_title</a></li>"; 

}







}




function getCats(){

global $db;



$get_cats="select * from categories";
$run_cats=mysqli_query($con,$get_cats);
while($row_cats=mysqli_fetch_array($run_cats)){

$cat_id=$row_cats['cat_id'];
$cat_title=$row_cats['cat_title'];
                              echo"<li><a href='index.php?cat=$cat_id'>$cat_title</a></li>"; 

}













}










?>