Server side grouping
Server side root paging with grouping rows on server with client side child paging
Do not run this file locally!
Run it from your local or remote web http server where is installed PHP.
Source files: Grouping.html
(this html page),
Grouping_Layout.xml
(static XML layout),
Grouping_Data.php
(server script generates XML list of pages),
Grouping_Page.php
(server script generates XML for individual page),
../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 Grouping_Data.php and Grouping_Page.php
Demonstrates server root paging but client child paging - all children from groups are downloaded from server at once.
There is no server communication on parent row expand.
This is only simple example with not ideal database access (for every page gets all data).
The root pages are downloaded on demand from server (when the page is visible by scrollbars).