| Como automatizar el INSERT en php?
hola salu2 foreros:
Tengo un programita q hace lo siguiente; abre un archivo .csv lo lee e inserta en mysql los datos de 5 campos separados por ",", en problema q tengo es q solo lo hago con un dummy de 5 renglones, si al archivo le pongo 2000 archivos no los inserta y pues no se como hacerle para no tener q ponerlos a mano. mi pregunta es como le puedo hacer para que este mismo pueda meter +de los 5 q tiene, aqui les dejo el codigo:
Código:
<?php
$conexion = mysql_connect('localhost', 'root', '*******')
or die ('No puedo conectar con la base de datos por que: '. mysql_error());
mysql_select_db("test",$conexion);
$row = 1;
$fp = fopen ("dummy.csv","r");
while ($data = fgetcsv ($fp, 1000, ","))
{
$num = count ($data);
print " <br>";
$row++;
echo "$row.". $data[0]." ------------ ".$data[1]."-------".$data[2]."--------".$data[3]."--------".$data[4];
$insertar="INSERT INTO dummy (id_dummy, name, firstname, lastname, born_date) VALUES ('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')";
mysql_query($insertar);
}
fclose ($fp);
?>
el csv seria mas o menos asi
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
1,2,3,4,1979-12-06
11,12,13,14,1979-12-06
21,22,23,24,1979-12-06
31,32,33,34,1979-12-06
41,42,43,44,1979-12-06
51,52,53,54,1979/10/06
salu2 |