Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need to write this query in PHP Language for a local host webpage. I have already created and loaded the table in my phpmyadmin. the

Need to write this query in PHP Language for a local host webpage. I have already created and loaded the table in my phpmyadmin. the tables and instructiions are below

Prompt the user to input part no, and display information of all suppliers who shipped

that part. Make sure there is no SQL injection vulnerability.

-- Load the data in Supplier table

INSERT INTO SUPPLIER(Sno, Sname, Status, City)

VALUES

('s1', 'Smith', 20, 'London'),

('s2', 'Jones', 10, 'Paris'),

('s3', 'Blake', 30, 'Paris'),

('s4', 'Clark', 20, 'London'),

('s5', 'Adams', 30, NULL)

;

-- Load data into Part Table

INSERT INTO PART (Pno, Pname, Color, Weight, City)

VALUES

('p1', 'Nut', 'Red', 12, 'London'),

('p2', 'Bolt', 'Green', 17, 'Paris'),

('p3', 'Screw', 'NULL', 17, 'Rome'),

('p4', 'Screw', 'Red', 14, 'London'),

('p5', 'Cam', 'Blue', 12, 'Parris'),

('p6', 'Cog', 'Red', 19, 'London')

;

-- Load the data into Shipment table

INSERT INTO SHIPMENT (Sno, Pno, Qty, Price)

VALUES

('s1', 'p1', 300, .005),

('s1', 'p2', 200, .009),

('s1', 'p3', 400, .004),

('s1', 'p4', 200, .009),

('s1', 'p5', 100, .01),

('s1', 'p6', 100, .01),

('s2', 'p1', 300, .006),

('s2', 'p2', 400, .004),

('s3', 'p2', 200, .009),

('s3', 'p3', 200, NULL),

('s4', 'p2', 200, .008),

('s4', 'p3', NULL, NULL),

('s4', 'p4', 300, .006),

('s4', 'p5', 400, .003)

;

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

Database Basics Computer EngineeringInformation Warehouse Basics From Science

Authors: Odiljon Jakbarov ,Anvarkhan Majidov

1st Edition

620675183X, 978-6206751830

More Books

Students also viewed these Databases questions