<th>Subcategory</th>
<th>Product Type</th>
<th>Unit Price</th>
<th>Added On</th>
<th>Edit</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
<?php
foreach ($res as $table_item) {
?>
<?php
$pt_id = $table_item['product_type_id'];
$product_type_name = find_product_type_name($pt_id);
$subcategory_name = find_subcategory_name($pt_id);
$category_name = find_category_name($pt_id);
?>
<tr>
<td><?php
echo $table_item['product_id'];
?>
</td>
<td><?php
echo $table_item['product_name'];
?>
</td>
<td><?php
echo $category_name['category_name'];
?>
</td>
}
// Gather this product's full information for inserting automatically into the edit form below on page
$pid_for_img = "";
$pname_for_img = "";
if (isset($_GET['product_id'])) {
$targetID = $_GET['product_id'];
$sql = myQuery("SELECT * FROM products WHERE product_id=:product_id LIMIT 1", array(':product_id' => $targetID), $conn);
if ($sql->rowCount() > 0) {
$res = $sql->fetchAll(PDO::FETCH_ASSOC);
foreach ($res as $row) {
$pid_for_img = $_GET['product_id'];
$pname_for_img = $row['product_name'];
$product_name = $row['product_name'];
$unit_price = $row['unit_price'];
$category = find_category_name($row['product_type_id']);
$subcategory = find_subcategory_name($row['product_type_id']);
$product_type = find_product_type_name($row['product_type_id']);
$product_description = $row['product_description'];
$date_added = strftime("%b %d, %Y", strtotime($row['date_added']));
}
} else {
$data = "Sorry! No such product exists.";
}
}
include "directory_from_admin.php";
include "../views/header.view.php";
include "../views/admin/admin_header.view.php";
include '../views/admin/update_product.view.php';
include "../views/admin/admin_footer.view.php";
?>
