Tag: csv

Upload & Save CSV Files Using PHP Code Example in 2023

How to Upload & Save a CSV File in PHP Confirm PHP.ini settings Create HTML form on the front-end Create a file input button on the front-end Create a PHP backend script to process the CSV file upload Write a PHP function to fetch the file data from the TMP folder Move the file data to the permanent storage location and save the location Add an entry into to your database and save the reference ID Respond with your file reference location and a 200 response to the user's web browser. Code to Upload a CSV file in PHP Code Example We can use a PHP script with an HTML form to upload a CSV file to the server. When we upload a file, it initially uploads into a temporary directory and is then relocated to the target location by a PHP script. Here’s the code for file upload in…

read more

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

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

Read CSV Files to Associative Array with Headers PHP Examples

convert CSV to associative arrays in PHP
PHP Code to Read a CSV File With Headers into an Associative Array Open the csv file and get the contents with the array_map function. Use the array_shift method to get your header row. Create a PHP array to store your CSV body content. Loop through the remaining rows with a foreach loop. Check to make sure the loop content is not empty. Push a new element to the CSV array that you created using the array_combine function. Print and test your results. Continue processing as required. <?php //Map lines of the string returned by file function to $rows array. $rows = array_map('str_getcsv', file('employees.csv')); //Get the first row that is the HEADER row. $header_row = array_shift($rows); //This array holds the final response. $employee_csv = []; foreach($rows as $row) { if(!empty($row)){ $employee_csv[] = array_combine($header_row, $row); } } print_r($employee_csv) Comma-separated files or CSVs are popular for book-keeping and persisting data. Although large-scale…

read more

Convert PHP Associative Array to CSV File: 5 Code Examples

array to csv in PHP
PHP Code to Convert Associative Array to CSV File $f = fopen('employees.csv', 'a'); // Configure fopen to create, open, and write data. fputcsv($f, array_keys($employees_array[0])); // Add the keys as the column headers // Loop over the array and passing in the values only. foreach ($employees_array as $row) { fputcsv($f, $row); } // Close the file fclose($f); PHP has built-in functions that can help to convert an array to csv in PHP. PHP File handling module provides useful functions for creating, updating, and deleting different types of files. A Comma-separated file or CSV is one of the most important file formats, and some native PHP functions help us work with these files. These functions are. fopen (Opens a file) fputcsv (Writes to a CSV) fclose (Closes a file) Let’s first review these functions as they are building blocks of what we’ll see in the upcoming example. PHP fopen - array to…

read more