Uploading a spreadsheet into a database
Although PHP does not have any direct capability to read a specific spreadsheet format (that is, XLSX, ODS, and so on), it does have the ability to read (CSV Comma Separated Values) files. Accordingly, in order to process customer spreadsheets, you will need to either ask them to furnish their files in CSV format, or you will need to perform the conversion yourself.
Getting ready...
When uploading a spreadsheet (that is, a CSV file) into a database, there are three major considerations:
- Iterating through a (potentially) massive file
- Extracting each spreadsheet row into a PHP array
- Inserting the PHP array into the database
Massive file iteration will be handled using the preceding recipe. We will use the fgetcsv() ...
Get PHP 7 Programming Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
