<?php
if(isset($_POST['submit']))
{
$company_name = $_POST['company_name'];
$gst = $_POST['gst'];
$ac_name = $_POST['ac_name'];
$bank = $_POST['bank'];
$branch = $_POST['branch'];
$ac_no = $_POST['ac_no'];
$ifsc_code = $_POST['ifsc_code'];
$swift_code = $_POST['swift_code'];
$sqlSubject = mysqli_query ($cn, "update `tbl_home` set `company_name`='".$company_name."', `gst`='".$gst."', `ac_name`='".$ac_name."', `bank`='".$bank."', `branch`='".$branch."', `ac_no`='".$ac_no."', `ifsc_code`='".$ifsc_code."', `swift_code`='".$swift_code."' where `id`='1'");
if ($sqlSubject)
{
echo '<div class="alert alert-success"><strong>Success!</strong> Account Setting Updated Successfully.</div>';
}
else
{
echo '<div class="alert alert-danger"><strong>Danger!</strong> Some Error Occur.Please Try Again Later.</div>';
}
}
$sql = mysqli_query($cn, "select * from tbl_home where id='1'");
$sqlData = mysqli_fetch_array($sql);
?>
<style>
.heading-title{
background: linear-gradient(120deg, #5983e8,#00e4d0);
text-align: center;
color:
white;
padding:10px;
font-size: 15px;
font-weight: 600;
}
</style>
<div class="card">
<h3 class="heading-title">ACCOOUNT SETTINGS</h3>
<div class="card-body">
<form class="forms-sample" method="post" enctype="multipart/form-data">
<div class="row">
<div class="col-md-8">
<div class="form-group">
<label for="exampleInputPassword4"><strong>COMPANY NAME</strong></label>
<input type="text" class="form-control" name="company_name" value="<?php echo $sqlData['company_name'];?>" placeholder="COMPANY NAME">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="exampleInputPassword4"><strong>GST NO.</strong></label>
<input type="text" class="form-control" name="gst" value="<?php echo $sqlData['gst'];?>" placeholder="GST NO.">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="exampleInputPassword4"><strong>A/C HOLDER NAME</strong></label>
<input type="text" class="form-control" name="ac_name" value="<?php echo $sqlData['ac_name'];?>" placeholder="A/C HOLDER NAME">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="exampleInputPassword4"><strong>BANK NAME</strong></label>
<input type="text" class="form-control" name="bank" value="<?php echo $sqlData['bank'];?>" placeholder="BANK NAME">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="exampleInputPassword4"><strong>BRANCH ADDRESS</strong></label>
<input type="text" class="form-control" name="branch" value="<?php echo $sqlData['branch'];?>" placeholder="BRANCH NAME">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="exampleInputPassword4"><strong>ACCOUNT NUMBER</strong></label>
<input type="text" class="form-control" name="ac_no" value="<?php echo $sqlData['ac_no'];?>" placeholder="ACCOUNT NUMBER">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="exampleInputPassword4"><strong>IFSC CODE</strong></label>
<input type="text" class="form-control" name="ifsc_code" value="<?php echo $sqlData['ifsc_code'];?>" placeholder="IFSC CODE">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label for="exampleInputPassword4"><strong>SWIFT CODE</strong></label>
<input type="text" class="form-control" name="swift_code" value="<?php echo $sqlData['swift_code'];?>" placeholder="SWIFT CODE">
</div>
</div>
</div>
<button type="submit" class="btn btn-success mr-2" name="submit">Submit</button>
</form>
</div>
</div>