Zeltlager/Sicherung_Zeltlageranmeldung/getBIC.php

20 lines
442 B
PHP

<?php
require_once($_SERVER['DOCUMENT_ROOT'].'db.php');
$iban = $_GET["iban"];
$iban = strtolower(str_replace(' ','',$iban));
$blzfromiban= substr ($iban,4,8);
$blzfromiban = preg_replace('![^0-9]!', '', $blzfromiban);
$mydb = new DB_MySQL();
$mydb->query("SELECT * FROM `VerwaltungBankdaten` WHERE `blz` = '$blzfromiban' ");
$row = $mydb->fetchRow();
$bic = utf8_encode($row['bic']);
$mydb->disconnect();
echo $bic;
?>