<?
$texto="
INSERT INTO `records` VALUES (8725194, 32, '38.2821632', '-0.7180091', '165', '2014-07-21', '07:08:20', '0', '12', '0', '1', '28', '382821632', '-7180091', '09:07:46', '0', '0', '0', 9);
INSERT INTO `records` VALUES (8725195, 32, '38.2823232', '-0.7176723', '165', '2014-07-21', '07:09:18', '0', '12', '0', '0', '2', '382823232', '-7176723', '09:07:46', '0', '0', '0', 9);
INSERT INTO `records` VALUES (8725196, 32, '38.2823232', '-0.7176723', '165', '2014-07-21', '07:09:19', '0', '13', '0', '1', '0', '382823232', '-7176723', '09:07:46', '0', '0', '0', 9);
INSERT INTO `records` VALUES (8725197, 32, '38.2823232', '-0.7176723', '165', '2014-07-21', '07:09:23', '0', '13', '0', '0', '0', '382823232', '-7176723', '09:07:46', '0', '0', '0', 9);
";
$vector=explode(";",$texto);
for ($i=0;$i<sizeof($vector);$i++)
{
$vector2=explode(",",$vector[$i]);
echo "INSERT INTO `records` VALUES (null";
for ($j=1;$j<sizeof($vector2);$j++)
{
echo ",".$vector2[$j];
}
echo ";<br>";
}
?>
.
lunes, 21 de julio de 2014
Suscribirse a:
Enviar comentarios (Atom)
Archivo del blog
-
▼
2014
(13)
- ► septiembre (2)
No hay comentarios:
Publicar un comentario