PHP export files in CSV format

Written using the CI framework

Public Function Export_user ()
{
Read the export criteria from the session
$export _info = $this->session->userdata (' Export_info ');

Query results based on criteria

$res = $this->search_user ($export _info);

$filename = Date ("Y-m-d-h-i-s", Time ()). ". CSV ";

$FP =fopen ("./uploads/". $filename, "A +");

Header ("Content-disposition:filename= $filename");
Header ("Content-type:unknown/unknown"); Download to the uploads file in your project

Header ("Content-type:text/csv"); will be downloaded directly to the default directory, but an empty file, in the study ... At this point, there will be downloaded files under uploads.

$str = ";

newline character \ n to make line breaks Fu Qi, you must enclose each field in double quotation marks
foreach ($res as $data) {
$str. = "\" ". $data [' user_id ']." \ ", \" ". $data [' user_name ']." \ "\ n";
}
Fwrite ($fp, $STR);
Fclose ($FP);

Clear query criteria

$this->session->unset_userdata (' Export_info ');
}

PHP export files in CSV format