Help:COAP-3180/week4

Week 4 - COAP 3180

Topics Covered

Working with PHP and MySQL

• Principles of PHP programming
• Simple PHP/MySQL interaction
• Short overview of other application frameworks (.Net, J2EE)

Using PHP/MySQL webform generators:

• http://www.webformgenerator.com/ (Webform generator)
• http://www.sqlmaestro.com/products/mysql/phpgenerator/ (SQL Maestro PHP Generator)

Classroom activities

• Exploration of the PHP language
• Use of PhP/MySQL generators

Midterm exam (Wednesday)

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

Software, teaching materials and links

Software (installed in the Lab)

• http://www.webformgenerator.com/ (Webform generator)
• http://www.sqlmaestro.com/products/mysql/phpgenerator/ (SQL Maestro PHP Generator)
• A text editor

Teaching materials

• http://tecfa.unige.ch/guides/te/files/php-mysql.pdf

PHP with MySQL tutorials

Reading these is optional, since PHP coding will not be tested in an exam or in the term project. Below are a few PHP and PHP/MySQL tutorials that can be found on the net. There exist many others.

• Weiss, Aaron (2000) Welcome to PHP, somewhat outdated ...

• PHP Tutorial (W3C Schools, includes a section about PHP/MySQL).

• Gilfillan, Ian (2002). Using a MySQL database with PHP, Database Journal. (shorter 3-page tutorial)

• Yank, Kevin (2002) wrote a five part series in the Database Journal (Ok, but too much advertisement).
  • Build Your Own Database Driven Website Using PHP & MySQL: Pt. 1 (Overview)
  • Build Your Own Database Driven Website Using PHP & MySQL: Pt. 2 (yet another MySQL tutorial) ** Build Your Own Database Driven Website Using PHP & MySQL: Pt. 3 (PHP Introduction)
  • Build Your Own Database Driven Website Using PHP & MySQL: Pt. 4. (Displaying information on a web page)

• MySQL PHP Web Database Tutorial (1999). Simple table, by web.blazonry

• Williams, Hugh, E. (2002). Tips for Building Web Database Applications with PHP and MySQL, onLamp article (O'Reilly Databases). HTML

• Sample chapter of Web Database Applications with PHP and MySQL website.