Gantt Run database
Creates Gantt Run data from and saves changes back to database using AJAX
Do not run this file locally!
Run it from your local or remote web http server where is installed PHP.
Source files: RunDB.html
(this html page),
RunDBDef.xml
(static XML layout),
RunDBData.php
(server script generates XML data),
RunDBUpload.php
(server script saves XML data to database),
../Database/Run.txt
(source SQL database table),
../Framework/IncDbTxt.php
(included script for SQL TXT database),
RunSources.xml
(static XML layout and data for right grid),
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 RunDBData.php and RunDBUpload.php.
This example demonstrates Continuous Run, complex and universal bar type. It supports more bars in one cell, with different features, size, color, class, text and tooltip.
For more Gantt Run features see Gantt Local examples or Gantt tutorials.
For more ways of database communication see Basic Ajax or Form Submit PHP examples.