Tree in SQL database
Tree in database table using Parent / Id relationship, uses AJAX 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:

TreeFramework.html

(this html page),

TreeDef.xml

(static XML layout),

TreeFramework.php

(server script generates and processes XML data),

../Database/TreeData.txt

(source SQL database table),

../Framework/IncDbTxt.php

(included script for SQL TXT database),

../Framework/TreeGridFramework.php

(TreeGrid PHP framework support script, included into TreeFramework.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 TreeFramework.php