<?php

require_once 'Classes/productTable.php';
require_once 'Classes/Connection.php';
$Connection = Connection::getInstance();
$gateway = new productTable($Connection);
$statement = $gateway->getProduct();
?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>

        <link rel="stylesheet" type="text/css" href="styles/bootstrap.css">
        <link rel="stylesheet" type="text/css" href="styles/Style.css">
    </head>
    <body>
        <div class="table-responsive">
            <table class="table-bordered table-striped table-hover col-lg-11">

                <thead class="thead-inverse">
                    <tr>
                        <th>ID</th>
                        <th>Author Name</th>
                        <th>Book Title</th>
                        <th>Cost Price</th>
                        <th>Sell Price</th>
                        <th>Product Category ID</th>
                    </tr>
                </thead>
<?php

require_once 'Classes/Connection.php';
require_once 'TableGateway.php';
require_once 'Classes/productTable.php';
//
//if (!is_logged_in()) {
//    header("Location: login_form.php");
//}
if (!isset($_GET) || !isset($_GET['id'])) {
    die('Invalid request');
}
$id = $_GET['id'];
$connection = Connection::getInstance();
$categoryGateway = new TableGateway($connection);
$productGateway = new productTable($connection);
$Category = $categoryGateway->getManagerById($id);
$product = $productGateway->getProductsByCategoryID($id);
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">

<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
        <?php 
require 'utils/styles.php';
?>
        <?php