Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a file named hw7a.htm. A table with a header row that displays all the field names in the SALES table of your database should

Write a file named hw7a.htm. A table with a header row that displays all the field names in the SALES table of your database should be initially visible. This file should have a form with a text field for a user to enter a CUSTOMERID. With each keyup event, an AJAX request is made to a file named hw7a.php.

hw7a.php will take the customerID as a parameter, and produce a response that will consist of a JavaScript function call. If there is no customerID in the SALES table that starts with what is in the textfield, the function call should be not_there(). If there are customerIDs in the database table that start with what is in the text field, the function call should be there(), and it should have arguments that are all the fields of those records in the SALES table.

When hw7a.htm receives the response, it should evaluate the function that was returned.

The not_there() function should delete all rows from the table other than the header row.

The there() function should dynamically create rows in the table to display the values.

Make sure that you upload your files into the public_html directory of your cislinux account.

Send me an email when you are finished that includes the full URL of your homework assignment.

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_2

Step: 3

blur-text-image_3

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 Design And SQL For DB2

Authors: James Cooper

1st Edition

1583473572, 978-1583473573

Students also viewed these Databases questions

Question

What is Working Capital ? Explain its types.

Answered: 1 week ago