Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create PHP Page with SQL table and database connected: Using part 1 folders data, create a database and a table containing your favorite song list.

Create PHP Page with SQL table and database connected:

  1. Using part 1 folders data, create a database and a table containing your favorite song list. (I completed the creation of this table in PHPMyAdmin in Ubuntu and provided the sql file in part 2 folder)

The folders above can be found in a z i p file:

    1. Go to url-encode-decode (dot) c-o-m
    2. Paste the following code (without parentheses and spaces) and hit the decode URL button: (h) (t) (t) (p) (s) %3A%2F%2Ftinyurl ( . ) com%2Fyxmm22bm
  1. Create a page that reads the database table and displays its content in a table with visible lines.
  2. Create a page to be able to add a new record on the table.
  3. Create a page to be able to update a new record on the table.
  4. Create a page to be able to delete a record from the table.
  5. Don't use the same page to update, insert, or delete a record.
  6. Validate the insert and update of a new record. A user should not be able to insert garbage data into you table.
  7. All pages should have menu buttons to move to the different pages.
  8. Add colors, images, and a copyright with your name (the copyright should go at the bottom of all pages).
  9. Provide your codes and database backup. I should be able to just run your script and the database with the table should be created. (Please provide all the codes [preferably done through PHPMyAdmin in Ubuntu] in a z i p file, upload it to a cloud service, and then encode its public sharing URL like how I did way above)
  10. ALL Requirements have to be met.

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

More Books

Students also viewed these Databases questions