Introduction As you should be aware the HTTP protocol, as used for serving web pages, is completely stateless. This means that after the server has received a request, processed it and sent a response, the process which dealt with that request dies.
Of course, you had the usual set of new features. But the big new advance was the addition of XML file formats.
With Officeyou can save your Microsoft Excel spreadsheet as XML and use the file just as you would the binary equivalent. The same goes for Microsoft Word. Why are XML file formats so important?
Because for years, the true power of Excel or Word was locked in binary file formats that required elaborate converters to access. In this article, I show how to build a PHP Web application that uses these formats to read data into a database from an Excel spreadsheet and to export the contents of a database table to an Excel spreadsheet.
This application is a table of names and e-mail addresses. To set up the database, create the database using the Mysqladmin command-line tool: You then load the database from the schema file: The user and password authentication you use varies depending on your installation, but the idea remains the same.
First, create the database. Then use the SQL file to create the tables with the required fields. Create the import data The next step is to create some data for import. Create a new Excel file.
In the first workbook, call the top row of columns First, Middle, Last, and Email. Then, add a few rows of data to the list see Figure 1. Data for import You can make the list as long as you like or change the fields however you see fit.
In a production application, you would probably want to read and parse the header line to determine which fields are in which columns and make the appropriate changes to your import logic. Import the data The import system starts easily enough with a page in which you specify the input Excel XML file see Figure 3.
In the first phase, I simply parse the XML data and output it as a table. In the second phase, I add the logic that inserts the records into the database. Listing 3 shows an example Excel XML file.
Note the document header portion at the beginning that describes the document and who is writing it, lays down some visual information, lists styles, an so on.
Then, the data comes as a set of worksheets within the main Workbook object. The first Worksheet object contains the real data. Within that object, the data resides inside the Table tag in a set of Row and Cell tags.
Each Cell tag has a Data tag associated with it that holds the data for the cell. In this case, the data is always formatted as String type. By default, when you create a new document, Excel creates three worksheets named Sheet1, Sheet2, and Sheet3.
Listing 4 shows the first version of the import. Then the script finds each Row tag. After the first row, an inside loop parses each Cell tag within the row. The script needs to keep track of that itself.
In fact, the Cell tag has an ss:You sir are a gentleman and a scholar. This was exactly the problem I was having. I modified my initiativeblog.com months ago and must have never noticed that POST didn’t work after that, it was only today when I went to write a quick script that relied on POST data and found that it wasn’t working.
flags. The optional parameter flags can be one, or more, of the following constants: FILE_USE_INCLUDE_PATH Search for the file in the include_path. FILE_IGNORE_NEW_LINES Omit newline at the end of each array element.
Returns the file in an array. Each element of the array corresponds to a line in the file, with the newline still attached. Upon failure, file() returns FALSE.
Note: Each line in the resulting array will include the line ending, unless FILE_IGNORE_NEW_LINES is used. AFAIK, PHP can't NOT use SuEXEC if apache does. If PHP is configured as an apache module it will act as whatever user the apache is. If apache SuEXEC's to otheruser:othergroup (e.g.
root:root), that's what PHP will write files as, because it acts as a part of apache code. I suggest you double-check your SuEXEC configuration and settings.
File handling is an important part of any web application. You often need to open and process a file for different tasks. PHP Manipulating Files. PHP has several functions for creating, reading, uploading, and editing files.
The PHP code to read the file and write it to the output buffer is as follows. Write JSON file with PHP. GitHub Gist: instantly share code, notes, and snippets.