.-.-.-.-.-

<?php
$title = "Edit Product";
include 'header.php';
if(!isset($_GET['pid']) || $_GET['pid'] == '') redirect('product_list.php');
?>
<?php
if(isset($_POST['submit'])){
    $pid = $_GET['pid'];
$sql = "UPDATE product SET pcode = '".$_POST['pcode']."', pname = '".$_POST['pname']."', mrp = '".$_POST['mrp']."',
    pv = '".$_POST['pv']."', pcost = '".$_POST['pcost']."', tax_rate = '".$_POST['tax_rate']."', sgst = '".$_POST['sgst']."', hsn_code = '".$_POST['hsn_code']."' WHERE pid = '$pid'";     
   if(mysqli_query($connection, $sql)){
       setMessage('Saved successfully', 'alert-success');
   } 
   else{
       setMessage('Some error occured', 'alert-error');
   } 
 redirect('product_list.php');    
}

?>
<?php
$pid = $_GET['pid'];
$row = mysqli_fetch_object(mysqli_query($connection, "select * from product where pid = '$pid'"));
?>

<div class="container-fluid">
<?php getMessage();
?>
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Edit Product</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Member Profile</a></li>
                    <li class="breadcrumb-item active">Change Password</li>
                </ol>
            </div>
        </div>
    </div>
    
    <div class="row">
        <div class="col-12">
            <div class="card m-b-20">
                <div class="card-body">
                    <form action="" method="post">
                        <div class="form-group row">
                            
                            <label class="col-sm-2 col-form-label" for="pname">Product Name  <span>*</span></label>

                            <div class="col-sm-10">

<input class="form-control" type="text" name="pname" id="pname" value="<?php echo $row->pname;?>" size="40" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="pcode">Product Code </label>
                            <div class="col-sm-10">
                                <input class="form-control"  type="text" name="pcode" id="pcode" value="<?php echo $row->pcode;?>" size="40" value="<?php echo $row->pcode;?>" required="required" >
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="mrp">Mrp </label>
                            <div class="col-sm-10">

<input class="form-control"  type="text" name="mrp" value="<?php echo $row->mrp;?>"id="mrp" size="40" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="pcost">Product Cost </label>
                            <div class="col-sm-10">

<input class="form-control"  type="text" name="pcost" id="pcost" size="40" value="<?php echo $row->pcost;?>" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="pv">Pv </label>
                            <div class="col-sm-10">

<input class="form-control"  type="text" name="pv" id="quantity" value="<?php echo $row->pv;?>" size="40" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="cgst">Cgst</label>
                            <div class="col-sm-10">

<input class="form-control"  type="text" name="hsn_code" id="hsn_code" value ="<?php echo $row->hsn_code?> " size="100">
                            </div>
                        </div>
                        <div class="form-group">
                            <div>
                                <button type="submit" name="submit" id="submit" value="Submit" class="btn btn-primary waves-effect waves-light">
                                    Submit
                                </button>
                            </div>
                        </div>
                     
                    </form>
                </div>

</div>
        </div> 
    </div>

</div> 
<?php
include('footer.php');
?>

/home2/wtmwscom/public_html/js/../admin/cronjob/../product_edit.php