To convert an array into a CSV file we can use fputcsv() function. The fputcsv() functionis used to format a line as CSV (comma separated values) file and writes it to an open file. The file which has to be read and the fields are sent as parameters to the fputcsv() functionand it returns the length of the written string on success orFALSE on failure.
Syntax :
fputcsv( file, fields, separator, enclosure, escape )
Example:
<?php// Create an array of elements $list=array(
['Name', 'age', 'Gender'],
['Bob', 20, 'Male'],
['John', 25, 'Male'],
['Jessica', 30, 'Female']
);
// Open a file in write mode ('w') $fp=fopen('persons.csv', 'w');
// Loop through file pointer and a line foreach ($listas$fields) {
fputcsv($fp, $fields);
}
fclose($fp);
?>
Posted by: Guest
on April-15-2020
1
php csv
// output headers so that the file is downloaded rather than displayedheader('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=data.csv');
// create a file pointer connected to the output stream$output=fopen('php://output', 'w');
// output the column headingsfputcsv($output, array('Column 1', 'Column 2', 'Column 3'));
// fetch the datamysql_connect('localhost', 'username', 'password');
mysql_select_db('database');
$rows=mysql_query('SELECT field1,field2,field3 FROM table');
// loop over the rows, outputting themwhile ($row=mysql_fetch_assoc($rows)) fputcsv($output, $row);
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems
resetting your password contact us
Check Your Email and Click on the link sent to your email