The db_table_browse model generates select queries against SQL tables including joined tables. Here is a sample query created by this model.
The db_object model encapsulates a series of SQL tables into a callable maintenance object (PHP class). This class can be called from the form to build maintenance functions like this one:
Other database-oriented models include:
- db_config which is used to configure a database connection.
- db_log_profile which defines database columns to be used for logging update transactions.
- db_object_child which configures child tables to be included within a database object.
- schema is used to configure which databases can be accessed from which environments.
To see more examples of GenHelm's database models in action please visit building SQL applications in PHP.