Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Peter Robinson: "As a tech savvy company director, I wanted an inexpensive web based database application to manage all aspects of my business. As with most humans I find developing purely by CLI very hard and do not have the will or time to invest in improving my skills. I was looking to find a nice human friendly GUI to design and build my application, which is when I came across PHP Generator for MySQL.

Whilst you still need a great understanding of logic and a small amount of programming ability to get the specific results you require, I am very happy with the speed of progress I have been making with this invaluable tool.

With all the standard libraries included, this product makes normal requirements such as JavaScript form validation, lookup selectors, on click events, auto complete, detailed searches, multiformat exports, rss feeds and username security straight forward and quick.

Having any changes made via the GUI written to the web server at the click of a button makes testing out ideas quick and easy without fear of breaking your application.

To conclude, I couldn't find any other product on the market that came close to offering the amount of options this does, and I do hope that more products like this come out in the future, with the hope of eventually eradicating the need to program all together".

Lucian Nedescu: "Thank you very much. Have a nice century (this is a real wish :P). I think that i will do a great job on my clients database with the new php interface. Thank You again".


Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next


Applications created by PHP Generator use the Smarty library. Smarty is a template engine for PHP, facilitating the separation of presentation (HTML/CSS) from the application logic. Smarty compiles copies of the templates as PHP scripts. Compilation happens once when each template is first invoked, and then the compiled versions are used from that point forward. The compiled templates are stored under the templates_c directory which must be accessible for writing by Smarty.


To upload a ready web application to your web hosting, you need to have the following conditions.


1. Allow write access to templates_c

The web server user must have write access to the templates_c directory. The most secure method is to make this directory owned by this user. The change of ownership is the easiest way to accomplish this. Only an administrator can execute this operation so if you can't do that then ask your hosting provider to do it for you. If you can do this, then it is possible (and recommended) to disallow "other" users read/write access for optimum security.


2. Deploy generated files

You can upload generated files to your web server manually or using a file synchronization software. In case of manual deployment there are two possible scenarios:


If the new and the live web applications were created by the same version of PHP Generator for MySQL, just copy to the remote server all .php files from the root directory of the generated application and the custom_templates folder (if you customized one or more templates in this project).
If the new and the live web applications were created by different versions of PHP Generator for MySQL, copy all files from the output directory to the corresponding folder of the remote server and then empty the templates_c directory.


We recommend you to use  a file synchronization software. Any such tool compares and synchronizes the output directory and the corresponding folder on your web hosting quickly and can significantly simplify the deployment process. One thing you have to do is to exclude the template_c directory from the synchronization process.

Prev Return to chapter overview Next