WEB-230-110-112 | Introduction to phpMyAdmin | Assignment
Complete the following:
- Create a database named “a_database” as done in the video.
- Create a table named “users” in your “a_database” database as done in the video.
- Create the following fields in the “users” table as done in the video.
- id
- username
- password
- take a screenshot of the table structure view after creating the user as in the video.
- Save the screenshot to the “series/intro-to-phpmyadmin/” folder using the file name
“web-230-110-112-intro-to-phpmyadmin-001.jpg”
- Save the screenshot to the “series/intro-to-phpmyadmin/” folder using the file name
- Insert the following users in to the “users” table in the “a_database” database as in the video.
- insert the username “student” and the password “raccpass” as in the video.
- insert the username “billy” and the password “pass123” as in the video.
- navigate to the browse view and take a screenshot as in the video.
- Save the screenshot to the “series/intro-to-phpmyadmin/” folder using the file name
“web-230-110-112-intro-to-phpmyadmin-002.jpg”
- Save the screenshot to the “series/intro-to-phpmyadmin/” folder using the file name
- navigate to the browse view and take a screenshot as in the video.
- Create the following fields in the “users” table as done in the video.
- Update the following users to include their first and surnames as in the video.
- add the following information to the student user
- update the first name to “Napoleon”
- update the surname to “Dynamite”
- add the following information to the billy user
- update the first name to “Billy”
- update the surname to “Garrett”
- take a screenshot of the browse view of the user table after updating the user as in the video.
- Save the screenshot to the “series/intro-to-phpmyadmin/” folder using the file name
“web-230-110-112-intro-to-phpmyadmin-003.jpg”
- Save the screenshot to the “series/intro-to-phpmyadmin/” folder using the file name
- add the following information to the student user
- Export your databas and save it to your “series/intro-to-phpmyadmin/” folder.
- navigate to the “a_database” in phpMyAdmin.
- navigate to the “Export” tab in phpMyAdmin.
- click the “Go” button to export the database.
- save the downloaded file “a_database.sql” to your “series/intro-to-phpmyadmin/” folder.
Submitting Assignment:
Save folders and file named “series/intro-to-phpmyadmin/” in your GitHub “WEB-230-Assignments” repository and submit a link to the “series/intro-to-phpmyadmin/” folder in your repository.
Your submission should look similar to the following:
GitHub Repository for: series/intro-to-phpmyadmin