Recommend this page to a friend! |
Download |
Info | Example | Screenshots | Files | Install with Composer | Download | Reputation | Support forum | Blog | Links |
Ratings | Unique User Downloads | Download Rankings | ||||
80% | Total: 1,061 This week: 3 | All time: 3,495 This week: 12 |
Version | License | PHP version | Categories | |||
mysqlreflection 1.0.11 | BSD License | 5 | PHP 5, Databases, Code Generation |
Description | Author | ||||||||
This package can perform automatic generation of PHP classes from MySQL tables. |
|
Map database records to objects
Store and retrieve objects without writing native SQL again
What is the best PHP crud class?
How to create CRUD with PHP
doing all crud operations
doing all crud operations with one class
What is the best PHP crud class?
Manage and display staff details from database
database crud for each table
Package to analyze each table and create pdo crud for each
mysql database
script for update mysql database
How to find package ?
I'd like find package for accessing MySQL database.
php class file for InnoDB having the transaction handling
Mysql Innodb connection handling in PHP
PHPeclipse - PHP - Code Templates
Generate DB class, manager and exception file like PHPeclipse
MySQL table editor
Need to be able to create an interface to edit the table data
Good and simple MySQL wrapper
What MySQL wrapper should I go with?
Best PHP mysql to mysqli or PDO solution
How to convert mysql code to use mysqli?
Access data base
Pre-written PHP MySQL functions class
<?php |
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:
1) IMPORTANT! Use lowercase with the underscore, which is the widely used MySQL naming notation, on your database tables and fields names.
2) 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.
3) 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.
4) Once the utility is started, click "_Generate classes_" button.
After running the utility you will find all generated classes into "beans" folder.
Note:
An auto generated MySQL class provides the following services:
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.
Many and many thanks to for granting me an open source license of magic
PHPStorm
that I used in the development of MySQLReflection.
Screenshots (3) | ||
Videos (1) | ||
Files (40) |
File | Role | Description | ||
---|---|---|---|---|
beans (17 files) | ||||
docs (6 files) | ||||
mysqlreflection (7 files) | ||||
sql (1 file) | ||||
app_create_beans.php | Example | Example script | ||
app_run_bean.php | Example | Example script | ||
composer.json | Data | Auxiliary data | ||
LICENSE | Lic. | License text | ||
mysqlreflection.config.php | Aux. | Auxiliary script | ||
README.md | Doc. | Documentation |
Files (40) | / | beans |
File | Role | Description |
---|---|---|
bean.config.php | Aux. | Auxiliary script |
BeanAclActions.php | Class | Class source |
BeanDepartments.php | Class | Class source |
BeanDeptEmp.php | Class | Class source |
BeanDeptManager.php | Class | Class source |
BeanEmployees.php | Class | Class source |
BeanMultiplePk.php | Class | Class source |
BeanSalaries.php | Class | Class source |
BeanSinglePkDate.php | Class | Class source |
BeanSinglePkDateTime.php | Class | Class source |
BeanSinglePkInt.php | Class | Class source |
BeanSinglePkIntAuto.php | Class | Class source |
BeanSinglePkString.php | Class | Class source |
BeanTitles.php | Class | Class source |
BeanUser.php | Class | Class source |
Model.php | Class | Class source |
MySqlRecord.php | Class | Class source |
Files (40) | / | docs |
File | Role | Description |
---|---|---|
gui.png | Data | Auxiliary data |
index.html | Doc. | Documentation |
MySQLReflection.png | Data | Auxiliary data |
README.md | Doc. | Documentation |
tutorial_text.txt | Doc. | Documentation |
UMLClassModel.png | Data | Auxiliary data |
Files (40) | / | mysqlreflection |
File | Role | Description |
---|---|---|
MVCMySqlBeanBuilder.php | Class | Class source |
MVCMySqlBeanClass.php.tpl | Class | Class source |
MVCMySqlFieldToAttributeReflection.php | Class | Class source |
MVCMySqlPKAnalyzer.php | Class | Class source |
MVCMySqlSchemaReflection.php | Class | Class source |
MVCMySqlSimpleTemplate.php | Class | Class source |
MVCMySqlTableReflection.php | Class | Class source |
The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page. |
Install with Composer |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
92% |
|
|
User Ratings | User Comments (1) | ||||||||||||||||||||||||||||||||||
|
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.