Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Possible solution in the fastest time topic: web technologies Palestinian Best Food Store (PBFS), is an online food store that sales authenticated Palestinian Food, such

Possible solution in the fastest time topic: web technologies

Palestinian Best Food Store (PBFS), is an online food store that sales authenticated Palestinian Food, such as Zater, Olive Oil, Sage, ets. Also sales pre-packaged Palestinian meals such as Musakhan, Maqluba, etcs, these meals are delivered to the customers homes. So, you have been approached by Abu-Omer Al-Masri, the storeowner to develop a web site for his store. The web site should have the functionalities: Search through the stores inventory of products Place an order for products. Receive confirmation that an order has been placed. allow the customer to write product review and ranking it. Allow the store manager to manage inventory, by adding products, update products details, etc. Contact us In this task you implement the following functionalities:- 1) add new product 2) search a product 3) customer registration *Note: the HTML pages (including forms) should be dynamically generated using PHP scripts. Add Product Store Manager will need to enter a product details. These are the minimum information that each product should have. Product Name, Product Description, Price (numeric data only), type (meals, preserved) use combo box to select product type (food type list should be predefined). Quantity which should be numeric. Each product should have the following: Name Brief Description Type Price Size and (measurement unit kg, liter, which should be pre-defined list, use combo box) Remarks Product ID, which is given by the system, should be a unique number generated by the system (primary key in the database). At least three pictures for marketing, you might need to add link to allow the user to upload files. I might suggest that you have to upload at least three pictures for each product. You can save the file name in the database. The filename should be like that the itemIDimgSequenceNo, for instance if you have an item its id is 12345 and then the first image file will be item12345img1.gif. The file itself could be saved at a folder named as itemsImages. Search Functionality The search form should allow the user (site visitor) to search in the store site. The search can be for a product based on their names, or price. If the visitor choose to search based on a price range, s/he should able to entre a price range, the site should display a form with two fields to enter the price range. When the user submits the form for search the site should validate that both price range fields are filled. The result List Specification: a) The returned list should be displayed in a table the first column is a checked box could be used by the user for short list. b) The second column in the table has a Product ID, which should be hyperlinked when clicked a detail page about the product will be displayed, see below for the Product Details Page specification. c) The Third column should be price and fourth is the type. The fifth column should display the product quantity available. Product Details Page specification: a) An image for the product on the left and the full details to the right. b) The product brief description should be displayed. Customer Registration: In order for a customer to place an order the customer should create an account. The customer registration is done according to the following steps. a) The customer registration form should have the following details. Customer info. ( all the information are required.) All the IDs are 10 digits. Name Address Date of Birth ID number E-mail address Telephone and Fax Number Credit card details: The customer should enter his/her Credit card details: number, expire date, name and bank issued it. All the above filed should be filled once this step is being validated, the customer can move to the next step. b) The next step the customer must confirm his/her details, so the customer details are displayed to the customer, except the password, with two options confirm or update. If the user select update the new details will be sent to server the confirmation step is repeated. The confirm button will send the complete form to the server. Then the server, store the data to the database and replay to the customer with a confirmation message. The confirmation message should have the following information. The customer ID which is a 10 digit number, and a link to create e-account. c) The customer can move to the next step, which is creating an e-account. Your site should display an E-account form that allows the customer to enter a username which should be between 6-13 characters. Also the user should enter the password then confirms it. The valid password should be between 8-12 characters.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Administration The Essential Reference

Authors: Brian Laskey, David Kreines

1st Edition

1565925165, 978-1565925168

More Books

Students also viewed these Databases questions

Question

1-4 How will MIS help my career?

Answered: 1 week ago