28,’ad’=>24,’at’=>20,’az’=>28,’bh’=>22,’be’=>16,’ba’=>20,’br’=>29,’bg’=>22,’cr’=>21,’hr’=>21,’cy’=>28,’cz’=>24,’dk’=>18,’do’=>28,’ee’=>20,’fo’=>18,’fi’=>18,’fr’=>27,’ge’=>22,’de’=>22,’gi’=>23,’gr’=>27,’gl’=>18,’gt’=>28,’hu’=>28,’is’=>26,’ie’=>22,’il’=>23,’it’=>27,’jo’=>30,’kz’=>20,’kw’=>30,’lv’=>21,’lb’=>28,’li’=>21,’lt’=>20,’lu’=>20,’mk’=>19,’mt’=>31,’mr’=>27,’mu’=>30,’mc’=>27,’md’=>24,’me’=>22,’nl’=>18,’no’=>15,’pk’=>24,’ps’=>29,’pl’=>28,’pt’=>25,’qa’=>29,’ro’=>24,’sm’=>27,’sa’=>24,’rs’=>22,’sk’=>24,’si’=>19,’es’=>24,’se’=>24,’ch’=>21,’tn’=>24,’tr’=>26,’ae’=>23,’gb’=>22,’vg’=>24);
$Chars = array(‘a’=>10,’b’=>11,’c’=>12,’d’=>13,’e’=>14,’f’=>15,’g’=>16,’h’=>17,’i’=>18,’j’=>19,’k’=>20,’l’=>21,’m’=>22,’n’=>23,’o’=>24,’p’=>25,’q’=>26,’r’=>27,’s’=>28,’t’=>29,’u’=>30,’v’=>31,’w’=>32,’x’=>33,’y’=>34,’z’=>35);
if(strlen($ibanverif) == $Countries[substr($ibanverif,0,2)])
{
$MovedChar = substr($iban, 4).substr($iban,0,4);
$MovedCharArray = str_split($MovedChar);
$NewString = «  »;
foreach($MovedCharArray AS $key => $value)
{
if(!is_numeric($MovedCharArray[$key]))
{$MovedCharArray[$key] = $Chars[$MovedCharArray[$key]];}
$NewString .= $MovedCharArray[$key];
}
$modulo = bcmod($NewString, ’97’);
if(bcmod($NewString, ’97’) == 76){echo ‘IBAN VALIDE‘;}
else{echo ‘IBAN NON VALIDE, retour page precedante dans 5 secondes‘;
header(« refresh:5;url=/formulaire-sepa-institut »);}
}
else {echo ‘IBAN Pas bon, recontrôlez le nombre de caracteres, retour page precedante dans 5 secondes‘;
header(« refresh:5;url=/formulaire-sepa-institut »);}

global $wpdb;
$wpdb->query( $wpdb->prepare(« INSERT INTO wp_banque ( id, nomprenom, rum, numero_dossier, iban, bic, valide ) VALUES ( », ‘$Nomprenom’,’$RUM’,’$numeroclient’,’$iban’,’$bic’, ‘1’); ») );
$wpdb->query( $wpdb->prepare(« DELETE FROM wp_banque WHERE numero_dossier= »; ») );
$wpdb->query( $wpdb->prepare(« DELETE t1 FROM wp_banque AS t1, wp_banque AS t2 WHERE t1.id < t2.id AND t1.rum = t2.rum AND t1.numero_dossier = t2.numero_dossier AND t1.iban = t2.iban AND t1.bic = t2.bic AND t1.valide = t2.valide;") ); } ?>

Numéro dossier :
 » />
Numéro RUM :
 » />
Numéro IBAN (27 numéros) :
 » />
BIC (8 ou 11 caractères) :
 » />