Source files:

SortingExport.html

(this html page),

SortingExport_Layout.xml

(static XML layout),

SortingExport_Data.php

(server script generates XML list of pages),

SortingExport_Page.php

(server script generates XML for individual page),

SortingExport_Upload.php

(server script saves XML changes to db),

SortingExport_Export.php

(server script generates XHTML file for Excel),

../Database/TableData.txt

(source SQL database table)

The PHP CGI or ISAPI service program must have write access to all files in folder /Examples/Php/Database

This example uses

PHP Text DB API

, a flat file SQL database. The PHP core files for txt database are located in /php-txt-db-api directory. The database is located in directory /Database where are stored tables as individual txt files.
For database access are used objects Database and Recordset defined in /Framework/IncDbTxt.php file.
You can change database provider to other (

MySql

,

ODBC

,

ADO

,

SQLite

,

SQLite3

) by including other IncDb...php file and changing connection string when creating Database object. See comments in the four SortingExport_*.php files

The pages are downloaded on demand from server (when the page is visible by scrollbars).
It is simple example with ineffective database access - it loads the whole table for every page and throws the rest away. It also simply reloads all body when rows are added or deleted instead of handling changes in pages.