-
Notifications
You must be signed in to change notification settings - Fork 0
/
displayCategories.php
41 lines (29 loc) · 1.15 KB
/
displayCategories.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<?php
require_once "classes/DBAccess.php";
$title = "Display Categories";
$pageHeading = "Display Categories";
//get database settings
include "settings/db.php";
//create database object
$db = new DBAccess($dsn, $username, $password);
//connect to database
$pdo = $db->connect();
$sql = "select categoryName, categoryId from category";
$stmt = $pdo->prepare($sql);
$rows = $db->executeSQL($stmt);
//start buffer
ob_start();
//get the category id from the query string
if(isset($_GET["id"]))
{
$catId = $_GET["id"];
$sql = "SELECT photo, price, salePrice, itemName, description, itemId, category.categoryName, item.categoryId FROM item
LEFT JOIN category ON category.categoryId = item.categoryId WHERE category.categoryId = :categoryId";
$stmt = $pdo->prepare($sql);
$stmt->bindValue(":categoryId" , $catId, PDO::PARAM_INT);
$rowsProducts = $db->executeSQL($stmt);
include "templates/productCard.html.php";
}
$output = ob_get_clean();
include "templates/layoutCategories.html.php";
?>