|
Познавший АНТИЧАТ
Регистрация: 27.04.2007
Сообщений: 1,044
С нами:
10021597
Репутация:
905
|
|
PHP код:
<?php
$str = "INSERT INTO table VALUES (157463,'Akartal','abab01@freemail.hu','2d3d0314c867d1d2e542656bd61f4777','','2007-03-24 15:11:02',0,'2007-05-30 18:29:02',4,0,1,NULL,NULL),(157464,'acmanrs','acman_emailit@yahoo.com','7a2b34dc952ab2cb0c2d82aca3f3615e','-6118153180.828977724139197','2007-03-24 15:11:51',0,NULL,4,0,1,NULL,NULL),(157465,'elefant ezinho','mafaldavieira10@msn.com','f7236291359919691fa0f8d007c23989','','2007-03-24 15:15:23',0,'2007-05-30 18:29:02',4,0,1,NULL,NULL)";
preg_match_all ('/^insert\s+into+.+?values\s*(\(.*\))/i', $str, $m);
preg_match_all ('/\((.*?)\)/', $m[1][0], $m);
foreach ($m[1] as $line) {
preg_match ("/^\d+,\s*'(.*?)',\s*'(.*?)',\s*'([0-9a-f]{32})'/", $line, $mm);
echo $mm[1], ';', $mm[2], ';', $mm[3], "\n";
}
?>
Вывод
Код:
Akartal;abab01@freemail.hu;2d3d0314c867d1d2e542656bd61f4777
acmanrs;acman_emailit@yahoo.com;7a2b34dc952ab2cb0c2d82aca3f3615e
elefant ezinho;mafaldavieira10@msn.com;f7236291359919691fa0f8d007c23989
|