.-.-.-.-.-

<?php
$title= "create product";
include 'header.php';
//        include 'connection.php';;
?>

<div class="container-fluid">
<?php getMessage();
?>
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Change Password</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" 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" size="40" 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" 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="hsn_code" id="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
if(isset($_POST['submit']))
{
//move_uploaded_file($_FILES["file"]["tmp_name"], "p_upload/" . $_FILES["file"]["name"]);
     //$path= "p_upload/" . $_FILES["file"]["name"];
     $pv=$_POST['mrp']-$_POST['pcost'];
     if($pv<0)
     {
     $pv=0;
     }
     
 mysqli_query($connection, "INSERT INTO `product`( `pcode`, `pname`, `mrp`, `pv`, `pcost`,`tax_rate`,`sgst`,`hsn_code`) VALUES ('".$_POST['pcode']."','".$_POST['pname']."','".$_POST['mrp']."','".$_POST['pv']."','".$_POST['pcost']."','".$_POST['tax_rate']."','".$_POST['sgst']."','".$_POST['hsn_code']."')");    
   if(mysqli_affected_rows($connection)>0)
   {
    echo "Successfully Insert";
     setMessage('Successfully Insert', 'alert-success');
   } 
   else
   {
   echo "Try again";
  setMessage('Try again', 'alert-error');
   } 
     
}
?>
<?php
include('footer.php');
?>

/home2/wtmwscom/public_html/static/../DOCS/assets/../../admin/create_product.php