1 2 3 4 5 6 7 8
| <?php
$chaine = "INSERT INTO album_stats VALUES(400, 13, 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X; fr-fr) AppleWebKit/412 (KHTML, like Gecko) Safari/412', '81.65.15.195', 2005-12-03, 19:39:49);
INSERT INTO album_stats VALUES(400, 13, 'Mozilla/5.0 (Macintosh; U; PPC Mac OS X; fr-fr) AppleWebKit/412 (KHTML, like Gecko) Safari/412', '81.65.15.195', 2005-12-03, 19:39:49);";
$chaine = preg_replace('# ([0-9]{4}-[0-9]{2}-[0-9]{2})#', "'$1'", $chaine);
$chaine = preg_replace('# ([0-9]{2}:[0-9]{2}:[0-9]{2})#', "'$1'", $chaine);
echo $chaine; |
Partager