As a programmer I always needed to make PHP pages that connect to a database and then have that page edit or show data from database tables.  For a new PHP/MySQL developer this could take hours of work to code and debug.  Luckily there is a freeware for us that will do just that:

http://www.sqlmaestro.com/products/mysql/phpgenerator/

PHP Generator for MySQL provides users with a set of clear-cut wizard steps, so it really does not require a deep knowledge of MySQL from its users. Users will hardly come across any difficulties when following wizard precise directions.

The tool automates the creation of PHP scripts for database connection and presentation.  To begin creating PHP pages, open PHPGenerator then enter the database information where your tables are stored:

clip_image002

Select the table name from the list of tables.

clip_image002[5]

The selected tables will transfer to the right side of the screen.

clip_image002[7]

It will then tell you where the PHP page will be saved.  I usually put it inside the htdocs folder in XAMPP or Apache so that I can browse the page using a web browser for a quick test.

clip_image002[9]

The tool also allows you to customize the HTML appearance of the result scripts such as header/footer, font settings and background color for each element, body background image, table background color, etc. Preview is also available.

clip_image002[11]

If you want to have a login protected access, it allows you to request user name and password when someone attempts to access your script or to execute some of the specific actions: detailed viewing, adding, editing or deleting a table/query row.

clip_image002[13]

The output is a completely generated PHP script that has a view of the table with capability to filter, paging, adding and editing database content.

image

With PHP Generator for MySQL you will have a very professional web database application ready for uploading to your website. It has all the powerful features you would expect from a professional database application: data navigation, sorting, advanced filtering, modification, addition and deletion.

The lowdown is that since it is a freeware it doesn’t have a full blown capability of an integrated development environment.  For example, there is no instant way to instant way to edit a page’s database connectivity, you will need to go to the whole wizard driven steps to recreate the whole thing.

Ben Carigtan shows you how it’s done!