Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!