How to read and write data in csv files using fputcsv() function in PHP,

How to read and write data in csv files using fputcsv() function in PHP, _PHP tutorial

WBOY

Release： 2016-07-13 10:10:12

Original

763 people have browsed it

PHP uses the fputcsv() function to read and write data from csv files,

The example in this article describes how PHP uses the fputcsv() function to read and write data from a csv file. Share it with everyone for your reference. The specific analysis is as follows:

The fputcsv() function is used to format data into csv format for writing to files or databases.

1. Write the string into the csv file , the code is as follows:

Copy code The code is as follows:

$test_array = array(
array("111","sdfsd","sdds","43344","rrrr"),
Array("sssssssss","gdfgfd","232323","wwewe","dsfds"),
array("fgfg","e4343","dsfds","w2332","xcvxc"),
array("11212","2323","344343","344343","rerreer"),
array("fds","43344444","33333333","ttttttt","gggggggggggg"),
array("kdfs","dsfdsfds","wewewe","sdsdddddddd","wwwwwwwwwww")
);

$file = fopen("test.csv","w") or die("Can't Open test.csv");
foreach($test_array as $line_array)
{
$isSuccess = fputcsv($file,$line_array);
Print $isSuccess."
";
if($isSuccess===false)
{
die("Can't write csv line".$line_array);
}
}
fclose($file) or die("Can't close file test.csv.");

The fputcsv() function returns the number of characters in the written line or false. When the writing fails, it returns false.

2. Save the formatted csv string into string , the code is as follows:

Copy code The code is as follows:

$test_array = array(
array("111","sdfsd","sdds","43344","rrrr"),
         array("sssssssss","gdfgfd","232323","wwewe","dsfds"),
array("fgfg","e4343","dsfds","w2332","xcvxc"),
array("11212","2323","344343","344343","rerreer"),
array("fds","43344444","33333333","ttttttt","gggggggggggg"),
array("kdfs","dsfdsfds","wewewe","sdsdddddddd","wwwwwwwwwww")
);
ob_start();
$file = fopen("php://output","w") or die("Can't Open php://output");
foreach($test_array as $line_array)
{
          $isSuccess = fputcsv($file,$line_array);
           if($isSuccess===false)
                                                                                              die("Can't write csv line".$line_array);
          }
}
fclose($file) or die("Can't close file test.csv.");

$result = ob_get_contents();
ob_end_clean();

Use the fgetcsv(file, length, separator, enclosure) function to read the csv file.

The parameter description of fgetcsv is as follows:

file: csv file to be read, this parameter is required.

length: represents a value greater than the length of the longest line in the csv file. It is a required parameter before php5. It is an optional parameter in php5. If this parameter is not set or set to 0, php will read it.

A whole row of data. If the length of the line exceeds 8192 bytes, the length value should be set to a number instead of letting PHP automatically calculate the length of the line.

separator: specifies the separator of data, the default is comma, if specified as ";", then the fgetcsv function will parse the row data according to ";".

Return value of fgetcsv:

Returns an array based on a row of data in file. If there is an error reading the file, false is returned. When the end of the file is reached, false is also returned.

The following is an example of reading the test.csv file:

Copy code The code is as follows:

$file = fopen('test.csv','r') or die("Can't open file test.csv");
$color="#ff0000";
print '';
while($csv_line=fgetcsv($file))
{
        print "";
        $len = count($csv_line);
        for($i=0;$i<$len;$i++)
        {
            if($i%2==0)$color="#cccccc";
            else $color="#999999";
            print '';
        }
        print "";
}
print '

'.htmlentities($csv_line[$i]).'

';
fclose($file) or die("Can't close file test.csv!");

希望本文所述对大家的php程序设计有所帮助。