Help:COAP-3180/week4

Week 4 - COAP 3180

Topics Covered

• Principles of PHP programming
• Simple PHP/MySQL interaction
• Installation of Portalware

Classroom activities

• Use of PhP/MySQL generators

Midterm exam

Main subjects will be SQL and a little bit of database design. "Minor" subject will be web application architecture (high level principles)

SQL:

• SELECT
  • SELECT ... WHERE, INSERT ... ORDER
  • Joins (select from two tables)
• CREATE
  • Data types: Integer, Float, VarChar, text
  • DEFAULT, NOT NULL, Auto increment
  • Keys
  • Primary keys
• INSERT (both forms(
• UPDATE / DELETE
• DROP

Database design:

• Simple 2-3 table architectures
• 1 to N and N to N relations between tables

Exam will be "open book". I will include a set of various tasks (e.g. a simple design problem, repair problems, conceptual questions)

Homework 4

Generate and configure an web application based on SQL table definitions.

Details TBA

Submission Dates

• This homework is due at start of wednesday week 5
• Students must provide the URL (where the instructor can see the widget) in the world classroom
• Each homework counts 10% in your global evaluation. The four best homeworks will be taken into account.

Evaluation

TBA

Links and teaching materials

Online software

Teaching materials