prepare("SELECT qr_code_image FROM bank_details WHERE environment = ?");
$stmt->execute([$environment]);
$current = $stmt->fetch(PDO::FETCH_ASSOC);
if ($current) {
$qr_code_image = $current['qr_code_image'];
}
if (isset($_FILES['qr_code_image']) && $_FILES['qr_code_image']['error'] === UPLOAD_ERR_OK) {
$upload_result = uploadFile($_FILES['qr_code_image'], 'img/');
if ($upload_result['success']) {
// Delete old QR code
if ($qr_code_image && file_exists('../img/' . $qr_code_image)) {
unlink('../img/' . $qr_code_image);
}
$qr_code_image = $upload_result['filename'];
} else {
$error = $upload_result['message'];
logError($error);
}
}
if (empty($error)) {
// Check if record exists
if ($current) {
$stmt = $pdo->prepare("UPDATE bank_details SET bank_name = ?, account_name = ?, account_number = ?, ifsc_code = ?, qr_code_image = ? WHERE environment = ?");
$result = $stmt->execute([$bank_name, $account_name, $account_number, $ifsc_code, $qr_code_image, $environment]);
} else {
$stmt = $pdo->prepare("INSERT INTO bank_details (environment, bank_name, account_name, account_number, ifsc_code, qr_code_image) VALUES (?, ?, ?, ?, ?, ?)");
$result = $stmt->execute([$environment, $bank_name, $account_name, $account_number, $ifsc_code, $qr_code_image]);
}
if ($result) {
$success = 'Bank details updated successfully.';
header("Location: bank-details.php?success=" . urlencode($success));
exit;
} else {
$error = 'Error updating bank details.';
logError($error);
}
}
}
} catch (PDOException $e) {
$error = 'Database error: ' . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8');
logError($error);
}
}
}
// Get bank details
try {
$stmt = $pdo->query("SELECT * FROM bank_details ORDER BY environment");
$bank_details = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$error = 'Database error: ' . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8');
logError($error);
$bank_details = [];
}
// Convert to associative array for easier access
$bank_data = [];
foreach ($bank_details as $detail) {
$bank_data[$detail['environment']] = $detail;
}
// $pageTitle = 'Bank Details Management';
include 'includes/header.php';
?>
-
-