3v4l.org

run code in 300+ PHP versions simultaneously
<?php $text = 'NL91 RABO 0157 8094 63 4837 NL78 RABO 0135 0695 99 4829 NL39 RBRB 0827 4287 31 4823 NL63 RABO 0151 5685 02 4825 NL77 RABO 0151 8976 62 4935 NL24 RABO 0159 7351 49 4819 NL75 RABO 0128 6474 77 4821 NL69 DEUT 0540 7045 98 4815 NL49 RABO 0129 6430 68 4827 NL92 RABO 0166 3531 08 4831 NL86 RABO 0183 6005 92 5521 NL38 INGB 0007525857 5901'; $lines = explode(PHP_EOL, $text); foreach($lines as $line){ list($iban, $klantid)=explode("\t", $line); $iban = str_replace(' ', '', $iban); //echo "select * from klanten WHERE klantid='".$klantid."' and REPLACE(iban, ' ', '') = '".$iban."';".PHP_EOL; echo "UPDATE klanten SET iban='' WHERE klantid='".$klantid."' and REPLACE(iban, ' ', '') = '".$iban."';".PHP_EOL; }
Output for 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6
UPDATE klanten SET iban='' WHERE klantid='4837' and REPLACE(iban, ' ', '') = 'NL91RABO0157809463'; UPDATE klanten SET iban='' WHERE klantid='4829' and REPLACE(iban, ' ', '') = 'NL78RABO0135069599'; UPDATE klanten SET iban='' WHERE klantid='4823' and REPLACE(iban, ' ', '') = 'NL39RBRB0827428731'; UPDATE klanten SET iban='' WHERE klantid='4825' and REPLACE(iban, ' ', '') = 'NL63RABO0151568502'; UPDATE klanten SET iban='' WHERE klantid='4935' and REPLACE(iban, ' ', '') = 'NL77RABO0151897662'; UPDATE klanten SET iban='' WHERE klantid='4819' and REPLACE(iban, ' ', '') = 'NL24RABO0159735149'; UPDATE klanten SET iban='' WHERE klantid='4821' and REPLACE(iban, ' ', '') = 'NL75RABO0128647477'; UPDATE klanten SET iban='' WHERE klantid='4815' and REPLACE(iban, ' ', '') = 'NL69DEUT0540704598'; UPDATE klanten SET iban='' WHERE klantid='4827' and REPLACE(iban, ' ', '') = 'NL49RABO0129643068'; UPDATE klanten SET iban='' WHERE klantid='4831' and REPLACE(iban, ' ', '') = 'NL92RABO0166353108'; UPDATE klanten SET iban='' WHERE klantid='5521' and REPLACE(iban, ' ', '') = 'NL86RABO0183600592'; UPDATE klanten SET iban='' WHERE klantid='5901' and REPLACE(iban, ' ', '') = 'NL38INGB0007525857';
Output for 8.3.5
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 UPDATE klanten SET iban='' WHERE klantid='4837' and REPLACE(iban, ' ', '') = 'NL91RABO0157809463'; UPDATE klanten SET iban='' WHERE klantid='4829' and REPLACE(iban, ' ', '') = 'NL78RABO0135069599'; UPDATE klanten SET iban='' WHERE klantid='4823' and REPLACE(iban, ' ', '') = 'NL39RBRB0827428731'; UPDATE klanten SET iban='' WHERE klantid='4825' and REPLACE(iban, ' ', '') = 'NL63RABO0151568502'; UPDATE klanten SET iban='' WHERE klantid='4935' and REPLACE(iban, ' ', '') = 'NL77RABO0151897662'; UPDATE klanten SET iban='' WHERE klantid='4819' and REPLACE(iban, ' ', '') = 'NL24RABO0159735149'; UPDATE klanten SET iban='' WHERE klantid='4821' and REPLACE(iban, ' ', '') = 'NL75RABO0128647477'; UPDATE klanten SET iban='' WHERE klantid='4815' and REPLACE(iban, ' ', '') = 'NL69DEUT0540704598'; UPDATE klanten SET iban='' WHERE klantid='4827' and REPLACE(iban, ' ', '') = 'NL49RABO0129643068'; UPDATE klanten SET iban='' WHERE klantid='4831' and REPLACE(iban, ' ', '') = 'NL92RABO0166353108'; UPDATE klanten SET iban='' WHERE klantid='5521' and REPLACE(iban, ' ', '') = 'NL86RABO0183600592'; UPDATE klanten SET iban='' WHERE klantid='5901' and REPLACE(iban, ' ', '') = 'NL38INGB0007525857';
preferences:
252.72 ms | 405 KiB | 288 Q