MySQL Class Generator: Generate classes to access MySQL as objects

Recommend this page to a friend!

Download .zip

Info

Example

Screenshots

View files (37)

Download .zip

Reputation

Support forum (4)

Blog

Links

Ratings				Unique User Downloads		Download Rankings
80%				Total: 1,030		All time: 3,566 This week: 107

Version		License		PHP version		Categories
`mysqlreflection` 1.0.11		BSD License		5		PHP 5, Databases, Code Generation

Description

Author

Saro Carvello

This package can perform automatic generation of PHP classes from MySQL tables.

It is able to access to a given MySQL database and retrieve schema tables and fields.

For each table it generates a class that provides methods for accessing, reading and writing its records by using object oriented programming logic.

Each generated PHP class provides Setter and Getter methods for all table fields, as well as methods for CRUD operations.

Recommendations

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

Saro Carvello

Performance

Level

Name:	Saro Carvello `<contact>`
Classes:	2 packages by Saro Carvello
Country:	Italy
Age:	56
All time rank:	1472	61 in Italy
Week rank:	81	4 in Italy

Level 2

Example


<?php

include_once("mysqlreflection.config.php");

define("DESTINATION_PATH",dirname(__FILE__) . "/beans/");

?>



<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/html">

<head>

    <title>MySQL Database Bean Builder</title>

    <meta charset="UTF-8">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">



    <!-- Bootstrap core CSS -->

    <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet" media="screen">



    <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->

    <!--[if lt IE 9]>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/html5shiv/3.7.2/html5shiv.js"></script>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/respond.js/1.4.2/respond.js"></script>

    <![endif]-->

    <style>

        .progress {

                background: rgba(204, 237, 220, 1);

                border: 5px solid rgba(56, 46, 166, 0.27);

                border-radius: 10px; height: 36px;

        }

    </style>

<script>

    var globalCount =0 ;

    var globalPercent = 0;

</script>

<body>

<div class="container">

    <h1>MySQL Database Beans generator</h1>

    <h3>This utility performs automatically  a source code generation of PHP

        Classes from MySQL tables </h3>

    <h4>Current database :<?= DBNAME ?> (to change it edit mysqlreflection.config.php)</h4>

    <h4>Destination path :<?= DESTINATION_PATH ?></h4>



    <a class="btn btn-success" onclick="document.getElementById('results').value = ''" href="?build=1"><span class="glyphicon glyphicon-wrench"></span> Generate classes</a>

    <a href="../builders/index" class="btn btn-info"><span class="glyphicon glyphicon-home"></span> Home</a>

    <br />  <br />

    <div class="progress progress-striped">

        <div class="progress-bar" role="progressbar" aria-valuenow="0"

             aria-valuemin="0" aria-valuemax="100" style="width:0%">

        </div>

    </div>



    <div class="text-center">

        <textarea cols="140" rows="20" id="results" name "results"></textarea>

    </div>

</div>

<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>



<!-- Include all compiled plugins (below), or include individual files as needed -->

<script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.4/js/bootstrap.min.js"></script>



<script>

    function aggiornaProgressBar(done=false) {

        var step = 2;

        var progress = $('.progress-bar');

        var currentValue = parseInt(progress.attr("aria-valuenow"));

        globalCount = globalCount +1;

        globalPercent = globalPercent +1;

        if (currentValue==100) {

            currentValue = 50;

        }

        currentValue += 1;

        progress.attr("aria-valuenow",currentValue);

        var percValue = currentValue + '%';

        progress.css('width',percValue);



        var textarea = document.getElementById('results');

        textarea.scrollTop = textarea.scrollHeight;



        if (done) {

            progress.attr("aria-valuenow",100);

            progress.css('width',"100%");

            percValue = "Done. " + globalCount + " classes were generated";

        }

        progress.html(percValue);

    }



    function aggiornaTextArea(msg){

        var m = msg + '&#xA;';

        $('#results').append(m);



    }



    function setNumberOfTables(ntables){

        if (numberOfTables === 'undefined' || !numberOfTables)

            var numberOfTables=ntables;

    }

</script>



</body>



<?php

if (isset($_GET["build"])) {

    /**

     *  Demo application: generate classes from a mysql db schema

     */



    // CLI mode

    // error_reporting(E_ALL);

    // include_once("mysqlreflection/mysqlreflection.config.php");

    // header('Content-Type: text/html; charset=utf-8');



    $msg = "Building classes for mysql schema:[" . DBNAME . "]";

    // CLI mode

    // echo $msg;

    echo "<script>$('#results').append('" . $msg . "');</script>";



    // Destination path for the generated classes

    $destinationPath = DESTINATION_PATH;

    // $destinationPath = "source/";



    // Create reflection object and invoke classes generation from the specified schema into mysql_connection.inc.php

    $reflection = new MVCMySqlSchemaReflection();



    // Generates the classes into the given path. During the generation it outputs the results.

    $reflection->generateClassesFromSchema($destinationPath);



    // CLI Mode

    // echo "<hr>Done.";

    // echo "<script> window.scrollTo(0,document.body.scrollHeight);</script>";



    echo "<script>$('#results').append('" . "Done." . "&#xA;" . "');</script>";

    echo "<script>aggiornaProgressBar(true);</script>";

}

?>

Screenshots

Videos

Files

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

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

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

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

Files

sql

File	Role	Description
`bean_db.sql`	Data	Auxiliary data

	mysqlreflection-2020-12-20.zip 811KB
	mysqlreflection-2020-12-20.tar.gz 774KB
	Install with Composer

Version Control

Unique User Downloads

Download Rankings

92%

Total:	1,030
This week:	0

All time:	3,566
This week:	107

User Ratings

User Comments (1)

	All time
Utility:	91%
Consistency:	91%
Documentation:	91%
Examples:	91%
Tests:	-
Videos:	75%
Overall:	80%
Rank:	15

Very useful to autogenerate PHP classes from MySQL.
6 years ago (Rossella Aiello)

87%

Applications that use this package

No pages of applications that use this class were specified.

If you know an application of this package, send a message to the author to add a link here.

About us

Advertise on this site

For more information send a message to info at phpclasses dot org.