Ecommerce Functions for Ecommerce Layout3
Ecommerce Functions 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 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>";
}
}
?>