prepare("SELECT * FROM tbl_products WHERE nprd_category_id = :category");
$stmt->bindParam(':category', $nCategory);
$stmt->execute();
$intROWCOUNT = $stmt->rowCount(); // Holds No of Products
$intPAGECOUNT = ceil($intROWCOUNT / $intRPP);
// Database query for fetching limited Products in descending order
$stmt1 = $db->prepare("SELECT * FROM tbl_products INNER JOIN tbl_users ON nprd_instructor_id = nusr_id WHERE nprd_category_id = :category OR nprd_parent_cat = :category ORDER BY nprd_id DESC LIMIT $intSTART, $intRPP");
$stmt1->bindParam(':category', $nCategory);
$stmt1->execute();
if($stmt1->rowCount() > 0){
while ($product = $stmt1->fetch()){
$strProductImage = "img/dummyproductimage.jpg"; // Holds Placeholder Product image
if($product['sprd_cover_image'] !== NULL){
$strProductImage = str_replace('../uploads/','uploads/thumbs/',$product['sprd_cover_image']);
}
$discount = FALSE; // Holds Discount Status
// Database query for checking Discount
$stmt2 = $db->prepare("SELECT * FROM tbl_discount WHERE ndis_product_id = :product_id AND CURDATE() BETWEEN sdis_start_date AND sdis_end_date AND ndis_approve = 1");
$stmt2->bindParam(':product_id', $product['nprd_id']);
$stmt2->execute();
$nOriginalPrice = $product['sprd_price']; // Holds Original Price
if($stmt2->rowCount() == 1){
$discount = TRUE;
$row = $stmt2->fetch();
$nDiscount = $row['ndis_discount']; // Holds Discount Percent
$nDiscountedPrice = ($nOriginalPrice / 100) * $nDiscount; // Holds Discounted Price
$nDiscountedPrice = $nOriginalPrice - $nDiscountedPrice;
}
?>
";
echo "
';
}
}
elseif(isset($_GET['q']) && !empty($_GET['q'])){
$strSearch = "%".$_GET['q']."%";
$intPAGENO = 1; // Holds Page No
$intRPP = 12; // Holds Records Per Page
$intPAGECOUNT = 0; // Holds Page Count
$intSTART = 0; // Holds Start Index for Query
$intROWCOUNT = 0; // Holds Row COunt
if(!empty($_GET['page'])){
$intPAGENO = $_GET['page'];
}
$intSTART = ($intPAGENO-1) * $intRPP;
// Database query for fetching all Products
$stmt = $db->prepare("SELECT * FROM tbl_products WHERE sprd_name LIKE :search_string");
$stmt->bindParam(':search_string', $strSearch);
$stmt->execute();
$intROWCOUNT = $stmt->rowCount(); // Holds No of Products
$intPAGECOUNT = ceil($intROWCOUNT / $intRPP);
// Database query for fetching limited Events in descending order
$stmt1 = $db->prepare("SELECT * FROM tbl_products INNER JOIN tbl_users ON nprd_instructor_id = nusr_id WHERE sprd_name LIKE :search_string ORDER BY nprd_id DESC LIMIT $intSTART, $intRPP");
$stmt1->bindParam(':search_string', $strSearch);
$stmt1->execute();
if($stmt1->rowCount() > 0) {
while ($product = $stmt1->fetch()) {
$strProductImage = "img/dummyproductimage.jpg"; // Holds Placeholder Product image
if ($product['sprd_cover_image'] !== NULL) {
$strProductImage = str_replace('../uploads/', 'uploads/thumbs/', $product['sprd_cover_image']);
}
$discount = FALSE; // Holds Discount Status
// Database query for checking Discount
$stmt2 = $db->prepare("SELECT * FROM tbl_discount WHERE ndis_product_id = :product_id AND CURDATE() BETWEEN sdis_start_date AND sdis_end_date AND ndis_approve = 1");
$stmt2->bindParam(':product_id', $product['nprd_id']);
$stmt2->execute();
$nOriginalPrice = $product['sprd_price']; // Holds Original Price
if ($stmt2->rowCount() == 1) {
$discount = TRUE;
$row = $stmt2->fetch();
$nDiscount = $row['ndis_discount']; // Holds Discount Percent
$nDiscountedPrice = ($nOriginalPrice / 100) * $nDiscount; // Holds Discounted Price
$nDiscountedPrice = $nOriginalPrice - $nDiscountedPrice;
}
?>
";
echo '
';
echo '
Error!
'; echo 'No Courses found in this Category!!!'; echo '';
echo '