SQL Data
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Author | ||
 |
|
Innovation award Nominee: 3x Winner: 1x | |||||||||||||||||||
SQLData is an extension of the dm.DB class. SQLData provides object-relational mappings to store and retrieve persistent objects in an SQL database.
SQLData comes with additional scripts for generating classes to be used by applications to access given database tables using the SQLData class.
These scripts are meant to run from the command line. They retrieve the definitions of a given database table and then the generate classes to access the table rows as objects or to manipulate them via Web forms. They will generate classes and forms for any SQL database supported by dm.DB.
Experience has shown that the automatic generation handles about 80% of the repetitive work involved in building classes and forms for MySQL tables.
SQLData was designed to make it easy to automate the construction of the application specific classes interfacing to SQL tables. dm.DB provides a RDBMS independent access layer so, in principle, SQLData can be used by any database supported by dm.DB.
This class is officially compatible with PHP 5.
This is a major revision to SQLData which now supports all databases supported by dm.DB.
SQLData comes with additional scripts for generating classes to be used by applications to access given database tables using the SQLData class.
These scripts are meant to run from the command line. They retrieve the definitions of a given database table and then the generate classes to access the table rows as objects or to manipulate them via Web forms. They will generate classes and forms for any SQL database supported by dm.DB.
Experience has shown that the automatic generation handles about 80% of the repetitive work involved in building classes and forms for MySQL tables.
SQLData was designed to make it easy to automate the construction of the application specific classes interfacing to SQL tables. dm.DB provides a RDBMS independent access layer so, in principle, SQLData can be used by any database supported by dm.DB.
This class is officially compatible with PHP 5.
This is a major revision to SQLData which now supports all databases supported by dm.DB.
| Classes of Richard Munroe | > | SQL Data | > | Download .zip .tar.gz | > |  Support forum |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||
| Groups |  User ratings |
Dependencies | Applications |  Files |
||||||
| Groups | ||
 |
Databases | Database management, accessing and searching | View top rated classes |
|
Code Generation | Compilers and tools that generate code automatically | View top rated classes |
| User ratings | ||
| Ratings | ||||||||
|---|---|---|---|---|---|---|---|---|
| All time: | ||||||||
| Month: | ||||||||
| Packages needed by this class | ||
| Class | Dependency | Why it is needed |
|---|---|---|
| requestUtils | Retrive data from access independent of GET or POST method | |
| Structured Data Dumper | Debugging interfaces generated by the various build scripts need it. | |
| dm.IS Layout | Provide C++ template like expansion of the SQLData class | |
| dm.DB | MySQL database abstraction base class |
| Applications that use this class | ||
| Link | Description |
|---|---|
| Florida Democratic Party Website | Florida Democratic Party Website |
| www.esplanner.com | Economic Security Planner web site |
| Your Daily Sudoku | A Sudoku generation and distribution website. |
If you know an application of this package, send a message to the author to add a link here.| Files |
||
| File | Role | Description |
|---|---|---|
 buildClass.php |
Appl. | Class builder |
| buildDatabaseConf.php |
Appl. | Builds a file containing MySQL access information |
| buildForm.php |
Appl. | Input/Edit Form Builder |
| buildProcessForm.php |
Appl. | Build the "save" action associated with a generated form |
| buildSyntacticValidation.php |
Appl. | Generate JavaScript routines for field validation |
| class.SQLData.php |
Class | Generic MySQL Table abstraction base class |
| class.SQLData.template |
Data | C++ template like class for generating proper inhertances to specific database implementations. |
| license.txt |
Lic. | Modified NetBSD License |
| options.php |
Aux. | Common command line options handling. |
| syntacticValidationFramework.css |
Data | Cascading Style Sheet for the generated forms. |
| syntacticValidationFramework.js |
Data | JavaScript framework for validating generated form fields. |
| Download all files: sqldata.tar.gz sqldata.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2013