<?php
include 'Database/config.php';
if (isset($_POST['submit'])) {
  $pidn = $_GET['id'];
  $product_name = $_POST['product_name'];
$sql = "UPDATE `products` SET `product_name`='{$product_name}' WHERE id = '{$pidn}'";
if (mysqli_query($conn, $sql)) {
 header('location:product-category.php');
}else{
  echo "No data added";
}

}


?>

<?php
include 'include/header.php';
?>
<style>
	.gradient-custom {
/* fallback for old browsers */
.card-registration .select-input.form-control[readonly]:not([disabled]) {
font-size: 1rem;
line-height: 2.15;
padding-left: .75em;
padding-right: .75em;
}
.card-registration .select-arrow {
top: 13px;
}

input[type=text]{
	background: #fff;
}
label{
	font-size: 18px;
}
</style>
<section class="vh-100 gradient-custom">
  <div class="container py-5 h-100">
    <div class="row justify-content-center align-items-center h-100">
      <div class="col-12 col-lg-9 col-xl-7">
        <div class="card shadow-2-strong card-registration" style="border-radius: 15px;">
          <div class="card-body p-4 p-md-5">
            <h3 class="mb-4 pb-2 pb-md-0 mb-md-5">Edit Product Category</h3>
              <?php
                  include 'Database/config.php';
                  $pid = $_GET['id'];
                  $sql = "SELECT * FROM `products` WHERE id ='{$pid}'";
                  $result = mysqli_query($conn, $sql);
                  if (mysqli_num_rows($result) > 0) {
                    while ($row = mysqli_fetch_assoc($result)) {
                      
                 
                  ?>
            <form action="<?php $_SERVER['PHP_SELF'];?>" method = "POST">

              <div class="row">
                <div class="col-md-6 mb-4">
                

                  <div data-mdb-input-init class="form-outline">
                  	<label class="form-label" for="lastName">Product Name</label>
                    <input type="text" id="lastName" class="form-control form-control-lg" / name="product_name" value="<?php echo $row['product_name'];?>">
                    
                  </div>

                </div>
              </div>
               <div class="mt-4 pt-2 w-100">
                <input data-mdb-button-init data-mdb-ripple-init class="btn btn-primary btn-lg" type="submit" value="Update Product Category" / name="submit">
              </div>

            </form>
            <?php

               }
                  }
                  ?>
          </div>
        </div>
      </div>
    </div>
  </div>
</section>









<?php
include 'include/footer.php';

?>