19 Sep

CSV Export/Import Functions in PHP

Functions to Export and import CSV data using PHP


//*Get the result of the query as a CSV stream.
function CSVExport($query) {
	global $sql;
	
	$sql_csv = $sql->getSqlHandle($query);
	
	header("Content-type:text/octect-stream");
	header("Content-Disposition:attachment;filename=data.csv");
	while($row = mysql_fetch_row($sql_csv)) {
		$row = $sql->_stripsls($row);
		print '"' . implode('","',$row) . "\"\n";
	}
	exit;
}

3 thoughts on “CSV Export/Import Functions in PHP

  1. OK, thanks.
    But can you give me the functions : _stripsls (I thinks that is the same as stripslashes), and the class for this => “$sql->getSqlHandle($query);”.

    Sorry for my english, but I’m french.

Leave a Reply

Your email address will not be published. Required fields are marked *