Answers for "convert csv to array php"

PHP
7

read csv php

<?php
$row = 1;
if (($handle = fopen("test.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++) {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}
?>
Posted by: Guest on March-19-2020
2

php read csv to array

$lines =file('CSV Address.csv');

foreach($lines as $data)
{
list($name[],$address[],$status[])
= explode(',',$data);
}
Posted by: Guest on October-30-2020
2

php array to csv

Instead of writing out values consider using 'fputcsv()'.

This may solve your problem immediately.

function array2csv($data, $delimiter = ',', $enclosure = '"', $escape_char = "\\")
{
    $f = fopen('php://memory', 'r+');
    foreach ($data as $item) {
        fputcsv($f, $item, $delimiter, $enclosure, $escape_char);
    }
    rewind($f);
    return stream_get_contents($f);
}

$list = array (
    array('aaa', 'bbb', 'ccc', 'dddd'),
    array('123', '456', '789'),
    array('"aaa"', '"bbb"')
);
var_dump(array2csv($list));

/*
I hope it will help you.
Namaste
Stay Home Stay Safe
*/
Posted by: Guest on May-30-2020
0

csv to array php

$csv = array_map('str_getcsv', file('data.csv'));
Posted by: Guest on April-05-2021
0

php array to 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:
<?php 
  
// 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 ($list as $fields) { 
    fputcsv($fp, $fields); 
} 
  
fclose($fp); 
?>
Posted by: Guest on April-15-2020

Browse Popular Code Answers by Language