/
home
/
u718748226
/
domains
/
saraswatihousingco.com
/
public_html
/
admin
/
Upload File
HOME
<?php session_start(); require("config.php"); if(!isset($_SESSION['auser'])) { header("location:index.php"); } ///code $error=""; $msg=""; if(isset($_POST['insert'])) { $bkid = $_GET['id']; $name=$_POST['name']; $acc_number=$_POST['acc_number']; $bank_branch=$_POST['bank_branch']; $bank_address=$_POST['bank_address']; $ifsc=$_POST['ifsc']; $account_type=$_POST['account_type']; $remarks=$_POST['remarks']; if(!empty($name)){ $sql="UPDATE bank_type SET bank_name = '{$name}',acc_number = '{$acc_number}',bank_branch = '{$bank_branch}',bank_address = '{$bank_address}',ifsc = '{$ifsc}',account_type = '{$account_type}',remarks = '{$remarks}' WHERE bkid = {$bkid}"; $result=mysqli_query($con,$sql); if($result) { $msg="<p class='alert alert-success'>Bank Details Updated Successfully</p>"; header("Refresh: 5; URL=bank_type.php"); } else { $error="<p class='alert alert-warning'>* Bank Details Not Updated</p>"; } } else{ $error = "<p class='alert alert-warning'>* Fill all the Fields</p>"; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0"> <title>SRHousing - Bank Types</title> <!-- Favicon --> <link rel="shortcut icon" type="image/x-icon" href="assets/img/favicon.png"> <!-- Bootstrap CSS --> <link rel="stylesheet" href="assets/css/bootstrap.min.css"> <!-- Fontawesome CSS --> <link rel="stylesheet" href="assets/css/font-awesome.min.css"> <!-- Feathericon CSS --> <link rel="stylesheet" href="assets/css/feathericon.min.css"> <!-- Datatables CSS --> <link rel="stylesheet" href="assets/plugins/datatables/dataTables.bootstrap4.min.css"> <link rel="stylesheet" href="assets/plugins/datatables/responsive.bootstrap4.min.css"> <link rel="stylesheet" href="assets/plugins/datatables/select.bootstrap4.min.css"> <link rel="stylesheet" href="assets/plugins/datatables/buttons.bootstrap4.min.css"> <!-- Main CSS --> <link rel="stylesheet" href="assets/css/style.css"> <!--[if lt IE 9]> <script src="assets/js/html5shiv.min.js"></script> <script src="assets/js/respond.min.js"></script> <![endif]--> </head> <body> <!-- Main Wrapper --> <!-- Header --> <?php include("header.php");?> <!-- /Sidebar --> <!-- Page Wrapper --> <div class="page-wrapper"> <div class="content container-fluid"> <!-- Page Header --> <div class="page-header"> <div class="row"> <div class="col"> <h3 class="page-title">Bank Details</h3> <ul class="breadcrumb"> <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li> <li class="breadcrumb-item active">Bank </li> </ul> </div> </div> </div> <!-- /Page Header --> <!-- Bank add section --> <div class="row"> <div class="col-md-12"> <div class="card"> <div class="card-header"> <h1 class="card-title">Edit Bank Details</h1> <?php echo $error;?> <?php echo $msg;?> <?php if(isset($_GET['msg'])) echo $_GET['msg']; ?> </div> <?php $bkid = $_GET['id']; $sql = "SELECT * FROM bank_type where bkid = {$bkid}"; $result = mysqli_query($con, $sql); while($row = mysqli_fetch_row($result)) { ?> <form method="post" id="insert product" enc="multipart/form-data"> <div class="card-body"> <h5 class="card-title">Bank Details</h5> <div class="row"> <div class="col-xl-3"> <div class="form-group row"> <label class="col-lg-3 col-form-label">Bank Name</label> <div class="col-lg-9"> <input type="text" class="form-control" name="name" value="<?php echo $row['1']; ?>"> </div> </div> </div> <div class="col-xl-3"> <div class="form-group row"> <label class="col-lg-4 col-form-label">Account No.</label> <div class="col-lg-8"> <input type="text" class="form-control" name="acc_number" value="<?php echo $row['2']; ?>"> </div> </div> </div> <div class="col-xl-3"> <div class="form-group row"> <label class="col-lg-4 col-form-label">Account Type</label> <div class="col-lg-8"> <select class="form-control" name="account_type" id="account_type"> <option value="">Select</option> <option value="SAVINGS" class="text-captalize" <?php if("SAVINGS" == $row['6']){?> selected="selected" <?php } ?>>SAVINGS</option> <option value="CURRENT" class="text-captalize" <?php if("CURRENT" == $row['6']){?> selected="selected" <?php } ?>>CURRENT</option> </select> </div> </div> </div> <div class="col-xl-3"> <div class="form-group row"> <label class="col-lg-3 col-form-label">Bank Address</label> <div class="col-lg-9"> <textarea id="bank_address" name="bank_address" class="form-control" rows="4" cols="150"><?php echo $row['4']; ?></textarea> </div> </div> </div> </div> <div class="row"> <div class="col-xl-3"> <div class="form-group row"> <label class="col-lg-4 col-form-label">Bank Branch</label> <div class="col-lg-8"> <input type="text" class="form-control" name="bank_branch" value="<?php echo $row['3']; ?>"> </div> </div> </div> <div class="col-xl-3"> <div class="form-group row"> <label class="col-lg-3 col-form-label">Bank IFSC</label> <div class="col-lg-9"> <input type="text" class="form-control" name="ifsc" value="<?php echo $row['5']; ?>"> </div> </div> </div> <div class="col-xl-6"> <div class="form-group row"> <label class="col-lg-3 col-form-label">Remarks</label> <div class="col-lg-9"> <textarea id="remarks" name="remarks" class="form-control" rows="4" cols="150"><?php echo $row['7']; ?></textarea> </div> </div> </div> </div> <div class="text-left"> <input type="submit" class="btn btn-primary" value="Submit" name="insert" style="margin-left:200px;"> </div> </div> </form> <?php } ?> </div> </div> </div> <!----End Bank add section ---> <!----view Bank ---> <!-- view Bank --> </div> </div> <!-- /Main Wrapper --> <!--- <label class="col-lg-3 col-form-label">State Name</label> <div class="col-lg-9"> <select class="form-control"> <option>Select</option> <option>Option 1</option> <option>Option 2</option> <option>Option 3</option> <option>Option 4</option> <option>Option 5</option> </select> </div> ----> <!-- jQuery --> <script src="assets/js/jquery-3.2.1.min.js"></script> <!-- Bootstrap Core JS --> <script src="assets/js/popper.min.js"></script> <script src="assets/js/bootstrap.min.js"></script> <!-- Slimscroll JS --> <script src="assets/plugins/slimscroll/jquery.slimscroll.min.js"></script> <!-- Datatables JS --> <!-- Datatables JS --> <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script> <script src="assets/plugins/datatables/dataTables.bootstrap4.min.js"></script> <script src="assets/plugins/datatables/dataTables.responsive.min.js"></script> <script src="assets/plugins/datatables/responsive.bootstrap4.min.js"></script> <script src="assets/plugins/datatables/dataTables.select.min.js"></script> <script src="assets/plugins/datatables/dataTables.buttons.min.js"></script> <script src="assets/plugins/datatables/buttons.bootstrap4.min.js"></script> <script src="assets/plugins/datatables/buttons.html5.min.js"></script> <script src="assets/plugins/datatables/buttons.flash.min.js"></script> <script src="assets/plugins/datatables/buttons.print.min.js"></script> <!-- Custom JS --> <script src="assets/js/script.js"></script> </body> </html>
