Assignment 11Using the attached requirements, create a PHP form, MySQL database, and insert the data into the database for shopping cart CRUD application.

Submission Requirements

1. Use the Validator to check your HTML code. https://validator.w3.org/
2. Add CSS to your submission such that it is well-designed and unique.
3. Your code should be debugged and working as described with no errors.
4. Be sure to comment your code.
5. Upload as ZIP file to D2L/BrightSpace

Outcomes should be unique! I am only a guide; not 'the answer'!!

Provide Screenshots of your DB AND include an Export of your SQL.

https://www.youtube.com/watch?v=CHpGV6QlGMQ - Walkthrough - Easier but arguably 'worse' way

https://www.youtube.com/playlist?list=PL7uL2ZFbXj1JE8YfNG9_u-PiFh8qeb6i6 - Walkthrough - Harder but 'better' way

ITEC 3280– Web Programming
Assignment 11
______________________________________________________________________________
PHP Form Processing and MySQL Database
Part I – product_order.php
Create a form page called product_order.php that contains the following form controls:
Product (drop down list) product – iPad, iPhone 6S, Galaxy 5S, Moto X, and so on
Quantity (number) quantity
Unit Price (number) unit_price
Discount Rate (%)(number) discount_rate
Order Date (date) order_date
First Name (text box) first_name
Last Name (text box) last_name
Payment Type (drop down list) payment_type – Visa, Master, Discover, Amex, and so on
Card Number (text box) card_number
Security Code (text box) security_code
When the submit button is clicked, the form data is posted to order_process.php. Part II– Create MySQL Database and Table
Using MySql, create a database called “ordersdb” and then create a table called “orders” with the following
fields:
id (INT, Primary Key, Auto Number)
product (VARCHAR, 100)
quantity (INT)
unit_price (DECIMAL)
discount_rate (DECIMAL)
order_date (DATE)
first_name (VARCHAR, 50)
last_name (VARCHAR, 50)
payment_type (VARCHAR, 15)
card_number (VARCHAR, 20)
security_code (VARCHAR, 10) Create a pair of user name and password (e.g, user1 and pass1) by using the following settings.
- Username: user1
Password: pass1
Host: Local
Check all privileges under Data and Structure sections Then edit user1’s privileges to grant all privileges of the “ordersdb” so that the user1 can access to the
database.
Once the sales table is created, export the “ordersdb” using SQL format and submit with other files.
Part III – Create Connection File
Create a new PHP file named “connection.php”. This file will contain the connection string to connect to the
“ordersdb”.
<?php
// if you use a different port, please use that port number
$con=mysqli_connect("localhost:3306","user1","pass1","ordersdb");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?> Part IV– order_process.php
Create and use a SQL INSERT statement to add the user loan input data into the orders table created in Part II.
To execute the insert statement, use mysqli_query function as follows.
//Execute SQL Statement and store results as a recordset
$rs = mysqli_query($con, $sqlstring);
As you have done in assignment 10, the page should also include a header and footer file. Use the PHP
include() or require() function. The header file (header.php) contains the page heading (use an h2 tag) – “ABC
Loan Company”. The footer file (footer.php) contains the page footing – copyright 2014 and your email
address.
Also, use the PHP include() or require() function to include the connection.php.
Next, add the code to insert the user input into the “orders” table. (Be sure to use scalar variables within the
SQL INSERT statement). After the INSERT statement is executed, close the connection to the database.
Finally, display the output:
PRODUCT ORDER
Name: firstnamevariable + lastnamevariable
Product: productvariable
Unit Price: unitpricevariable Discount Rate: discountratevariable
Order Total: ordertotalvariable
Order Date: orderdatevariable
Payment Information:
paymenttypevariable + creditcardnumbervariable (= 12 stars (*) + last 4 digit numbers )
Today’s Date is: PHP Date

• 1493174745-Assignment11.docx

ComputerScienceExpert

(11)

Status NEW Posted 26 Apr 2017 02:04 AM My Price 11.00

-----------

Attachments

file 1493174747-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer