Course: Web Applications for Everybody (WA4E)

Hello and welcome to my site where you can work through these modules and learn to develop PHP-based database-backed web applications.

You can download all the modules in a single cartridge, or you can download any combination of the modules.

Generic (CC 1.2) is a standards-only Common Cartridge with no LMS extensions. Generic (CC 1.1) and Moodle are the same Generic content as Common Cartridge 1.1 only. Tsugi and Canvas share Canvas's cartridge format so a Canvas export can import into Tsugi later. Sakai's cartridge format has significant overlap with Canvas's. When exporting to an LMS that is not on this list, use one of the Generic formats to be safe.

Modules: 22

Resources: 178

Assignments: 0

Discussion topics: 22

Slide, reference, assignment, and solution links scanned: 106

Available for a thick cartridge: 36 file(s)

Will remain as web links even in a thick cartridge: 70

Files a thick cartridge would include:

  • code/arrays.zip
  • code/css.zip
  • code/forms.zip
  • code/handlebars.zip
  • code/html.zip
  • code/javascript.zip
  • code/jquery-01.zip
  • code/json-01.zip
  • code/json-02-chat.zip
  • code/json-03-crud.zip
  • code/objects.zip
  • code/route.zip
  • code/sessions.zip
  • lectures/JS-01-JavaScript.ppt
  • lectures/JS-02-JavaScript-Objects.ppt
  • lectures/JS-03-JQuery.ppt
  • lectures/JS-04-JSON.ppt
  • lectures/JS-05-Handlebars.ppt
  • lectures/PHP-01-Overview.ppt
  • lectures/PHP-02-Arrays.ppt
  • lectures/PHP-03-Functions.ppt
  • lectures/PHP-04-Forms.ppt
  • lectures/PHP-05-Objects.ppt
  • lectures/PHP-06-MySQL-PDO.ppt
  • lectures/PHP-07-Cookies-Sessions.ppt
  • lectures/PHP-08-POST-Redirect-Authn.ppt
  • lectures/PHP-09-CRUD.ppt
  • lectures/SQL-01-MySQL-Handout.txt
  • lectures/SQL-01-MySQL.ppt
  • lectures/SQL-02-MySQL-Design-Handout.txt
  • lectures/SQL-02-MySQL-Design.ppt
  • lectures/SQL-15-Advanced-SQL.ppt
  • lectures/SQL-16-MySQL-Transactions.ppt
  • lectures/Web-01-HTTP.ppt
  • lectures/Web-02-HTML.ppt
  • lectures/Web-03-CSS.ppt

LTI items scanned: 42

Look like GIFT quizzes: 16

Readable GIFT on disk (available to convert to QTI): 16

Will remain as LTI: 26

GIFT files a QTI conversion would include:

  • 00-CSS.txt
  • 00-HTML.txt
  • 01-Request-Response.txt
  • 02-Arrays.txt
  • 02-PHP.txt
  • 03-Forms.txt
  • 03-Functions.txt
  • 05-Routing.txt
  • 05-Session.txt
  • 06-SQL-Queries.txt
  • 07-Database-Models.txt
  • 08-PDO.txt
  • 08-PHP-Objects.txt
  • 09-JavaScript-Objects.txt
  • 09-JavaScript.txt
  • 10-JQuery.txt

Select the modules to include, and download below. You must select at least one module.

Generic (CC 1.2) is a standards-only Common Cartridge with no LMS extensions. Generic (CC 1.1) and Moodle are the same Generic content as Common Cartridge 1.1 only. Tsugi and Canvas share Canvas's cartridge format so a Canvas export can import into Tsugi later. Sakai's cartridge format has significant overlap with Canvas's. When exporting to an LMS that is not on this list, use one of the Generic formats to be safe.

Introduction to Dynamic Web Content
  • Resources in this module: 8
  • Discussions in this module: 1
  • Files available for a thick cartridge: 1
  • GIFT quizzes available to convert to QTI: 1
HyperText Markup Language (HTML)
  • Resources in this module: 8
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
Cascading Style Sheets (CSS)
  • Resources in this module: 12
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
Installing PHP and SQL
  • Resources in this module: 7
  • Discussions in this module: 1
Introduction to PHP
  • Resources in this module: 8
  • Discussions in this module: 1
  • Files available for a thick cartridge: 1
  • GIFT quizzes available to convert to QTI: 1
PHP Arrays
  • Resources in this module: 10
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
PHP Functions
  • Resources in this module: 7
  • Discussions in this module: 1
  • Files available for a thick cartridge: 1
  • GIFT quizzes available to convert to QTI: 1
PHP Forms
  • Resources in this module: 15
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
Introduction to Structured Query Language (SQL)
  • Resources in this module: 8
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
Database Design
  • Resources in this module: 11
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
PHP Objects
  • Resources in this module: 7
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
PHP and MySQL
  • Resources in this module: 10
  • Discussions in this module: 1
  • Files available for a thick cartridge: 1
  • GIFT quizzes available to convert to QTI: 1
PHP Cookies and Sessions
  • Resources in this module: 7
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
PHP Routing, Redirect and Authentication
  • Resources in this module: 11
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
Building a CRUD Application
  • Resources in this module: 5
  • Discussions in this module: 1
  • Files available for a thick cartridge: 1
Basic JavaScript
  • Resources in this module: 11
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
JavaScript Objects
  • Resources in this module: 1
  • Discussions in this module: 1
  • Files available for a thick cartridge: 1
  • GIFT quizzes available to convert to QTI: 1
jQuery
  • Resources in this module: 10
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
  • GIFT quizzes available to convert to QTI: 1
JSON - JavaScript Object Notation
  • Resources in this module: 12
  • Discussions in this module: 1
  • Files available for a thick cartridge: 4
Handlebars UI Templates
  • Resources in this module: 5
  • Discussions in this module: 1
  • Files available for a thick cartridge: 2
Advanced SQL
  • Resources in this module: 3
  • Discussions in this module: 1
  • Files available for a thick cartridge: 1
SQL Transactions
  • Resources in this module: 2
  • Discussions in this module: 1
  • Files available for a thick cartridge: 1