Edit Bank Account

?????????????? ?????????????? connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $id = isset($_GET['id']) ? intval($_GET['id']) : 0; if ($id <= 0) { echo ''; exit; } // Fetch account $account = $mysqli->query("SELECT * FROM bank_accounts WHERE id = $id")->fetch_assoc(); if (!$account) { echo ''; exit; } // Handle update if ($_SERVER['REQUEST_METHOD'] === 'POST') { $company_name = $mysqli->real_escape_string($_POST['company_name']); $registered_address = $mysqli->real_escape_string($_POST['registered_address']); $contact = $mysqli->real_escape_string($_POST['contact']); $email = $mysqli->real_escape_string($_POST['email']); $account_number = $mysqli->real_escape_string($_POST['account_number']); $account_name = $mysqli->real_escape_string($_POST['account_name']); $bank_name = $mysqli->real_escape_string($_POST['bank_name']); $ifsc_code = $mysqli->real_escape_string($_POST['ifsc_code']); $upi_number = $mysqli->real_escape_string($_POST['upi_number']); $is_active = isset($_POST['is_active']) ? 1 : 0; $scanner_image = $account['scanner_image']; $logo_image = $account['logo_image']; // Only update scanner_image if a new file is uploaded if (isset($_FILES['scanner_image']) && $_FILES['scanner_image']['error'] == 0) { $filename = time() . '_' . basename($_FILES['scanner_image']['name']); $target_dir = 'assets/bank_scanners/'; if (!is_dir($target_dir)) { mkdir($target_dir, 0777, true); } $target_file = $target_dir . $filename; if (move_uploaded_file($_FILES['scanner_image']['tmp_name'], $target_file)) { // Delete old image if (!empty($scanner_image) && file_exists($scanner_image)) { unlink($scanner_image); } $scanner_image = $target_file; } } // else, keep $scanner_image as is // Only update logo_image if a new file is uploaded if (isset($_FILES['logo_image']) && $_FILES['logo_image']['error'] == 0) { $filename = time() . '_' . basename($_FILES['logo_image']['name']); $target_dir = 'assets/'; if (!is_dir($target_dir)) { mkdir($target_dir, 0777, true); } $target_file = $target_dir . $filename; if (move_uploaded_file($_FILES['logo_image']['tmp_name'], $target_file)) { // Delete old image if (!empty($logo_image) && file_exists($logo_image)) { unlink($logo_image); } $logo_image = $target_file; } } // else, keep $logo_image as is if ($is_active) { $mysqli->query("UPDATE bank_accounts SET is_active = 0"); } $stmt = $mysqli->prepare("UPDATE bank_accounts SET company_name=?, registered_address=?, contact=?, email=?, logo_image=?, account_number=?, account_name=?, bank_name=?, ifsc_code=?, upi_number=?, scanner_image=?, is_active=? WHERE id=?"); $stmt->bind_param('sssssssssssii', $company_name, $registered_address, $contact, $email, $logo_image, $account_number, $account_name, $bank_name, $ifsc_code, $upi_number, $scanner_image, $is_active, $id); $stmt->execute(); $stmt->close(); echo ''; exit; } ?> Edit Bank Account | Xcel Training Institute

Company Details

Company Name *

Company Registered Address *

Contact No *

Email Id *

Logo >

Account Number *

Account Name *

Bank Name *

IFSC Code *

UPI Number*

Scanner Image >

Set as Active
> Make this account active

Cancel