https://techschool.murraygunn.id.au/wiki/ 2026-04-12T05:56:20+00:00 https://techschool.murraygunn.id.au/wiki/ https://techschool.murraygunn.id.au/wiki/lib/tpl/dokuwiki/images/favicon.ico text/html 2023-08-16T09:33:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://techschool.murraygunn.id.au/wiki/doku.php?id=en:web_development:databases:exercise&rev=1692203632&do=diff Web Development Lesson 7 - Databases Exercises Objective In this activity you'll use information extracted from a database to display player data in your project. Setup * Create a file called 'players.php' in your 'project' directory in Visual Studio Code. text/html 2023-08-16T09:33:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://techschool.murraygunn.id.au/wiki/doku.php?id=en:web_development:databases:joins&rev=1692203632&do=diff Web Development Lesson 7 - Databases Joins Objective In this activity you'll use data from two tables and you'll learn why separating data into multiple tables is a good idea. Setup * We'll use PHPMyAdmin again to run our queries, so log in to that and open the database for your class. text/html 2023-08-16T09:33:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://techschool.murraygunn.id.au/wiki/doku.php?id=en:web_development:databases:php&rev=1692203632&do=diff Web Development Lesson 7 - Databases PHP Database Connection Objective In this activity you will use PHP to connect to the database and run a query. Setup * Create a new file called 'mysql.php' in your top level directory in Visual Studio Code. text/html 2023-08-16T09:33:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://techschool.murraygunn.id.au/wiki/doku.php?id=en:web_development:databases:summary&rev=1692203632&do=diff Web Development Lesson 7 - Databases Summary In this lesson, we covered the following concepts for databases. HTML Tags CSS * flex-direction * flex-wrap PHP * PDO * prepare * execute * try / catch * fetch SQL * table * SELECT * NULL * LEFT JOIN * index Tools * PHPMyAdmin Next Lesson: Forms text/html 2023-08-16T09:33:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://techschool.murraygunn.id.au/wiki/doku.php?id=en:web_development:databases:tables&rev=1692203632&do=diff Web Development Lesson 7 - Databases Tables Objective In this activity you will use a new tool to get a good look at the structure of a database. Setup There is nothing to set up in this exercise. Tool: PHPMyAdmin * There are many databases available that all meet our needs, but we'll be using MySQL, which is one of the most popular for use with PHP.