ICCT logo

Internal academy

ICCT Training Library

Application Development

PHP & MySQL for School Systems

Teach the server-side foundation behind forms, records, dashboards, and lightweight internal tools similar to school operations software.

Intermediate 3 credits 50+ guided hours 6 weeks Modules: 3 Projects: 2

Easy Interactive curriculum

App Garage for short, easy-to-digest learning

This course breaks big application development ideas into short missions, plain-language definitions, and interactive practice rounds. Teach the server-side foundation behind forms, records, dashboards, and lightweight internal tools similar to school operations software.

Class missions: 3 10 minutes per topic Lab + quiz + homework + game

Class mission

Server-side request handling

Minutes: 20

Big idea: What happens after a browser submits a form. We keep it simple, hands-on, and easy to explain back.

10 min

Reading requests and validating input

Form means the part of a page where people type and send information In this topic we use it for form data, required checks, and helpful errors.

Quick picture: imagine using this in training request portals.

Mission: use Form to practice form data, required checks, and helpful errors.

Form PHP MySQL Reading Requests
10 min

Rendering views and feedback messages

PHP means a server language that builds pages and handles form or data work In this topic we use it for server responses, state, and confirmation patterns.

Quick picture: imagine using this in faculty office-hours boards.

Mission: use PHP to practice server responses, state, and confirmation patterns.

PHP MySQL Rendering Views Server-side Request

Word wall

Terms made easy

Form

the part of a page where people type and send information

PHP

a server language that builds pages and handles form or data work

MySQL

a database that stores rows of information you can search and update

Reading Requests

one part of the lesson that helps students notice what the tool, page, or process is doing

Lab mission

Lab Mission

Build a program-request form that returns clean validation feedback and a confirmation screen.

  1. Look at one example from training request portals and point to where Form shows up.
  2. Build one tiny version that uses Form and PHP in the right place.
  3. Tell a teacher or partner what you changed, what worked, and what you would improve next.
Homework

Homework: teach Form in your own words, then create crud admin page with one example, one picture, or one tiny screenshot.

Quick quiz

Check understanding in a friendly way

Game mode

Term Match Sprint

Matches: 0 / 4

Match each word to the right meaning as fast as you can.

Words
Meanings

Pick a word, then pick the matching meaning.

Outcomes

What students should leave with

  • Handle requests, validate input, and save data to MySQL tables.
  • Build CRUD patterns for internal directories, forms, and schedules.
  • Use sessions, server rendering, and safe database access for school-ready tools.

Reference map

Core topics to cover

Request flow Sanitizing input Prepared statements Sessions CRUD patterns Flash messages Routing basics

Module sequence

ICCT lesson flow

Module 1

Server-side request handling

Lessons: 2

What happens after a browser submits a form.

Reading requests and validating input

form data, required checks, and helpful errors

Rendering views and feedback messages

server responses, state, and confirmation patterns

Checkpoint lab

Build a program-request form that returns clean validation feedback and a confirmation screen.

Module 2

Database-backed records

Lessons: 2

Move from forms into reliable storage and retrieval.

Tables, inserts, and updates

prepared statements and consistent field mapping

Listing, editing, and archiving records

basic admin views and data lifecycles

Checkpoint lab

Create an office-hours management tool that stores staff availability and room details.

Module 3

Protected internal tools

Lessons: 2

Add accountability and user context to simple school systems.

Sessions, roles, and small permissions

login-protected utilities and user scope

Quality, security, and operational handoff

safe defaults, backups, and review habits

Checkpoint lab

Turn a public-facing tool into a staff-only system with login, role checks, and record ownership.

Capstone prompts

Projects students can actually ship

Training Request Portal

Staff submit workshop needs, administrators review them, and records stay searchable.

Faculty Office Hours Board

Teachers manage time blocks, locations, and student visit slots in a small internal app.