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

Subscribe to our news:
Partners
Testimonials
Gabriela Arsene: "MySQL PHP Generator is really excellent! A very useful, easy to use tool and above all it is free, saving a lot of time and money to a developer! Great job! Congratulations to all the people who work at this project".
David Lantz: "Thank you, this is by far the simplest, and most friendly utility for building db record system I have ever used. I wish I could get my systems guys at the office to purchase this for our company would be so very helpful and speed up a lot of work. I for one have used it for everything from a simple inventory record of my house, to a members record for my church just little pet projects and a test bed to test my own db builds and theories before having to hand code at the office..... it is a lot of fun to work with".

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