Website that display photos dynamically from user specified keyword
$100-500 USD
Fechado
Publicado há mais de 15 anos
$100-500 USD
Pago na entrega
Specification of a website that has many product photos to display
The aim of the website is to show the photos of its products. There are a lot of them (over 20,000).
The photos will be supplied with a file name for each. And an Excel file will be provided that has following fields:
photo file name, Item Number, Type refereence, Height, Color, Description, additional information
The Exce file would not be complete with every field. It should be imported to an SQL file. Utility should be built to allow importing of more data in future.
In future we can update the backend SQL file and change the webpage content (when a webpage is invoked, data are extracted from SQL database).
The home page should be built with a dummy text and dummy photos and some links. Those links need to be implemented:
1. Browsing by Type (30 types initially)
when user are in one of the browsing-by-type first page, the photos are displayed 3 x 3 (shown on upper fold, user no need to scroll). arrow and numbers will allow the users to proceed forward and backward. The sequence is determined by item number.
2. Search by keyword. (*** this is the part that needs some coding efforts***). User would type into a 'keyword box' (example: couple, or angel), then a new group of webpages would be created 'dynamicly'. The keyword typed would be matched to 'description of item'. All those that matches (such as all that has 'angel' in descriptin) would be created dynamically and displayed just like the Browsing-by-Type
3. There would be a separate 'Color spec'. It'd have following options for users to choose:
1. All colors
2. Hand-paint
3. Cold cast bronze
4. ...
And the default is 'all colors'. If user specified it, then those not qualified would be filtered out.
4. The browing by type and keyword search based browsing navigational links are to be present on each display page.
5. The searchable photo display is to be protected by password to approved web visitors.
This job, is thus, a skeleton of a full website aiming at resolving the creation of webpages dynamically from the SQL database records with qualifying conditions.
I'll accept the job as long as all above funtionality are implemented.