Hier volgt de code die de categorien werkend zou maken:
<?php
$con = mysqli_connect("","","","");
//getting the categories
function getCats () {
global $con;
$get_cats = "select * from categories";
$run_cats = mysqli_query ($con, $get_cats);
while ($row_cats=mysqli_fetch_array($run_cats)){
$cat_id = $row_cats['çat_id'];
$cat_title = $row_cats['cat_title'];
echo "<li><a href='index.php?cat=$cat_id'>$cat_title</a></li>";
}
}
function getPro(){
if(!isset($_GET['cat'])){
$cat_id = $_GET['cat'];
global $con;
$get_pro = "select * from products LIMIT 0,15";
$run_pro = mysqli_query($con, $get_pro);
while($row_pro=mysqli_fetch_array($run_pro)){
$pro_id = $row_pro['product_id'];
$pro_cat = $row_pro['product_cat'];
$pro_title = $row_pro['product_title'];
$pro_price = $row_pro['product_price'];
$pro_image = $row_pro['product_image'];
echo "
<div id='single_product'>
<h3?>$pro_title</h3><br>
<img src='admin_area/product_images/$pro_image' width='180' height='180'
<p><b> $pro_price euro </b></p>
<a href='details.php?pro_id=$pro_id' style='float:left;'>Details</a?
<a href='index.php?pro_id=$pro_id'><button style='float:center'>Add To Cart</button></a>
</div>
";
}
}
}
?>
Hartelijk bedankt alvast, Mireille.