Business and technology qualifications, Levels 3-6, in Brussels. Explore qualifications
Portal login
Level 5 Diploma in Cyber Security

Building a PHP web application on the database, including a basic login system

CYB502 · Databases — Week 11 of 16

CourseCYB502
Week11 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Building a PHP web application on the database, including a basic login system

  1. PHP to access and update an SQL database for practical applications
  2. How PHP can be used to interface with databases in server-side applications

What you will be able to do

  • 3.3 Use PHP to access and update an SQL database for practical applications.
  • 3.4 Explain how PHP can be used to interface with databases in server-side applications.

Activity

Seminar, guided reading and a short written task: use PHP to access and update an SQL database for practical applications.

Study materials

The teaching notes, exercises and videos of this week are in the student portal. Your portal is set up as soon as you receive final acceptance, so you can open them before the semester starts.
Week 10Week 12
Course chat

Admitted students ask questions on this week’s page in the student portal: an AI assistant trained on the course answers first, and during the course’s timetabled classes Connect to your tutor brings your tutor into the chat, who may start a call if needed.

Open this week in the portal
Course plan
  • Week 1: Database concepts: tables (entities), attributes and relati…
  • Week 2: Database models (hierarchical, network, relational) compare…
  • Week 3: Database management systems: MySQL, PostgreSQL and MongoDB …
  • Week 4: Queries and views; introduction to SQL: SELECT, INSERT, UPD…
  • Week 5: Requirements gathering and entity-relationship diagrams for…
  • Week 6: Normalisation using normal forms: reducing redundancy and i…
  • Week 7: Converting an ER diagram to SQL and deploying the schema in…
  • Midterm: Midterm evaluation
  • Week 9: SQL queries for extracting, updating and manipulating recor…
  • Week 10: Server-side programming with PHP: HTTP GET and POST, connec…
  • Week 11: Building a PHP web application on the database, including a…
  • Week 12: Applying Databases in practice: case studies
  • Week 13: Assignment workshop: research, planning and referencing
  • Week 14: Assignment workshop: drafting, feedback and improvement
  • Week 15: Review and coursework completion
  • Final: Final assessment and submission
Back to the course
Scroll