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".

Steven Langfield: "I wanted to drop you a mail to say how freaking AMAZING your software is. It will be the best £100 I have ever spent. I have still to read all your documentation to take full advantage but what you have created is truly amazing".


Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next


This event occurs on displaying a value of a field. It allows you to replace the actual value of a field to your own.



function OnGetFieldValue ($fieldName, &$value, $tableName)




The name of currently processed field.


The actual value of the field. Can be changed to another value.


The name of currently processed table.



This example shows how this event can be used for implementing a very simple transparent encryption based on the str_rot13 PHP function.


if ($fieldName == 'private_data') {

    $value = str_rot13($value);



Since the call of this function for an encrypted expression returns the original string, we can define OnBeforeInsertRecord and OnBeforeUpdateRecord event handlers as follows:


$rowData['private_data'] = str_rot13($rowData['private_data']);


This is just an example. We would recommend that you use more cryptographically strong algorithms to encrypt your important data.

Prev Return to chapter overview Next