PHP - Function fgetcsv()


Advertisements


Syntax

array fgetcsv ( resource $handle [, int $length [, string $delimiter 
   [, string $enclosure [, string $escape]]]] );

Definition and Usage

Similar to fgets() except that fgetcsv() parses the line it reads for fields in CSV format and returns an array containing the fields read.

Parameters

Sr.No Parameter & Description
1

handle

A valid file pointer to a file successfully opened by fopen(), popen(), or fsockopen().

2

length

Must be greater than the longest line.

3

delimiter

Set the field delimiter (one character only). Defaults as a comma.

4

enclosure

Set the field enclosure character (one character only). Defaults as a double quotation mark.

5

escape

Set the escape character (one character only). Defaults as a backslash (\)

Return Value

Returns an indexed array containing the fields read.

Example

Following is the usage of this function −

<?php
   row = 1;
   $handle = fopen("test.csv", "r");
   
   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);
?>

php_function_reference.htm