Tech School

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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.
  * Change the Language Mode to HTML in the bottom right corner.
  * Set up the page to include 'header.php', 'menu.php' and 'footer.php'.

==== Database ====
  * Add code to connect to the database 'players'.
  * Set a variable called 'player' to 1.
  * Query the table 'players' for all fields.
  * Store all fields as variables.
  * Display the information as in LINK. Or create your own design. Here are some tips.
    * Set <html><body></html> as flex with <html>flex-direction: column</html>. This creates a vertical flex box.
    * Set <html>height</html> of <html><html></html> and <html><body></html> to 100%.
    * Set <html>flex: 5</html> for <html><main></html>, which ensures <html><main></html> is given 5 times more vertical space than the other elements.
    * Set <html><main></html> to flex display.
    * Set <html><main></html> to <html>flex-wrap: wrap</html>

[[en:web_development:databases:summary|Next: Summary]]

Tech School

User Tools

Site Tools

Page Tools