PHP Classes
Icontem

Class: SQL Data


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Richard Munroe  >  SQL Data  >  Download  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: SQL Data Support forum
Base name: sqldata
Description: Generate classes to store objects in SQL databases
Related top rated classes:
Version: -
Required PHP version: -
License: Custom (specified in a license file)
All time users: 2129 users
All time rank: 1169
Week users: 1 user
Week rank: 3336
 
  Author   Group folder image Groups   Detailed description  
  Rate classes User ratings   Dependencies   Applications   Files Files  

Author

Picture of Richard Munroe
Name: Richard Munroe is available for providing paid consulting. Contact Richard Munroe .
Published packages: 22 Browse this author's classes Browse this author's classes
Country: United States United States - PHP jobs in United States
Home page: http://www.csworks.com/
Age: 58
All time rank: 13
Week rank: 22

Groups

Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Code Generation Compilers and tools that generate code automatically View top rated classes

Detailed description

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.

User ratings

Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (75.0%)
Good (85.0%)
-
-
-
-
Not sure (46.0%)
1438
Month:
Not yet rated by the users

Packages needed by this class

Class Dependency Why it is needed
dm.IS Layout
Required
 Provide C++ template like expansion of the SQLData class
requestUtils
Required
 Retrive data from access independent of GET or POST method
Structured Data Dumper
Required
 Debugging interfaces generated by the various build scripts need it.
dm.DB
Required
 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.
Add link image If you know an application of this package, send a message to the author to add a link here.

Files

File Role Description
Plain text file buildClass.php Appl. Class builder
Plain text file buildDatabaseConf.php Appl. Builds a file containing MySQL access information
Plain text file buildForm.php Appl. Input/Edit Form Builder
Plain text file buildProcessForm.php Appl. Build the "save" action associated with a generated form
Plain text file buildSyntacticValidation.php Appl. Generate JavaScript routines for field validation
Plain text file class.SQLData.php Class Generic MySQL Table abstraction base class
Plain text file class.SQLData.template Data C++ template like class for generating proper inhertances to specific database implementations.
Plain text file license.txt Lic. Modified NetBSD License
Plain text file options.php Aux. Common command line options handling.
Plain text file syntacticValidationFramework.css Data Cascading Style Sheet for the generated forms.
Plain text file syntacticValidationFramework.js Data JavaScript framework for validating generated form fields.
Download all files: sqldata.tar.gz sqldata.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products