-
Notifications
You must be signed in to change notification settings - Fork 1
/
categoryList.php
68 lines (54 loc) · 1.85 KB
/
categoryList.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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
<?php
include 'header.php';
include 'configParameter.php';
include 'checkGETParams.php';
$type = $_GET['type'];
// show articleType - ex. Lebensmittel
$sql = "SELECT nme FROM articleType WHERE id = ?";
$stmt = $connect -> prepare($sql);
$stmt -> bind_param('i', $type);
$stmt -> execute();
$stmt -> bind_result($articleType);
$stmt -> fetch();
$stmt -> close();
$title = '<h1>'.utf8_encode($articleType).'</h1>';
// show all categories in this articletype
$sql = "SELECT DISTINCT
cl.categoryid, cl.nme
FROM
article a,
category_language cl,
article_category ac
WHERE
a.articletypeID = ?
AND a.id = ac.articleid
AND ac.categoryid = cl.categoryid
ORDER BY cl.nme ASC";
$stmt = $connect -> prepare($sql);
$stmt -> bind_param('i', $type);
$stmt -> execute();
$stmt -> bind_result($categoryID, $categoryName);
$content = '<ul>';
while($stmt -> fetch())
{
// show number of articles in this category
$stmt2 = $connect2 -> query("SELECT a.nme
FROM
article_category ac,
article a
WHERE
categoryid = $categoryID
AND a.id = ac.articleid
AND a.articleStatusID = '".$articleStatus."'");
$numberOfArticles = $stmt2 -> num_rows;
$stmt2 -> close();
if($numberOfArticles > 0)
$content .= '
<li id="categoryListNavigation">
<a href="productList.php?cid='.$categoryID.'" title="'.utf8_encode($categoryName).'">'.utf8_encode($categoryName).' <span id="productCount"> ('.$numberOfArticles.')</span></a>
</li>';
}
$content .= '</ul>';
$stmt -> close();
include 'footer.php';
?>