71129 PHP + Access Database project

Hello Project Details I will need this project finished and sent to me by Thursday 6th May 2004 at 20:00 GMT. Please don't bid if can not finish this project by then. This project is not big and can be completed within a day.I will require this project to be scripted in PHP and the database to be in Microsoft Access. The site design is already created. If you have any questions please send me a message through the ScriptLance message board. I can pay via ScriptLance, PayPal and Western Union. I prefer to pay through ScriptLance. I have attached a copy of the site's html files, site images and the access database. You can also view the site at [login to view URL] Below is what I need done. Instant Gratification is an Internet retailer of chocolate products. The business currently has a web site in which it promotes its range of chocolates. You can view the current website design at [login to view URL] I need the site upgraded to allow customers to view and search through the products and to place orders. I also need the site to allow users to pay for their purchases through an online payments system but, for now, the site only has to go as far as taking orders and sending them to me by email. I have designed a basic version of the database and this includes sample data for use in developing the site. Additional tables in the database will be required to hold information about customers and their orders. You should adapt the database so that it is capable of holding all the information required by the system. Site Details Below is information on what each page should do. A lot of the pages will remain a static page and you will not need to do any scripting on these pages. The pages that are dynamic will need to be scripted in php. [login to view URL] This will remain a static page. This is a container page that holds the frameset for the site. It consists of two frames, split horizontally. The upper area contains “[login to view URL]” (the navigation area). This frame is constant throughout the site. The lower area contains the main content pages for the site. On entering the site, the frame holds the page “[login to view URL]” [login to view URL] The navigation page, containing buttons that take users to the various sections of the site. This will remain a static page. No additional functionality required. [login to view URL] This page will welcome the user to the site and display a welcome message. This will remain a static page. No additional functionality required. [login to view URL] This page contains contact information. This will remain a static page. No additional functionality required. [login to view URL] This is a page that tells users a bit about the company. This will ideally become a dynamic page. The page includes a list of exhibitions that the company will attend. These are held in a table in the database, and should be displayed in this location. Ideally the page will show only those exhibitions that are either running on the date on which the page is accessed or at a later date (i.e. past events are not shown). [login to view URL] This page is accessed from “[login to view URL]” and shows the Terms of Trading. At first sight, this could be a static page. On closer inspection, however, some of the data in the page will be subject to change in the medium term. You should therefore provide for these items to be called from the table in the database. [login to view URL] This will become a dynamic page. This page will produce a list of products from the database and list them according to the products' category and range. This has two functions – it lets the user quickly see what products are available and, more importantly, each entry should be selectable by the user. Selecting a listed item should take the user to “[login to view URL]”, which displays details about products listed for that category or range. [login to view URL] This page shows users basic details about each product within a category or range. This will become a dynamic page. At the top of the page, the title bar should contain details of the products shown on the current instance of the page. That is, if the user has selected products in the category “Plain Chocolate Bars”, the title should display “Plain Chocolate Bars”. The page can only show four products at a time. In some cases, there will be fewer than four, and the page should be able to accommodate that [login to view URL] other cases, there may be more than four items to be shown. In such cases, the products should be spread over multiple pages with four being shown at a time. Two devices appear on the page to assist users, On the title bar (right hand side), previous page / next page buttons. Their purpose is self explanatory. In the next bar down (left hand side) “This is page XX of XXX pages” should show the user their current location within the range of pages for the current product. For each product, data should be drawn from the database and inserted in the page. A thumbnail image of the product should be shown. Selecting this, or the “Select Item” button below the image, should take the users to “[login to view URL]”- a separate page that shows detailed information for that product. Next to the image, the top row displays a basic selection of information about the product. This is drawn from the database. The second row displays prices for the product. Values in GBP can be taken directly from the database. In the bottom row, Item Code, Pack Size and Stock Availability should be inserted from the database. [login to view URL] This will become a dynamic page. This page is intended to show users further details of the product and to allow users to enter the quantity that they want to buy. The type of product should be displayed in the title bar, and other details should be taken from the database. Users select the “buy item” button to register their request. The quantity ordered (if any) should be stored while the user is browsing / buying other products. [login to view URL] This will become a dynamic page. This page should display categories and ranges that contain products that have been introduced within the last four weeks. The functionality should be similar to that of “[login to view URL]” [login to view URL] This will become a dynamic page. This page should display categories and ranges that contain products that are currently flagged in the database as being on special offer. This is a simple YES/NO status it does not have to be calculated The functionality should be similar to that of “[login to view URL]”. [login to view URL] This will become a dynamic page. This is the page on which the transaction is conducted. Before completing the transaction, we need to gather details about the [login to view URL] page provides space for gathering this data. Ideally the system would detect whether the user's details have already been completed during the current session and, if so, to fill in the data in the controls. When the transaction is complete, the customer's details should be added to the transaction database. Credit Card details should NOT be retained after the session has been closed. When the user enters this page, details of the products that they have selected should be inserted. Ideally, they should have the option to update quantities or delete an item by selecting the appropriate button. The total cost of the order should be calculated on the page by totalling the value of each item, and adding additional costs. These are: •shipping – this is charged at 5% of the order “sub-total”. •VAT - this can also be calculated by looking up the current VAT in the database and applying it to the total of “goods sub-total” and “shipping”. The user confirms their order by selecting the “Confirm Order” button. At this point, the transaction should be committed to the transaction database. The user should be taken to “[login to view URL]”. [login to view URL] This will become a dynamic page. This is the final page that the user will normally see. It provides a page that the user can print out as a record of their transaction. Ideally, details of the order should be sent by Email to the customer as confirmation that their order has been logged, and to my emal address in order that I can fulfil the order. Thank you