?????????????? ?????????????? connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } // Handle activation/deactivation if (isset($_GET['activate'])) { $id = intval($_GET['activate']); // Set all accounts inactive, then activate the selected one $mysqli->query("UPDATE bank_accounts SET is_active = 0"); $mysqli->query("UPDATE bank_accounts SET is_active = 1 WHERE id = $id"); header('Location: account.php'); exit; } // Handle new account submission 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 = ''; $logo_image = ''; 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)) { $scanner_image = $target_file; } } 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)) { $logo_image = $target_file; } } if ($is_active) { $mysqli->query("UPDATE bank_accounts SET is_active = 0"); } $stmt = $mysqli->prepare("INSERT INTO bank_accounts (company_name, registered_address, contact, email, logo_image, account_number, account_name, bank_name, ifsc_code, upi_number, scanner_image, is_active) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->bind_param('sssssssssssi', $company_name, $registered_address, $contact, $email, $logo_image, $account_number, $account_name, $bank_name, $ifsc_code, $upi_number, $scanner_image, $is_active); $stmt->execute(); $stmt->close(); echo ''; exit; } // Handle delete if (isset($_GET['delete'])) { $id = intval($_GET['delete']); $acc = $mysqli->query("SELECT scanner_image FROM bank_accounts WHERE id = $id")->fetch_assoc(); if ($acc && !empty($acc['scanner_image']) && file_exists($acc['scanner_image'])) { unlink($acc['scanner_image']); } $mysqli->query("DELETE FROM bank_accounts WHERE id = $id"); echo ''; exit; } // Fetch all accounts $accounts = $mysqli->query("SELECT * FROM bank_accounts ORDER BY is_active DESC, created_at DESC"); $active_account = $mysqli->query("SELECT * FROM bank_accounts WHERE is_active = 1 LIMIT 1")->fetch_assoc(); ?> Bank Accounts | Xcel Training Institute

Add Bank Account

Company Details

Account Details


Make this account active

All Bank Accounts

fetch_assoc()) { ?>
SL No Company Name Account Number Bank Name UPI Number Logo Scanner Image Status Action
Active' : 'Inactive'; ?>