Writing Table Data to Files with PHP

Introduction

Welcome to this lesson on writing table data to text files using PHP . In the digital age, storing and sharing data efficiently is crucial, and text files offer a simple and compatible solution for various systems. In this lesson, we'll explore how to write formatted table data into a text file using PHP, leveraging functions such as file_put_contents and fputcsv . By the end of this lesson, you'll be able to take structured data and write it to a text file using PHP. Let’s dive into this skill and build on what you've learned about parsing tables from text and CSV files.

Recall: Basics of Arrays and File Handling

Before we proceed, let's briefly revisit two key concepts: Arrays in PHP and basic file handling. Arrays : In PHP, arrays are a versatile way to store a collection of data, such as rows in a table. This is fundamental as it helps organize your data into a structured format. File Handling : We have previously covered basic reading operations. Now, we move to writing data. PHP offers straightforward functions such as file_put_contents for writing to text files and fopen along with fputcsv for handling CSV outputs. These foundational concepts will guide us in the process of writing table data into text files.

Structuring Data for Output

First, let's define a Person class to blueprint our data entries. Each Person object in this class will have properties corresponding to the columns in our table: PHPclass Person { public $name; public $age; public $occupation; public function __construct($name, $age, $occupation) { $this->name = $name; $this->age = $age; $this->occupation = $occupation; } } With our structure in place, we can now create an array of Person objects. This array, $data, acts as a collection of rows where each Person instance signifies an individual record: PHP$data = [ new Person("John", "28", "Engineer"), new Person("Alice", "34", "Doctor"), new Person("Bob", "23", "Artist") ]; In this example, we've created three Person objects and stored them in an array, each representing a row with fields for name, age, and occupation. This structured approach simplifies adding or modifying rows and facilitates seamlessly writing data to files.

Writing Data with Space Delimiters

Now, let's write the data to a text file with spaces as delimiters using PHP functions. Here's how you can do it: PHP// Output file path $outputTxtFilePath = 'output.txt'; // Header with spaces $txtContent = "Name Age Occupation\n"; // Prepare content for space-separated TXT file foreach ($data as $person) { // Add each person's data as a space-separated line $txtContent .= "{$person->name} {$person->age} {$person->occupation}\n"; } // Write the content to the TXT file file_put_contents($outputTxtFilePath, $txtContent); Define the Output Path: The file path is set for output.txt. Prepare the Header: The header "Name Age Occupation" is added to the text content. Format the Data: Each Person object is converted into a space-delimited line using string interpolation. Write to File: file_put_contents writes the content to output.txt, ensuring each entry appears on its own line in the text file.

Writing Data to CSV Format

In addition to writing data to a text file with space delimiters, you can also write the data in a CSV (Comma-Separated Values) format. This approach is slightly different, as it involves using the fopen, fputcsv, and fclose functions to handle the file operations: PHP // Output file path $outputCsvFilePath = 'output.csv'; // Open the CSV file for writing $fileCsv = fopen($outputCsvFilePath, 'w'); // Header with commas fputcsv($fileCsv, ['Name', 'Age', 'Occupation']); // Iterate over each Person object in the data array foreach ($data as $person) {// Write each person's properties fputcsv($fileCsv, [$person->name, $person->age, $person->occupation]);} // Close the CSV file after writing fclose($fileCsv); In this code: Open the CSV File : We start by opening or creating output.csv using fopen in write mode. Add the Header : The fputcsv function is used to write a header line, "Name, Age, Occupation", labeling each data column. Write Each Row : As we iterate through the $data array, each Person object is written as a comma-separated line, utilizing fputcsv, which handles the formatting for us. Close the File : Once all the data has been written, fclose is called to close the file and ensure all entries are saved correctly. This method demonstrates a structured way of writing data to a CSV file, highlighting the importance of opening and closing files properly to maintain data integrity.

Lesson Summary

In this lesson, you learned how to effectively structure, write, and verify data stored in a text file using PHP. We started by organizing data using classes and arrays, then employed PHP's file-handling capabilities to write this data with space and comma delimiters. We encourage you to engage with the practice exercises that follow this lesson. Apply what you've learned to reinforce your understanding and gain confidence. Try experimenting with different data structures, adapt them, and ensure your outputs meet your expectations. Well done on progressing through this important lesson!

Join the 1M+ learners on CodeSignal

Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal