<?php session_start(); include "../admin/database.php" ; $user_id=NULL; $user_id=session_id(); $query="SELECT * from temp_cart where user_id='$user_id'"; $rec=db::getRecords($query); if($rec!=NULL){ foreach($rec as $rec2) { $product_id=$rec2['product_id']; $query="SELECT * from product where id='$product_id'"; $product=db::getRecord($query); $sql="SELECT * FROM product_image where product_id='$product_id'"; $image=db::getRecord($sql); echo " <li class='item clearfix'> <a class='product-image' href='single_product?id=".$product['id']."'> <img src='admin/product/images/".$image['image_name']."'> </a> <div class='product-details'> <a href='admin/action.php?delete_item=".$rec2['id']."' class='remove'><i class='anm anm-times-sql' aria-hidden='true'></i></a> <a class='product-title' href='single_product?id=".$product['id']."'>".$product['name']." <span>x (".$rec2['quantity'].")</span></a> <div class='priceRow'> <div class='product-price'> <span class='money'>$".$product['price']."</span> </div> </div> </div> </li> "; }; } else{ echo"Your Cart is Empty"; } ?>