Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Dionys Henzen: "Congratulations! Your MySQL PHP Generator is a great tool, that can save a lot of time and money to a developer! I'll evaluate for sure your software products when I need them. Great job".
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 to be used in other client-side events.



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