lunes, 21 de julio de 2014

MGFLOTAS insertar records con NULL

<?

$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>";
}

?>

















.

No hay comentarios: