Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Craig Cordell: "The simplicity of your code generator is fantastic. We've evaluated dozens of others over the past few years but have yet to find one that is as easy to use as yours".
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".


Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next


This event occurs before page loading. It allows you to declare functions and global variables. Use the event to include one or several files of a third-party library into the generated pages.



To get the details of the first master record expanded on opening of a certain page of the generated application, define the expandFirstDetail function within the OnBeforePageLoad event handler as follows:


function expandFirstDetail() {

  if ($('table.pgui-grid').data('grid-class')){

    var grid = $('table.pgui-grid').data('grid-class');

    var $row =  $('table.pgui-grid').first(); 


    return true;


  else {

    setTimeout(expandFirstDetail, 100);




This function then should be called within the OnAfterPageLoad event handler.

Prev Return to chapter overview Next