Lynda - Exporting Data to Files with PHP with David Powers
Lynda - Exporting Data to Files with PHP with David Powers
English | Apr 11, 2014 | .MP4 | Audio: aac, 44100 Hz, mono | Video: h264, yuv420p, 1280x720, 15.00 fps(r) | 688 MB
Genre: E-learning
English | Apr 11, 2014 | .MP4 | Audio: aac, 44100 Hz, mono | Video: h264, yuv420p, 1280x720, 15.00 fps(r) | 688 MB
Genre: E-learning
Providing a file from a database in exactly the same format that's requested by the user is an extremely valuable technique.
In this course, David Powers shows you how to export data from a database with PHP in a variety of formats, including rich text, CSV, Excel, Word, OpenOffice spreadsheets and documents, and even XML. He introduces tools like PHPExcel and PHPRtfLite that make the job of formatting the data (fonts, headers, columns, and all) easier to manage, and also shows how to embed nontext data like images in your exports.
Topics include:
Connecting to the database with PDO or MySQL Improved
Outputting data into a simple text or CSV file
Generating a spreadsheet
Creating columns and headers
Using a class to generate XML
Creating a page template
More Info
Screenshot:
Lynda - Exporting Data to Files with PHP with David Powers
