PHP Class Generator

The PHP Class Generator is a small windows desktop application that allows a PHP programmer to generate Entity classes from a MySQL database table.

For instance, if the user has a table in his or her MySQL database called customers. With this app, that programmer can generate an Entity class called customer that will hold all of the proper getters and setters as well as constructor, destructor and loadById methods.

The app also provides a DatabaseManager class, which will connect to the MySQL database using the provided connection parameters given by the user. This class can be modified to fit the users needs.

The application allows for quick, easy and consistent class design for better web application implementation. PHP Class Generator was written using MS Visual Studio 2003 and the 1.1 .NET frameworks.

It was written in VB.NET and uses a 3rd party component from Core to connect to the MySQL database. It also will make a copy of adodb to the class path provided at runtime. An MSI (Microsoft Installer) has been made for easy installation on windows machines (Linux version of the PHP Class Generator is not available).

It requires the user to have MySQL and 1.1 .NET frameworks installed on a Windows XP, Windows 2000 Pro/Server or higher.

Connection Parameters:

The PHP Generator connects to a MySQL database via an ADO.NET connection. In order to connect to a MySQL database three parameters need to be supplied.

The following three parameters can be provided in the "Connection Parameters" section of the PHP Class Generator.

Some users in the MySQL database might not have a password. It is not essential to provide a password if not applicable.
- Server - Name or IP of the MySQL Server
- User Name - DB User Name
- Password - DB Password
The PHP Generator will create a class the contains a loadById, save and delete method. These methods will load, save/update and delete a record from the database based on the primary key, respectively. Setters and Getters will also be created, but only the checked fields in the field list box will be included.

The primary key field is the essential identification field for the entity. It is used in the retrieval of the record from the database. As mentioned above, it will be used in the saving/updating and the deleting of the record.

The class name defaults to the name of the database table. The user can change this to whatever name they would like, but it is traditionally left to be the name of the table.

The final step to using the PHP Class Generator is the class path. The class path is the location were the entity project will be saved. ADODB will be installed one directory above the class path.

Requirements:

· .NET framework 1.1