I have a php page (seen below) that accepts a name and checks for validation. Upon Submission I need to print out the complete row for a person in the customer table from my SQL below, that has as lastName the name that was entered.

-------------PHP page---------------------------------------

Assignment 4

alert("Enter name");'; } else { $names=test_input ($_POST ["NAME"]);

if(!preg_match("/^[a-zA-z ]*$/",$names)) { echo ''; } } } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } ?>

Name:

----------------SQL Statements--------------------------------------------------------

CREATE TABLE Employee ( EID int NOT NULL PRIMARY KEY, FirstName varchar(255), LastName varchar(255) NOT NULL, Zip int );

CREATE TABLE Customer ( CID int NOT NULL PRIMARY KEY, FirstName varchar(255), LastName varchar(255) NOT NULL, Street varchar(255), City varchar(255), Zip int );

CREATE TABLE Part ( PID int NOT NULL PRIMARY KEY, pName varchar(255), price float, quantity int );

CREATE TABLE Telephone ( TID int NOT NULL PRIMARY KEY, phoneNumber int, EID int, FOREIGN KEY (EID) REFERENCES Employee(EID) );

CREATE TABLE Orders ( OID int NOT NULL PRIMARY KEY, rdate date, sdate date, CID int, EID int, FOREIGN KEY (CID) REFERENCES Customer(CID), FOREIGN KEY (EID) REFERENCES Employee(EID) );

CREATE TABLE PartOrder ( POID int NOT NULL PRIMARY KEY, quantity int, PID int, OID int, FOREIGN KEY (PID) REFERENCES Part(PID), FOREIGN KEY (OID) REFERENCES Orders(OID) );

INSERT INTO Employee (EID, FirstName, LastName, Zip) VALUES (10, 'Brian', 'Money', 56349);

INSERT INTO Employee (EID, FirstName, LastName, Zip) VALUES (25, 'Allan', 'Turing', 58102);

INSERT INTO Customer (CID, FirstName, LastName, Street, City, Zip) VALUES (05, 'Donald', 'Knuth', '123 Ave.', 'Fargo', 58102);

INSERT INTO Customer (CID, FirstName, LastName, Street, City, Zip) VALUES (03, 'John', 'McCarthy', '123 St. N.', 'Minneapolis', 56542);

INSERT INTO Telephone (TID, phoneNumber, EID) VALUES (8, 3202225555, 25);

INSERT INTO Telephone (TID, phoneNumber, EID) VALUES (9, 3206667777, 10);

INSERT INTO Part (PID, pName, price, quantity) VALUES (998, 'Struts', 150, 2);

INSERT INTO Part (PID, pName, price, quantity) VALUES (0968, 'Rotor', 45, 4);

INSERT INTO Orders (OID, rDate, sDate, CID, EID) VALUES (026843547, '24-JAN-2017', '24-JAN-2017', 05, 10);

INSERT INTO Orders (OID, rDate, sDate, CID, EID) VALUES (054613214, '24-JAN-2012', '24-JAN-2012', 03, 10);

INSERT INTO PartOrder (POID, quantity, PID, OID) VALUES (23, 1, 998, 054613214);

INSERT INTO PartOrder (POID, quantity, PID, OID) VALUES (24, 1, 0968, 026843547);