Search for question
Question

INSTRUCTIONS There are total 5 phases of one assignment. We are on phase 3. The assignment is to create a website for my imagined store. html, css, php, sql is used until phase 3. Instructions are given in the attachmen- t.phase 4 and phase 5 are not publish yet Store Name and Categories Name: Smart Gardening Tools Items to sell: Smart Watering System Soil Moisture Sensor Automated Plant Pot Smart Garden Light Weather-Responsive Irrigation Controller Only simple website is to be created. like beginner level, not fancy website for real life store. knows html, php, sql, css. it's easy for them. also you can use AI. Advanced phrases of code would red flag in the assignment./n Assignment Preparation • Store Selection ○ Imagine that you own your own store or stop and you'd like to create a website for it. Visit the "IT-202 Website Store Selection" Google Spreadsheet and select a store type and categories of items you would like to sell in your store. • GitHub Links to spreadsheets are available within Unit 3 Phase 0 Assignment: Website Store Selection. "Categories" from the spreadsheet will be used in phase 2. О Follow the instructions in the following document and create a NEW PRIVATE repository for your semester website assignment named "IT202-YourUCID-Project". О PHP and GitHub User Guide Follow these instructions to include ONLY your course instructor and your course TA/Graders as collaborators ■ Managing teams and people with access to your repository - GitHub Docs Assignment Phase 1: HTML5 and PHP Form Description For phase 1 of your website you want to create a simple website to introduce the store or shop you have selected and print shipping labels based on the package that you want to ship. Create a website with 2 or more separate PHP web pages describing the following: 1. One “Home” page describing your business. This page should include the name of your store, the address of your store and a description. 2. One “Shipping" page to input the "To" address for the package and output the packing label. Requirements Your website is required to include the following HTML elements within one or more of the PHP pages: • Appropriate title Links and navigation menu • Images (stored in a directory named "images") CSS margin, padding, border, width and height ● Select an appropriate color scheme for your foreground and background colors for your pages. О How to choose a color scheme? Monochromatic • http://meyerweb.com/eric/tools/color-blend Choose from a photograph or other image http://www.colr.org ■ Begin with a favorite color Use one of the sites below to choose other colors 。 https://color.adobe.com/create/color-wheel 。 http://paletton.com ■ Select an existing color palette • https://www.w3schools.com/colors/colors_palettes.asp • https://palettes.shecodes.io/ • https://arantius.github.io/web-color-wheel/ Or search for "css color palette" on the internet All text must have a specified font name and font size (do not use browser default) Consistent banner logo area (displayed when visiting all website pages) • Association with external style sheet (.css file) that configures text, color and page layout • All content must be well organized, contain complete sentences (where appropriate), and use correct grammar and spelling. All pages must contain the following HTML5 elements and they must all have a fixed width and height О Header area 。 Navigation bar (containing links to both “Home” page and “Shipping” page) Main/Content area ○ ○ Figure elements ○ Footer area ■ https://www.w3schools.com/tags/tag_figure.asp PHP field validation (HTML field validation is not required in this phase). Detailed Requirements 1. "Home" Page Details a. Store Name b. Store Description i. 4 - 6 sentences describing the store (for example: when was the store founded, your reason/purpose for selling the items in the categories, etc.) c. 4 or more images 2. "Shipping" Page Details a. The form should contain inputs for the "To" addresses for the package, a ship date, order number, dimensions of the package, and total declared value of the package. b. The "To" address is of the customer's containing the following fields: First and Last Name Street Address i. ii. iii. City iv. State V. Zip Code c. Read: https://www.w3schools.com/html/html_form_input_types.asp to pick the appropriate input type based on the input field. d. The PHP validation should check that the total declared value of the package is no more than $1,000 and that no dimension of the package is more than 36 inches. If it does, the form will display an error. e. You can assume that the addresses entered in the form are both U.S. addresses, but you should check that a valid state and a ZIP Code with valid syntax are entered using PHP field validation. f. After the form is submitted to your website, it should display another PHP page containing the information about the package in an organized, formatted report, similar to a packing label. The label must contain the following: i. From Address (This would be the address of your store, it does not have to be a real location.) ii. To Address iii. Package Dimensions iv. Package Declared Value V. Shipping Company (USPS, UPS or FedEx) vi. vii. Shipping Class (Next Day Air and/or Priority Mail) Tracking Number viii. An image of the tracking number barcode ix. Order Number X. Ship date xi. xii. NOTE: the tracking number and the barcode do not have to be real NOTE: Feel free to google examples of UPS or FedEx shipping labels for label format/layout. g. All web pages must also contain CSS styling displaying the form using background colors, font, etc. h. Any errors must be displayed in complete sentences. i. Reference Presentation: PHP and MySQL: Chapter 01 Presentation: PHP and MySQL: Chapter 02 Presentation: HTML and CSS: Chapter 03 Presentation: HTML and CSS: Chapter 04 Presentation: HTML and CSS: Chapter 05 Assignment Phase 2: Read SQL Data using PHP Description Building upon the website you created in phase 1 create the following SQL tables and PHP web page(s): 1. Create two database tables for storing the categories and details for your store. (Database definition example below) 2. Create a new page to retrieve and display all records from the SQL database. Requirements All new new PHP pages are required to include the following HTML elements (same as Phase 1): Appropriate title Links and navigation menu • Images (stored in a directory named "images") CSS margin, padding, border, width and height Select an appropriate color scheme for your foreground and background colors for your pages. о How to choose a color scheme? ■Monochromatic http://meyerweb.com/eric/tools/color-blend Choose from a photograph or other image http://www.colr.org ● ■ Begin with a favorite color Use one of the sites below to choose other colors 。 https://color.adobe.com/create/color-wheel 。 http://paletton.com ■ Select an existing color palette • https://www.w3schools.com/colors/colors_palettes.asp https://palettes.shecodes.io/ ■ Or search for "css color palette" on the internet All text must have a specified font name and font size (do not use browser default) Consistent banner logo area (displayed when visiting all website pages) • Association with external style sheet (.css file) that configures text, color and page layout All content must be well organized, contain complete sentences (where appropriate), and use correct grammar and spelling. All pages must contain the following HTML5 elements and they must all have a fixed width and height ○ Header area 。 Navigation bar (containing links to both "Home" page, “Shipping" page and new product page) 。 Main/Content area ○ Figure elements ■ https://www.w3schools.com/tags/tag_figure.asp Footer area ⚫ PHP field validation (HTML field validation is not required in this phase). Detailed SQL Requirements Create two database tables in your NJIT SQL database server. One table to store the categories and one to store 3 or more items for each category. Each table name and field must specifically describe your store. For example, if you see the "Guitar Shop" example in the "IT-202 Website Store Selection" spreadsheet, there are 5 categories listed. So, the database tables would be:

Fig: 1