Functions to Export and import CSV data using PHP
//*Get the result of the query as a CSV stream.
function CSVExport(query) {
globalsql;
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;
}
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.
Here is the latest version of $sql class
And here is the latest version of the CSV Import/Export functions – use this.
Thanks so much.