Dynamically Update HTML Content with PHP Script & Flat File?

captainjoe

Hey Folks:

Anyone know of a php script that will do the following?

I want to udpate product prices on my web site using a simple flat file (we store our product prices in Excel). Our product line and product descriptions rarely change, but the product prices change often, so a database back-end is not necessary...hence the need for just a flat file.

I would like to embed my web product pages with php tags(?) so that whenever I uploaded this flat file, all the html pages with embedded tags would be updated via php script.

Is this possible? I looked at the database archive here and did not find anything that would do the trick.

Any help would be appreciated.

CJ
A PHP newbie

sarahk

If your pages are html you could manually run a script to go through the html and find the instances of each price and update them. You would need some sort of tag around them to make it clear which is which. This is DODGY to say the least.

Better would be for your html pages to be renamed as .php. You can use the .htaccess file to rewrite the urls as they come in so you don't have to review every link. Then any file with a price in it could open the text file and read the appropriate price. Still a bit of work involved but much, much more secure.

This is just feedback on the idea, you will need to think about what you want to do and repost.

captainjoe

Originally posted by sarahk
If your pages are html you could manually run a script to go through the html and find the instances of each price and update them. You would need some sort of tag around them to make it clear which is which. This is DODGY to say the least.

How would I go about doing this? Can a PHP script that could do this?

Thanks in advance,