</nav>
            <br>
<div class="section">
    <div class="container">
        <div class="row">
            <div class="col-md-12" align="center">
                <h1 style="color:Salmon ;font-style: oblique;">Edit Product</h1>
                </div>
                 <?php 
echo '<form role="form" action="../models/editProduct.php?id=' . $_GET['id'] . '" method="post" enctype="multipart/form-data">';
echo "<div class='form-group'>";
require_once "../controllers/DbConnection.php";
require_once "../controllers/Product.php";
require_once "../controllers/Category.php";
$pro = new Product(DbConnection::getConnection());
$result = $pro->Search_product($_GET['id']);
if ($result->num_rows == 1) {
    // output data of each row
    while ($row = $result->fetch_assoc()) {
        // echo "<option value='".$row["ctg_id"]."'>".$row["ctg_name"]."</option>";
        echo "<label class='control-label' >Product</label>";
        echo "<input class='form-control' id='product' value='" . $row["p_name"] . "'\n                               type='text' name='p_name'>";
        echo "</div>";
        echo "<div class='form-group'>";
        echo " <label class='control-label'>Price</label>";
        echo "<input class='form-control' id='price' type='number' min='0'\n                               value='" . $row["u_price"] . "' name='u_price'>";
    }
}
echo "</div>";
echo "<div class='form-group'>\n                        <a href='../views/Add_Category.html' class='pull-right'>Add Category</a>\n                        <label class='control-label' for='category'>Category</label>\n                        <select name='ctg_id' class='form-control' id='category' >\n                            <option value='' selected=''>Select Category</option>\n                          ";
$pro = new Category(DbConnection::getConnection());