PHP CSV Operation class Code

Instructions for use are as follows:

1. Generate a CSV file

require "./include/csvdatafile.php"; Set_time_limit (+); Header (" content-type:application/rfc822 "); Header (' content-disposition:attachment; Filename=export.csv '); $arr _export_titles = Array ("Student number", "study number", "Student Name"); $csvfile = new Csvdatafile ("", ",", "w"); echo $csvfile->printline ($arr _export_titles); Method One $print _data1[] = 1; $print _data1[] = "039413301"; $print _data1[] = "Zhang San"; echo $csvfile->printline ($print _data1); $print _data2[] = 2; $print _data2[] = "039413302"; $print _data2[] = "John Doe"; echo $csvfile->printline ($print _data2); $print _data3[] = 3; $print _data3[] = "039413303"; $print _data3[] = "Harry"; echo $csvfile->printline ($print _data3); Method Two $print _data[1][] = 1; $print _data[1][] = "039413301"; $print _data[1][] = "Zhang San"; $print _data[2][] = 2; $print _data[2][] = "039413302"; $print _data[2][] = "John Doe"; $print _data[3][] = 3; $print _data[3][] = "039413303"; $print _data[3][] = "Harry"; echo $csvfile->printcsv ($print _data); 

2. Open CSV Read data

Code

Require "./include/csvdatafile.php"; $filename = "E:/development/csvfile/datefile.csv"; Read File Source $handle = fopen ($filename, "R"); $contents = Fread ($handle, FileSize ($filename)); Fclose ($handle); Format content for special chars $contents = @addslashes ($contents); $contents = @str_replace (' \, ', ' \, ', $contents); $contents = @stripslashes ($contents); Write to new file $handle = @fopen ($filename, "w"); @fwrite ($handle, $contents); @fclose ($handle); $FD = @fopen ($filename, "RB"); $first _line = Str_replace (', ', ', ', Str_replace (' "', '", Trim (@fgets ($FD, 1000)))); @fclose ($FD); if ($first _line! = "Student number, school number, student name") {$pass = false;} if ($pass) {$csv = new csvdatafile ($filename); while ($csv->next_row ()) {$userid = Trim ($csv->f (' Student number ')), $classno = Trim ($csv->f (' study number ')), $username = Trim ($csv->f (' Student Name ')}}