This package can be used to generate PHP classes that wrap tables and views of a database schema; providing an object oriented mechanism to manipulate the data.
The default module embeded with the application is based on PHP5 and MySQL5 the application uses the MYSQL's Information_schema database to analyse the database structure and therefore gives very precise and unrestricted output.
Based on Modules and using XSLT, the application can easily extended to support more databases and more programming languages
It generates
- one property for each row of the table.
- function to fetch a specific row (based on its primary key), or to fetch one, several or all rows at once, with the option to filter results on one or several rows
- functions to insert, update and delete rows
- functions to easily load referenced and referencing objects (a distinct method is generated for each foreign key pointing to or from a given table)
- functions to easily work with primary keys
- supports multi-column primary keys and foreign keys
- supports cross database foreign keys
- automatically deals with auto_increment primary keys
- automatically converts MySQL Date types to PHP DateTime objects where applicable
- customizable, you can generate the php classes into one (big) file or with one file per class
- instead of generating the code you can also simply preview it in the console (syntax highlighted on ANSI enabled consoles), or export it as an HTML document.
- if you whish to develop additional XSLT stylesheets to support more programming languges, the application can also export the intermediary XML document describing the database's structure
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This package can be used to generate PHP classes that wrap tables and views of a database schema; providing an object oriented mechanism to manipulate the data.
The default module embeded with the application is based on PHP5 and MySQL5 the application uses the MYSQL's Information_schema database to analyse the database structure and therefore gives very precise and unrestricted output.
Based on Modules and using XSLT, the application can easily extended to support more databases and more programming languages
It generates
- one property for each row of the table.
- function to fetch a specific row (based on its primary key), or to fetch one, several or all rows at once, with the option to filter results on one or several rows
- functions to insert, update and delete rows
- functions to easily load referenced and referencing objects (a distinct method is generated for each foreign key pointing to or from a given table)
- functions to easily work with primary keys
- supports multi-column primary keys and foreign keys
- supports cross database foreign keys
- automatically deals with auto_increment primary keys
- automatically converts MySQL Date types to PHP DateTime objects where applicable
- customizable, you can generate the php classes into one (big) file or with one file per class
- instead of generating the code you can also simply preview it in the console (syntax highlighted on ANSI enabled consoles), or export it as an HTML document.
- if you whish to develop additional XSLT stylesheets to support more programming languges, the application can also export the intermediary XML document describing the database's structure