Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Post
by answerhappygod »
The HTML code of the EmployeeOrder.html page is given
below:
employeeOrder.html
<body>
<form name="form">
Employee ID <input type="text" id="employeeID"
onChange="findOrder()"/>
<div id="orders"></div>
</form> </body>
a) Complete the code of the given page by creating the
javascript function findOrder(). The function must perform an
asynchronous request to the server that calls the page
findOrder.php.
b) Create the page findOrder.php which for employee(EmployeID)
taken from the text field with the ID employeeID returns the list
of all orders(OrderID) which this employee has recieved, separated
by a semicolon(;) from each other. The returned order list to be
displayed on a div with the ID(orders). The employee and order
information to be stored on the table Orders(OrderID, EmployeeID,
CustomerID) on the northwind database. The credentials to access
the database: servername - localhost, username - admSys, password -
admin123$.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!