THE PROJECT:
I am looking for someone to build simple database lookup website using PHP and MYSQL on Linux hosted LAMP server (about 5 tables) and integrate it into one of the layout I bought from Template Monster. It has intro FLASH to be customized to enter the CODE field.
I would like someone with experience (examples of previous work) how to build nice looking entry forms and able to design decent output screen from the database table (about 60 fields, but not all need to be shown – I have some ideas what should be shown and how)
HOW THE WEBSITE SHOULD WORK:
I will maintain 2 tables on the server: MAIN TABLE and LOOKUP TABLE.
MAIN TABLE has the records we need to show and they are accessible by the PIN field.
Users do not have PIN value, they only have CODE value, the LOOKUP TABLE basically looks up PIN value based on CODE that user enters. Then PIN is used to access main record in the database. LOOKUP TABLE stores all issued CODES and corresponding PINs.
Every time user enters code and match is made, this code must be stored in separate table, lets call it VISITS. Also, I need to get email notifying me about this event.
If user does not have code, the screen should prompt user to enter some custom info and this needs to be saved to table ENTRIES (about 10 fields or less) – need to get email notification as well.
When user sees the output table, it should be button to order the product. If they decide to do it, need to confirm their information (name, shipping address, etc). This information is part of the main database, but needs to be confirmed and changed if user wants to change it. Product is free, so there is no payment processing involved for now (maybe in the future). ORDERS table should have order information
HOW THE WEBSITE SHOULD LOOK:
It must be as clean as possible. Preferable larger print; some of the visitors might not be familiar with using the internet at all.
I bought template monster design and I would like website to be integrated into that design. Attached is preview image of this design – It needs to be simplified. It also has intro FLASH to be customized to enter the CODE field, the FLASH source file is included with template.
IMPLEMENTATION:
Stage 1: Make database work using very simple html to test and make databases work.
Stage 2: Apply design to template.
