dbWebGen - Database Web Generator for PHP
This PHP application automatically generates a responsive web app on top of your relational database. The app allows users to * Create and edit records via web forms, taking into account foreign keys and other constraints * View stored records along with related records from other tables * Browse and filter records in a table * Query the database, visualize the results, and share the visualizations. Currenty the engine offers various visualizations like tables, bar charts, sankeys, timelines, graphs/networks, geomaps and others.
Developers may add custom functionality and extensions to the engine through hook functions in plugins, and admins may exploit an extensive array of settings controlling the engine.
- Webserver running PHP (lowest tested version is 5.3)
- Database server (currently working only with PostgreSQL; lowest tested version is 9.2)
- A database
Get it Running
- Clone this repository into any folder that is served by your webserver.
- Since this repository contains the app engine only, you need to create another folder that will serve as the actual app folder
- In the app folder, create a PHP file that serves as the main entry point of the app (typically
index.php). This file is very simple: it must include a definition of the constant
ENGINE_PATH, which shall define the relative path to app engine folder. The other line in this file is the inclusion of
engine.phpfrom the app engine folder. Note: if required, you may use
ENGINE_PATH_LOCALto define the relative or absolute local file system path to the engine folder, which is used for including
ENGINE_PATHis used to point to files in
<link>tags, so those must be resolveable by the web server.
settings.template.phpinto your app folder, rename it to
settings.php, and fill the file with settings that reflect your app and database structure.
- Direct your web browser to the app folder and be happy.
Example Database and App
An example app using this engine can be seen in the dbWebGen-demo repository
Below are some screenshots from a database app that uses dbWebGen to allow users to work with historic documents from 19th century Oman. Click any thumbnail to view at full resolution.
This code is licensed under the MIT license. See the LICENSE file.