Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Grey: "We're a two-person company, it's just me an my wife. I'm the technical guru, and she handles the business operations. I have to know a lot about MySQL, but that's much too technical for her. I have frequently had to setup CGI scripts (I code in Perl) so she can manage some of our tables (suppliers, manufacturers, etc).

I discovered PHP Generator a couple of days ago, tried the free version,and within a few hours I had purchased the Pro version (as well as SQL Maestro for MySQL).

Today I am completing the conversion of the last of my custom table managers to PHP Generator. This is eliminating several thousand lines of code that I don't have to support any more!

Thanks for this fantastic product".

Philipp Gerber: "

The product is so easy and super built that you can achieve visible and great success after a short time. Also very much possible with the product. A class product. I'm already looking forward to the next versions and extensions. Keep it up.

Support to the product is just perfect. Each Support request is quickly and very competent solved. Also various assistance, which does not fall into a support, are also perfectly processed. There is a direct wire to the manufacturer / developer and this is notth. Thanks for the class Support".


Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next


This event allows you to add environment variables for your application. You can access the values of these variables in any server-side event of your application via GetEnvVar() method of the Application class, and also use them in lookup filter criteria, on data filtering, and as default values.



function OnAddEnvironmentVariables(&$variables)




An associative array of environment variables. Use it to add your own environment variables for your application.


Example 1:

The following code defines a new variable, which can be used in lookup filter criteria, on data filtering, as a default value.


$variables['DATE_TWO_MONTHS_AFTER_NOW'] = date('Y-m-d', strtotime('+2 months'));


Prev Return to chapter overview Next