PHP Classes
elePHPant
Icontem

File: docs/README.md

Recommend this page to a friend!
  Classes of Saro Carvello  >  MySQL Class Generator  >  docs/README.md  >  Download  
File: docs/README.md
Role: Documentation
Content type: text/markdown
Description: Documentation
Class: MySQL Class Generator
Generate classes to access MySQL as objects
Author: By
Last change: Refactoring of GUI

Now you can auto generate PHP classes by using a GUI
Date: 1 year ago
Size: 1,906 bytes
 

Contents

Class file image Download

MySQLReflection

A useful utility for the Object Relation Mapping of MySQL databases

The utility generates automatically classes for any tables of a given database schema. It's extracted from my PHP Web MVC Framework An auto generated MySQL class provides the following services:

  • A constructor for managing a fetched table?s row or for a adding a new one<
  • Management for both single or composite Primary Keys
  • Automatic mapping of the different date formats may occurs between application and database
  • Destructor to automatically close database connection
  • Defines a set of attributes corresponding to the table fields
  • Setter and Getter methods for each attribute
  • OO methods for simplify DML select, insert, update and delete operations
  • A facility for quickly updating a previously fetched row
  • Useful methods to obtain table DDL and the last executed SQL statement
  • Error handling of SQL statements
  • Camel/Pascal case naming convention for Attributes/Class used for mapping Fields/Table
  • Useful PHPDOC information about table, fields and the usage of class, attributes and methods

Developers can quickly use these generated classes on their application.

Into the beans directory are located some auto generated classes of a MySQL schema.

DDL for MySQL schema is into a script file located into "sql" directory.

Overview

Overview

UML Class Model

Uml Classes Model

Convert MySQL into PHP Classes automatically - Video Tutorial

IMAGE Video Tutorial