Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment Instructions Tasks 1) Create an initial HTML page titled tasks.html with buttons to do the following. (You may need a separate HTML form for

image text in transcribed

Assignment Instructions Tasks 1) Create an initial HTML page titled tasks.html with buttons to do the following. (You may need a separate HTML form for each button- don't use links, use buttons). a. Button "View Customers" links to viewCustomers php. b. Button "View Actors" links to viewActors.php. 2) viewCustomers . php should display an html table with all customers, sorted by last name. List the following information: last name, first name, email address, address, city, district, country. Each field for each record should be in its own table cell. You should have a button that takes you back to the initial html page tasks.html. 3) viewActors php this page should display an html table that has 2 columns. The first column will be the actor name, the second column will be a list of movies that the actor appears in. The html table should be sorted by actor last name. This page should have a button that takes you back to tasks.html Hints Actor last names are not unique, but full names are. Therefore you can concatenate a lastname with a firstname to create a unique key for an associative array. (Use the actor ID to query which movies an actor was in, or use BOTH first and last name. Create your queries in DBeaver before trying to put them into PHP Part 1 and 2 above are more simple than part 3. Do them first. For Part 3, first display all actor names. Then work on appending the films for each actor

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 Concepts

Authors: David Kroenke, David J. Auer

3rd Edition

0131986252, 978-0131986251

More Books

Students also viewed these Databases questions

Question

What is DDL?

Answered: 1 week ago