Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
Hi. I'm David Powers. Welcome to Exporting Data with PHP, a practical guide to generating different types of files from a database result. We'll begin with basic formats, plain text, and CSV files. Then I'll show you how to generate a professional looking spreadsheet in Microsoft Excel format with PHP Excel, a powerful open source library.
We'll compare the results with another library that generates open document spreadsheets. After taking a look at exporting to rich text format with PHP RTF lite, the final pass of the course shows how to generate word process documents in open document text, and Microsoft Word formats as well as text, you'll embed images in the files. There's a lot to get through. So let's get started exporting data with PHP.
There are currently no FAQs about Exporting Data to Files with PHP.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.