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

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


Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

String templates

String templates are used by PHP Generator for MySQL on setting HREF templates, hints, etc. The strings may contain column names enclosed by %.



1. Suppose a table 'team' stores various info about NBA teams. The table has 'caption' column with such data:




To create links to the team home pages:


set the HREF template


2. Suppose there is a table 'employee' storing employee info. The table has 'first_name' and 'last_name' columns with such data:

Forest Gump

Sara Connor


To add such hints to their photos on the generated webpage:

Forest Gump Photo

Sara Connor Photo


Specify the hint template:

%first_name% %last_name% Photo


Prev Return to chapter overview Next