-
Notifications
You must be signed in to change notification settings - Fork 0
/
read_template.php
90 lines (71 loc) · 3.04 KB
/
read_template.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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
<?php
// search form
echo "<form role='search' action='search.php'>";
echo "<div class='input-group col-md-3 pull-left margin-right-1em'>";
$search_value=isset($search_term) ? "value='{$search_term}'" : "";
echo "<input type='text' class='form-control' placeholder='Type product name or description...' name='s' id='srch-term' required {$search_value} />";
echo "<div class='input-group-btn'>";
echo "<button class='btn btn-primary' type='submit'><i class='glyphicon glyphicon-search'></i></button>";
echo "</div>";
echo "</div>";
echo "</form>";
//items per page selector
echo "<select class='form-control' name='itemsperpage'>";
echo "<option>Please select...</option>";
for($i = 0; $i < 10; $i++){
echo "<option value='$i' selected>";
echo "{$i}</option>";
}
echo "</select>";
// create product button
echo "<div class='right-button-margin'>";
echo "<a href='create_product.php' class='btn btn-primary pull-right'>";
echo "<span class='glyphicon glyphicon-plus'></span> Create Product";
echo "</a>";
echo "</div>";
// display the products if there are any
if($total_rows>0){
echo "<table class='table table-hover table-responsive table-bordered'>";
echo "<tr>";
echo "<th>Product</th>";///many tss
echo "<th>Price</th>";
echo "<th>Description</th>";
echo "<th>Category</th>";
echo "<th>Actions</th>";
echo "</tr>";
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
extract($row);
echo "<tr>";
echo "<td>{$name}</td>";
echo "<td>{$price}</td>";
echo "<td>{$description}</td>";
echo "<td>";
$category->id = $category_id;
$category->readName();
echo $category->name;
echo "</td>";
echo "<td>";
// read product button
echo "<a href='read_one.php?id={$id}' class='btn btn-primary left-margin'>";
echo "<span class='glyphicon glyphicon-list'></span> Read";
echo "</a>";
// edit product button
echo "<a href='update_product.php?id={$id}' class='btn btn-info left-margin'>";
echo "<span class='glyphicon glyphicon-edit'></span> Edit";
echo "</a>";
// delete product button
echo "<a delete-id='{$id}' class='btn btn-danger delete-object'>";
echo "<span class='glyphicon glyphicon-remove'></span> Delete";
echo "</a>";
echo "</td>";
echo "</tr>";
}
echo "</table>";
// paging buttons
include_once 'paging.php';
}
// tell the user there are no products
else{
echo "<div class='alert alert-danger'>No products found.</div>";
}
?>