Using TreeGrid PHP framework
Creates grid data from and saves changes back to database using form submit and TreeGrid PHP framework
Do not run this file locally!
Run it from your local or remote web http server where is installed PHP.
Source files:

Framework.php

(this html page and also server script that generates and processes XML data),

DBDef.xml

 (static XML layout),

../Database/TableData.txt

(source SQL database table),

../Framework/IncDbTxt.php

(included script for SQL TXT database),

../Framework/TreeGridFramework.php

(TreeGrid PHP framework support script, included into Framework.php script)

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 Framework.php