Please create an html web page where the discount calculator will be created and the functionality will be implemented. Also, link it with the PHP. The first page (index.html)| Product Discount Calculat xC D localhost/book_apps/ch02_product_discount/Product Discount CalculatorProduct Description:GuitarList Price:1250Discount Percent:12.5Calculate DiscountThe second page (product_discount.php)Product Discount CalculatC D localhost/book_apps/ch02_product_discount/display_di:☆Product Discount CalculatorProduct Description:GuitarList Price:$1,250.00Standard Discount:12.5%Discount Amount:$156.25Discount Price:$1,093.75The first page is a static page and it is stored as "index.html"The second page is a dynamic page and it is sired as "product_description.php"In the first page when you click on calculate discount button, the data will sent to the php file as postrequest, then the php file will response with the calculated discount as you can see in the figure. Your task is to write a simple product list application that lets you display the product data by category.You can choose the types of product you want to display. You should at least include three categoriesand include at least 5 products from each category. Inside the data base you should store at least 3pieces of information for each category. The PHP code should be pulling the products from thedatabase.This is an exampleOMy Guitar ShopC D localhost/book apps/ch04_product viewer/Product ListCategoriesGuitarsGuitarsCodeNamePriceFender Stratocasterstratles_paul Gibson Les PaulBasses699 00Druma1199.002517 00489.99Gibson SGfg700swashburn Washburn D10Srodriguez Rodriguez Caballero 11Yamaha FG700S299.00415 00When you click on the name if the category that will direct you to the list of products of that category.Furthermore, you will need to make a new page that allows you to add new product and put ininformation to add a new product. This information should be added to the database with PHP.Requirements• Add all products to a MYSQL databaseMake PHP pull product information from the MYSQL database:When you click on the name of the category that will direct you to the list of products of thatcategoryAdd a link with a text "add new product", when you click on the link that will direct you to a newpage to enter all the information of a new product then add a new product to the database.• Your code should be structured perfectly and has great spacing and indentation.Your code should be intensively commented in such a manner as Concise, meaningful, well-formatted, and easy to understand by any one

Note- as the question picture is multipart, as per our company guidelines, i can only answer the…

The first page is a static page and it is stored as "index.html" The second page is a dynamic page and it is sired as "product_description.php" In the first page when you click on calculate discount button, the data will sent to the php file as post request, then the php file will response with the calculated discount as you can see in the figure.

The first page is a static page and it is stored as "index.html" The second page is a dynamic page and it is sired as "product_description.php" In the first page when you click on calculate discount button, the data will sent to the php file as post request, then the php file will response with the calculated discount as you can see in the figure.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 3.11CP

See similar textbooks

Similar questions

Table_rating table menu table_menu_type table_user menu_type_ID rating ID menu ID user_ID placed • type_name • description # menu_ID • remarks • data_recorded: date # customer ID • menu_name # price #menu_type ID • menu image ingredients #menu_status • full_name • contact • email address * username • password assigned represent table_payment payment_ID 4 order ID C# amount paid_by -payment_date # processed_by | assigned to table_customer customer_ID • Customer_first_name • customer_last_name • customer_middle_name • customer_email • customer_phone_number • customer_landline • profile_image • customer_usemame • customer password table_order_details I Jorder_details_ID include I l order_ID # menu_ID # amount # no of serving # total_amount table_site_info # account_status site_info_ID L • site_name • description • contact_info * address • last_update Huser_ID table_order part of placed by # customer_ID -order_date #total_amount Worder_status #processed_by pays orders Customers PK…
Submission guidelines: The assignment must be submitted by the deadline (earlier submissions are encouraged) in PDF format through Blackboard using the following file name format: LastName_FirstName_Assignment_1.pdf. The assignment must be typewritten. All the assignments in this course are individual work; any overlap between assignment reports will be penalized. A bank requires for their customers to access their online banking accounts to provide as User Id (or user name) the last 8 digits of their bank card number, and a password with a length between 8 and 12 ASCII characters, including the following restrictions (posted on their website): Passwords must have at least 8 characters long and at most 12 characters long, and must include at least one character from each of the following four character types: Upper case letters ABC DEF Lower case letters ghijkl Numbers 1 2 345 67890 Special characters ! @ # $ % ^ & * (+) = - The remaining characters of the password must be selected…
List the various BackgroundImageLayout attribute values for a form.
SQL: Add a table-level PRIMARY KEY constraint to the EMPLOYEE table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Create a PRIMARY KEY constraint on the DEPARTMENT table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Add a foreign key reference on the EMPLOYEE table that will ensure that the employee is not assigned to a nonexistent department. Confirm that the constraints were added by querying USER_CONSTRAINTS. Note the types and names of the constraints and include them in your statement comments. Display the object names and types from the USER_OBJECTS data dictionary view for EMPLOYEE and DEPARTMENT tables. You will want to format the columns for readability. Provide comments that include the new tables and indexes created. Modify the EMPLOYEE table by adding a SALARY column of NUMBER data type, precision 7. Confirm…
Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL Primary key is (HorseID, LessonDateTime) If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. Notes: Table and column names are case sensitive in the auto-grader. Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.
CREATE TABLE PRODUCT (PRODUCT_ID INTEGER PRIMARY KEY, "NAME" TEXT NOT NULL, PRICE REAL NOT NULL); CREATE TABLE CATEGORY ( CATEGORY_ID INTEGER PRIMARY KEY, "NAME" TEXT NOT NULL); CREATE TABLE PRODUCT_CATEGORY (PRODUCT_ID INTEGER, CATEGORY_ID INTEGER, PRIMARY KEY (PRODUCT_ID, CATEGORY_ID), FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT (PRODUCT_ID), FOREIGN KEY (CATEGORY_ID) REFERENCES CATEGORY (CATEGORY_ID)); Please write a SQL SELECT statement (a query) which will return the PRODUCT_ID and PRICE of the second highest priced product for *every category*. If there is a tie for the second highest price in a category, all of the tied products should be returned. The columns in your query results should be: CATEGORY_ID, PRODUCT_ID, PRICE
Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL Primary key is (HorseID, LessonDateTime) If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically.
COUNTRY_ID CHAR(2) PENBOXES COUNTRY_NAME VARCHAR2(40) REGION_ID NUMBER regions REGION_ID NUMBER REGION_NAME VARCHAR2(25) departments DEPARTMENT_ID NUMBER DEPARTMENT NAME VARCHAR2(30) MANAGER ID LOCATION ID NUMBER NUMBER countries employees EMPLOYEE ID FIRST NAME LAST NAME EMAIL PHONE NUMBER HIRE DATE JOB_ID SALARY NUMBER VARCHAR2(20) VARCHAR2(25) VARCHAR2(25) VARCHAR2(20) DATE VARCHAR2(10) NUMBER COMMISSION PCT NUMBER MANAGER_ID NUMBER DEPARTMENT ID NUMBER 81 locations LOCATION_ID NUMBER STREET_ADDRESS VARCHAR2(25) POSTAL CODE VARCHAR2(12) VARCHAR2(30) STATE PROVINCE VARCHAR2(12) CITY COUNTRY_ID jobs CHAR(2) JOB_ID VARCHAR2(10) JOB_TITLE VARCHAR2(35) MIN SALARY NUMBER MAX SALARY NUMBER
question 1Create a procedure that accepts a customer id and retrieves the id of the products and quantities that the customer ordered. Use an anonymous to call the procedure and output the result. question 2Create a procedure to insert a row into the product table with appropriate valuesUse an anonymous to call the procedure and output the result. creation code
CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY (artist_id)); CREATE TABLE TRACKS( track_id CHAR(30), track_name CHAR(30), duration INTL(10), tempo REAL, PRIMARY KEY (track_id)); CREATE TABLE USERS( user_id CHAR(30), user_name CHAR(30), age INT(5), nationality CHAR(30), num_track_listened INT(10), PRIMARY KEY (user_id)); CREATE TABLE RECORD( artist_id CHAR(30), track_id CHAR(30), PRIMARY KEY (artist_id, track_id), FOREIGN KEY (artist_id) REFERENCES ARTISTS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE LISTEN( user_id CHAR(30), track_id CHAR(30), PRIMARY KEY (user_id, track_id), FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE FOLLOW( user_id CHAR(30), artist_id CHAR(30), follow_date datetime, PRIMARY KEY (user_id, artist_id) FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (artist_id) REFERENCES ARTISTS); According to the six table, write a single SQL…
CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY (artist_id)); CREATE TABLE TRACKS( track_id CHAR(30), track_name CHAR(30), duration INTL(10), tempo REAL, PRIMARY KEY (track_id)); CREATE TABLE USERS( user_id CHAR(30), user_name CHAR(30), age INT(5), nationality CHAR(30), num_track_listened INT(10), PRIMARY KEY (user_id)); CREATE TABLE RECORD( artist_id CHAR(30), track_id CHAR(30), PRIMARY KEY (artist_id, track_id), FOREIGN KEY (artist_id) REFERENCES ARTISTS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE LISTEN( user_id CHAR(30), track_id CHAR(30), PRIMARY KEY (user_id, track_id), FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE FOLLOW( user_id CHAR(30), artist_id CHAR(30), follow_date datetime, PRIMARY KEY (user_id, artist_id) FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (artist_id) REFERENCES ARTISTS); According to the six table, write a single SQL…
CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY (artist_id)); CREATE TABLE TRACKS( track_id CHAR(30), track_name CHAR(30), duration INTL(10), tempo REAL, PRIMARY KEY (track_id)); CREATE TABLE USERS( user_id CHAR(30), user_name CHAR(30), age INT(5), nationality CHAR(30), num_track_listened INT(10), PRIMARY KEY (user_id)); CREATE TABLE RECORD( artist_id CHAR(30), track_id CHAR(30), PRIMARY KEY (artist_id, track_id), FOREIGN KEY (artist_id) REFERENCES ARTISTS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE LISTEN( user_id CHAR(30), track_id CHAR(30), PRIMARY KEY (user_id, track_id), FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE FOLLOW( user_id CHAR(30), artist_id CHAR(30), follow_date datetime, PRIMARY KEY (user_id, artist_id) FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (artist_id) REFERENCES ARTISTS); According to the six table, write a single SQL…