MySQLReflection

A useful utility for the Object Relation Mapping of MySQL databases

The utility generates automatically PHP classes for any tables of a given database schema.

Package is extracted from my personal PHP Web MVC Framework.

To generate PHP classes with the purpose of mapping database tables you need to:

IMPORTANT! Use lowercase with the underscore, which is the widely used MySQL naming notation, on your database tables and fields names.
Configure your database schema by modifying util\mysqlreflection\mysqlreflection.config.php file and, assigning appropriate values to DBHOST, DBNAME, DBUSER, DBPASSWORD, and DBPORT PHP constants, according to your MySQL settings.
Then, launch the tool by typing:
http/localhost/util/app_create_beans.php Note that, the GUI of the utility uses Bootstrap and jQuery from CDN. So you also need an internet connection alive before running it.
Once the utility is started, click "Generate classes" button.

After running the utility you will find all generated classes into "beans" folder.

Note:

Auto generated classes are prefixed with "Bean".
Each auto generated class uses bean\bean.config.php for configuration info.
Each auto generated class uses Model.php and MySqlRecord.php

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 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.

There is also a simple tester script "app_run_bean.php" for showing usage of a generated class.

Utility GUI

Overview

UML Class Model

Convert MySQL into PHP Classes automatically - Video Tutorial (old user interface)

Thanks

Many and many thanks to

for granting me an open source license of magic

PHPStorm

that I used in the development of MySQLReflection.

maxbyz / mysqlreflection Goto Github PK