Freeway, php & MySQL - Dynamic MySQL

This example shows how you can get information from a MySQL database and display it to create a dynamic site, this is a very small example of a 3 page site consisting of 1 "dynamic" page, use the menu links to navigate the site.

Home | Freeway | PHP | MySQL

Build dynamic web sites in Freeway with PHP and MySQL

Using PHP and MySQL with Freeway is easier than most people think!

Open up a new world with Freeway and PHP

Home

This is a small dynamic site to demonstrate an example of how PHP and MySQL can be integrated with Freeway. The site appears to use 4 pages but actually just uses 1, different text and inserts are added depending on the page the user navigates to. When the user selects a menu link the variable value for "p" is passed on, when the page reloads the query script picks up this value and uses it to retrieve the relative infomation for that selected page, the PHP variables are populated with this data and then printed to the Freeway page.

To demonstrate this I have used one query script containing two queries to the database for each page that is loaded, one query returns the insert text in the yellow column and the second the title and text for the page, the resulting variable content is then printed to each page.

This example also uses the "PHP Dynamic Page Title" action.

Example created by Mike Brackenridge for use with Freeway 4.0 or above - March 2006

The following image shows what the above page looks like in Freeway [Without logo].


dynamic

Go back | Download the example