Data from a Database using PHP and mysql

Getting Started

• dept-txt.php - produces text file from simple query

  SELECT distinct department, department_code 
  FROM ext_courses 
  ORDER BY department

• department-simple.php - produces HTML listing of department names

Departments and Courses

• departments.php - produces list of departments that are linked to courses.php that uses a department_code query string parameter.
• courses.php uses uses a department_code query string parameter, e.g.
  course.php?department_code=CSCI for CSCI
  course.php?department_code=DGMD for DGMD.

Departments and Courses using Mustache Templates

• mustache-dept.php - separates PHP logic from HTML view using Mustache templates.
• mustache-courses.php?department_code=CSCI - separates PHP logic from HTML view using Mustache templates.

Departments and Courses - Front End JS and Back-end JSON

• departments.html - uses JavaScript on front-end and JSON produced by PHP and mysql query on the back-end.
• json-dept.php is the JSON structure for departments
• json-courses.php?department_code=CSCI is the JSON structure for courses in CSCI
• course.html?department_code=CSCI for CSCI

ext_courses table