PHP - Moved: Cms Using Template From A Mysql Database

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=334042.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=347856.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=317600.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=349834.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=359002.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=358619.0

This topic has been moved to Other.

http://www.phpfreaks.com/forums/index.php?topic=316401.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=315539.0

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=315590.0

At the moment  I am creating a search function for my website.
The approach I have in mind is a pseudo-PHP database. To give an example:

A HTML form will submit the results to a PHP file.

HTML FORM - Colour: Black
PHP RESULT PAGE - if ($_POST['color'] == 'Black') {readfile("./products/black/*.html");}
HTML FORM - Price: <$50
PHP RESULT PAGE - if ($_POST['Price'] == '<$50') {readfile("./products/less50/*.html");}

The problem here is if there is an item that is black and costs less than $50, then its going to be listed twice. There is probably some code I can write to ommit the listing of duplicate entries, but it is probably going to be messy, so I am wondering if its better to use a centralized MySQL database, rather than a pseudo-PHP database? I've never used MySQL and don't know much about it and this is my first real attempt at using PHP.

Hi,

Is it possible to build a PHP Template page that selects and publishes a row of data from a MySQL Database when a linked is clicked?

I would design: Template.php
Text links (perhaps on homepage of navigation bar): ProductA, ProductB and ProductC

If you click link ProductA Template.php would display data for ProductA and likewise for ProductB and ProductC.

I would also like search engines for find ProductA, ProductB and ProductC PHP pages. (Not just my single Template.php)

Any ideas as to how this could be done without designing individual PHP pages for each product?

Kind regards,

Matthew.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=314051.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=307639.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=354422.0