I need a php script that will look like this...
[url removed, login to view]
This script will be accessing a mySQL database with a table named products. The products table has 4 fields => id,description,price,location
The script will do the following...
1. read the mySQL db and pull data from the products table based on the query string. The query string represents the id field from the products table
2. The script will then read a template file (HTML) and then print to browser while replacing some place holders with the live data retrieved from the mySQL call.
Pretty simple stuff, huh?
In addition to the basics above, I do need the script to be security minded and also respond to errors such as "product not found".
As far as security is concerned, I would like the link to the script expire at some predefined time for a user.
This may involve adding another table and logging IP or using sessions. I am open to ideas here.