Te Kete Ipurangi Navigation:

Te Kete Ipurangi
Communities
Schools

Te Kete Ipurangi user options:


Senior Secondary navigation


RSS

Programme 3 – Database

Developed by Jennifer Gottschalk, Whangaparaoa College, 2018

This programme is based on flipped learning pedagogy and uses an eBook tutorial that includes embedded video. Students are provided with detailed instructions and walk-throughs showing how to create a fully functioning, refined database and website using HTML, CSS, SQL, and PHP. It is assumed that students have previously completed teaching and learning on web (and/or completed the achievement standard 91880: Develop a digital media outcome) and are able to create basic HTML and CSS websites.

Students will:

  • create a simple database via PHPMyAdmin’s dashboard
  • repurpose a simple website so that it can be used to display information held in the database
  • query the database and display the results on a web page.

Programme 3 – Database materials

 

Videos

  1. Common errors
  2. Database introduction
  3. Database planning
  4. Index setup
  5. Formatting includes
  6. Side setup
  7. Database setup
  8. dbconnect
  9. Get all data
  10. Show title
  11. Show all
  12. Title search form
  13. Title search working
  14. Data sanitisation
  15. Author genre search
  16. Ratings search
  17. Query testing
  18. Usability testing
  19. Genre options part 1
  20. Genre options part 2
  21. Magnifying glass
  22. Exporting SQL
  23. Database testing

Last updated March 10, 2020



Footer: