Saltar al contenido

php convertir csv a array ejemplo de código

Ejemplo 1: php lee csv para array

$lines=file('CSV Address.csv');foreach($linesas$data)list($name[],$address[],$status[])=explode(',',$data);

Ejemplo 2: leer csv php

$row=1;if(($handle=fopen("test.csv","r"))!==FALSE)while(($data=fgetcsv($handle,1000,","))!==FALSE)$num=count($data);echo"

$num fields in line $row:

n"
;$row++;for($c=0;$c<$num;$c++)echo$data[$c]."
n"
;fclose($handle);?>

Ejemplo 3: php array a csv string

To convert an array into a CSV file we can use fputcsv() function. The fputcsv() function is used to format a line as CSV (comma separated values) file and writes it to an open file. The file which has to be read and the fields are sent as parameters to the fputcsv() function and it returns the length of the written string on success or FALSE on failure.

Syntax :

fputcsv( file, fields, separator, enclosure, escape )
  
Example:
// Create an array of elements $list=array(['Name','age','Gender'],['Bob',20,'Male'],['John',25,'Male'],['Jessica',30,'Female']);// Open a file in write mode ('w') $fp=fopen('persons.csv','w');// Loop through file pointer and a line foreach($listas$fields)fputcsv($fp,$fields);fclose($fp);?>

Ejemplo 4: php csv

// output headers so that the file is downloaded rather than displayedheader('Content-Type: text/csv; charset=utf-8');header('Content-Disposition: attachment; filename=data.csv');// create a file pointer connected to the output stream$output=fopen('php://output','w');// output the column headingsfputcsv($output,array('Column 1','Column 2','Column 3'));// fetch the datamysql_connect('localhost','username','password');mysql_select_db('database');$rows=mysql_query('SELECT field1,field2,field3 FROM table');// loop over the rows, outputting themwhile($row=mysql_fetch_assoc($rows))fputcsv($output,$row);

Aquí puedes ver las reseñas y valoraciones de los lectores

¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)



Utiliza Nuestro Buscador

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *