.-.-.-.-.-

<?php
$title = "purchase product";
include 'header.php';
?>

<div class="container-fluid">
    <?php getMessage();
    ?>
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Product Purchase</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Inventory</a></li>
                    <li class="breadcrumb-item active">Product Purchase</li>
                </ol>
            </div>
        </div>
    </div>
    
    <div class="row">
        <div class="col-12">
            <div class="card m-b-20">
                <div class="card-body">
                    <form action="inventory.php" 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">

<select class="custom-select" name="pid" id="pid" onchange="" required="required">
                                    <option value="" disabled="disabled" selected="selected">-- Select Account Type --</option>
                                    <option <?php
    $rs = mysqli_query($connection, "select pid, pcode, pname from product order by pname");
    echo "<option value=''>--------Select Product-----------</option>";
    while ($row = mysqli_fetch_array($rs)) {
        echo "<option value=" . $row['pid'] . ">" . $row['pid'] . " " . $row['pcode'] . " - " . $row['pname'] . "</option>";
    }
    ?></option>
                                </select> 
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="quantity">Quantity </label>
                            <div class="col-sm-10">
                                <input class="form-control"  type="text" name="quantity" id="quanty" size="5" required="required"  >
                            </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
if (isset($_POST['submit'])) {

$dates = date("Y-m-d");
//$rs=mysqli_query($connection, "select quantity from product where pcode='".$_POST['pcode']."'");
//$row=mysqli_fetch_array($rs);
//$q=$row['quantity']+$_POST['quantity'];
    $qty = $_POST['quantity'];
    mysqli_query($connection, "update product set quantity= quantity + $qty, date='" . $dates . "' where pid='" . $_POST['pid'] . "'");
    if (mysqli_affected_rows($connection) > 0) {
        setMessage('update Successfully', 'alert-success');
//        echo "Update Successfully";
    } else {
        echo "Try again";
    }
}
?>
<?php
include('footer.php');
?>

/home2/wtmwscom/public_html/admin/images/.././inventory.php