Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
George Westrup: "I have saved so much time using your products. Also you are quick to respond to every question I have had. Thanks for the great support".
Ananda Theerthan J: "I have been looking for PHP generator for years and now I am happy that I found one. Yes, its the PHP generator for MySQL. I completely rate 10/10 for this product for making life easier. It has lot of features and capabilities especially the CRUD, lookups and data partitioning. I love this product and recommend to others".

More

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

 

Examples:

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

maverics

cavaliers

 

To create links to the team home pages:

http://www.nba.com/maverics/

http://www.nba.com/cavaliers/

 

set the HREF template

http://www.nba.com/%caption%/

 

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