Tag: fputcsv

Convert PHP multidimensional array to CSV with fputcsv code examples

convert PHP multidimensional array to CSV
How to Convert PHP multidimensional array to CSV This article explores how to convert PHP multidimensional array to CSV. You can skip to the final section if you’re already familiar with reading and writing CSV files in PHP. <?php $employees = [ ['Id', 'Name', 'Age', 'Salary', 'Department'], ['1', 'Anna', '30', 20000, 'Finance'], ['2', 'Adam', '25', 15000, 'IT'], ['3', 'Bob', '32', 25000, 'Finance'], ['4', 'Cara', '20', 12000, 'Logistics'], ['5', 'Daniel', '28', 27000, 'Engineering'], ]; //Creates a new file employee_records.csv $file = fopen('employee_records.csv', 'w'); //w is the flag for write mode. if($file === false) { die('Cannot open the file'); } foreach($employees as $employee) { //Formats the employee record as CSV and writes it out employee_records.csv fputcsv($file, $employee); } //Closes the file. fclose($file); ?> Introduction PHP multidimensional arrays can be complex in structure as they have arrays within. These arrays are typically called “sub-arrays”, which may or may not be consistent in data…

read more

How to add headers to file with fputcsv PHP Code Examples | 2023

fputcsv add headers
PHP fputcsv add headers Code Example PHP fputcsv add headers just as it adds the data records. This article includes examples featuring different data arrays and explains how to write them with the correct headers. <?php //Creates a new file employee_records.csv $file = fopen('employee_records.csv', 'w'); //w is the flag for write mode. if($file === false) { die('Cannot open the file'); } $headers = array_keys($employees[0]); //Write headers fputcsv($file, $headers); foreach($employees as $employee) { //Formats the employee record as CSV and writes it out employee_records.csv fputcsv($file, $employee); } //Closes the file. fclose($file); ?> Introduction PHP fputcsv helps in writing CSV files. It defines useful arguments that leverage programmings by simplifying file writing, reducing all the hard work down to a sole function call.  If you’re seeing this function for the first time, there’s a big chance that you’re not familiar with how PHP handles CSV files. However, we have you covered. FuelingPHP…

read more

3 changing delimiters in fputcsv PHP Code Examples in 2023

delimiters in fputcsv
How to Change the Delimiters in fputcsv PHP Code Example Delimiters in fputcsv can be modified using the separator argument. This article includes some examples related to changing delimiters in fputcsv. <?php $employees = [ ['Id', 'Name', 'Age', 'Salary', 'Department'], ['1', 'Anna', '30', 20000, 'Finance'], ['2', 'Adam', '25', 15000, 'IT'], ['3', 'Bob', '32', 25000, 'Finance'], ['4', 'Cara', '20', 12000, 'Logistics'], ['5', 'Daniel', '28', 27000, 'Engineering'], ]; //Creates a new file employee_records.csv $file = fopen('employee_records.csv', 'w'); //w is the flag for write mode. if($file === false) { die('Cannot open the file'); } foreach($employees as $employee) { //Formats the employee record as CSV and writes it out employee_records.csv fputcsv($file, $employee, '-'); } //Closes the file. fclose($file); ?> Introduction  PHP fputcsv is vital for handling reading and writing CSV in PHP. CSV or comma-separated files help persist tabular data. As the name suggests, a CSV file uses commas to separate data fields. So,…

read more

How to Use Associative Arrays in fputcsv PHP Code Examples

associative arrays with fputcsv
Associative arrays with fputcsv PHP Code Example This article includes examples of associative arrays with fputcsv in PHP. If you're familiar with reading and writing CSV files in PHP, you can jump straight to the last two sections of the artice. <?php $employees = [ ['Id', 'Name', 'Age', 'Salary', 'Department'], ['1', 'Anna', '30', 20000, 'Finance'], ['2', 'Adam', '25', 15000, 'IT'], ['3', 'Bob', '32', 25000, 'Finance'], ['4', 'Cara', '20', 12000, 'Logistics'], ['5', 'Daniel', '28', 27000, 'Engineering'], ]; //Creates a new file employee_records.csv $file = fopen('employee_records.csv', 'w'); //w is the flag for write mode. if($file === false) { die('Cannot open the file'); } foreach($employees as $employee) { //Formats the employee record as CSV and writes it out employee_records.csv fputcsv($file, $employee); } //Closes the file. fclose($file); ?> Introduction PHP fputcsv is a built-in function for formatting arrays into CSV and writing it out to a file pointer. The fputcsv in PHP makes lives…

read more

How to read and write CSV file with PHP Code Examples in 2023

Read and write CSV files in PHP Code Examples This article explains how to read and write CSV file in PHP through flow diagrams and examples. If you’re already familiar with the basics, you can skip to the examples. <?php $employees = [ ['Id', 'Name', 'Age', 'Salary', 'Department'], ['1', 'Anna', '30', 20000, 'Finance'], ['2', 'Adam', '25', 15000, 'IT'], ['3', 'Bob', '32', 25000, 'Finance'], ['4', 'Cara', '20', 12000, 'Logistics'], ['5', 'Daniel', '28', 27000, 'Engineering'], ]; //Creates a new file employee_records.csv $file = fopen('employee_records.csv', 'w'); //w is the flag for write mode. if($file === false) { die('Cannot open the file'); } foreach($employees as $employee) { //Formats the employee record as CSV and writes it out employee_records.csv fputcsv($file, $employee); } //Closes the file. fclose($file); ?> Introduction Comma separated file or CSV  is a text-based file that uses a comma as a delimiter. CSV mainly stores tabular data, and the name is inspired by…

read more