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