Short Description

With this script you can automatically generate data access layer-classes for tables of a MYSQL database! It generates a php class-file on your server. It enables you inserting, deleting, updating and selecting records from a database table via class methods! Only select table, define class name and press button "generate class"! VERY SIMPLE!!!

Features

• Generate Data Access Layer Classes in PHP for MYSQL Tables
• Select Table, insert class name, press button "generate class"
• One single and central definition of MYSQL access data for all classes!
• Generates automatically Setter- and Getter-Methods for all Attributes
• Generates automatically Methods for Inserting, Updating, Deleting and Selecting!
• MUST: The table must have one key-field with type number and option 'autoincrement'

Installation

• Download the archive and decompress it to your drive!
• Under directory "resources" open the file "class.database.php"!
• Change the parameters "user", "password" and "database" to your access data, save file!
• Upload all files to your server!
• Change rights of directory "generated_classes" with permission WRITE

Author / License

Marco Voegeli,  www.voegeli.li / License: FREEWARE!

Examples of Usage

In the directory "examples" you will find examples for all methods!

Download

Download it directly from http://www.voegeli.li/ under point "scripts & tutorials" and "php scripts".

Screenhots

Screen 1: The generator

Screen 2: The generated Class