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());
$result = $pro->select_categories();
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
echo "<option value='" . $row["ctg_id"] . "'>" . $row["ctg_name"] . "</option>";
}
} else {
echo "0 results";
}
echo "</select>";
echo " <div >";
echo " <label class='control-label'>Select Image</label>";
echo "<input name='p_img' type='file' class='control-label' id='img'>";
echo "</div>";
echo "<br/>";
echo " <br/>";
