The global idea is to retrieve information from an existing MySQL database, which is included under Cpanel webhosting, and display this information (text, memo, yes/no and photo fields) by using a small number of PHP-scripts with included (HTML)table layout.
Login data to MySQL should be hide well in the script or encoded so that it is impossible to gather this information from outside (with browser etc.).
This PHP-script block should be universal.
What means that in the top of the script(s) a number of values must be able to change in order to get different information from different product groups (different product types).
It must be possible to put these PHP-scripts/block on more places on the website.
On each specific page there will be a header, a buttonbox, THE PHP SCRIPT and a footer.
The choice of the product group (product type) must be declared in the top of the script or triggered by a value which can be send from the particular page to the script.
Global information about what is in the database:
For each product there is text, memo and yes/no fields. Approx. 20 fields per product. There are 7 photo fields (small in memory size) for each product. Photos are all in .jpeg format, but types like (.bmp or .tif) should be able to support too (prepared).
The product information should be displayed two ways:
- First: Global product overview:
With 1 main resized photo (approx. 200x133 pixels),
5 resized photos (approx. 100x66 pixels) around the main photo and some text, memo and yes/no fields. The maximum number of products per page must be declared in the top of the script. The products page(s) must come with page linking (previous page, page1, page2, next page if applicable). If more products are in the database. If there are no products at all in the database, there must be a text like ‘no objects available’. If a number of products are in the database more displaying like descript above must be executed in the same page until the max number products per page are retrieved (declared in the top of the PHP-script). After that page linking should be active.
-Second: Specific product overview:
Once pressed on one of the product photos (large or small) a specific product page (in the same kind layout should be opened. In this page the photos will be larger (main photo:
200 x300 pixels, smaller photos: 100x150 pixels).
A possible 7th photo (.jpg format (optional: .bmp/.tif), but wider) must be included in this form (on the bottom of the table layout) next to more information (more text, memo and yes/no fields).
In this more detailed product overview (1 product per page) page linking must be active.
Extra button must be included which makes it possible to go back to the main page with the global product overview (see ‘First: Global products overview’). When going back to this page the page overview should displayed the related page with a maximum 5 products (declared). For an example if customer went to Specific products page 17 and wants to return to the Global product overview, he should return to the fourth block of 5 products (adjustable setting) with a bookmark to the second product on that page. Linking should be correct again.
The ideas/outlook of the table fields will come after agreement / approval.
Remember: the PHP-script(s) only gather information from MySQL and displays it two way in two types of tables.
Bid is open!
Many thanks in advance!