Simple php product catalog with search query and:
script must conect to mysql database.
At this point the database includes a single table by the name of products
The table includes 166 Fields so the php file must be expandable to as many fields as needed without knowledge in programming.
The table headings in the mysql database are Field1 and on to as many as needed.
The fields may include text link or numbers.
product categories extracted from the mysql database. Which may be included in the footer or the left side of the site
Search box with power to show results from all fields of the table.
It is important to keep the html separated from the php script(may be done by include)
Control over how many columns and how many items will be shown on each page.(config area)
The site must have the 123456789 next option I believe it is called “pagination”
Single product page (once clicking the item 1234 in the catalog it must take me to that items single product page).
search box on the single product page as well.
All properties must be configurable(this script will be used under deferent sites and by non programers.)
The script must handle databases as large as 10 gig
Speed is very important.
Shopping cart is not needed but any additional options as in product sorting or show items per page are welcome.
It is desired to be able to manipulate the site's looks in the html by using tags as in: <title><?php echo $Field1 ?> </title>
Not sure if its important but the first Field is the key or the product number.