PHP read CSV file line by lines

Question

I have a CSV file loaded from an URL, and I want to loop over the lines with PHP.

Here is a typical line of this CSV:

1004000018;active;"TEST1";"TEST2";"TEST3";"TEST4"  

I would like to get this result, for each row:

1004000018 active TEST1 TEST2 TEST3 TEST4 

Answer 1

You can achieve this using the php function fgetcsv, this should work :

PHP

$file = fopen('file.csv', 'r'); while (($line = fgetcsv($file)) !== FALSE) {    //$line[0] = '1004000018' in first iteration    print_r($line); } fclose($file); 

Answer 2

This will help you for read csv:

   if (($handle = fopen("$source_file", "r")) !== FALSE) {         $columns = fgetcsv($handle, $max_line_length, $delemietr);         if (!$columns) {             $error['message'] = 'Empty';              return ($error);         }          while (($rows = fgetcsv($handle, 10000, "\t")) !== false) {             if ($rows[1] && array(null) !== $rows) { // ignore blank lines                         $data1 = $rows[1];               }             }     }