Help:COAP-3180/week4: Difference between revisions
Jump to navigation
Jump to search
m (→Midterm exam) |
mNo edit summary |
||
| Line 2: | Line 2: | ||
=== Topics Covered === | === Topics Covered === | ||
'''Working with PHP and MySQL''' | |||
* Principles of PHP programming | * Principles of PHP programming | ||
* Simple PHP/MySQL interaction | * Simple PHP/MySQL interaction | ||
* | * Short overview of other application frameworks (.Net, J2EE) | ||
'''Slides''': | |||
=== Classroom activities === | === Classroom activities === | ||
* Exploration of the [[PHP]] language | |||
* Use of PhP/MySQL generators | * Use of PhP/MySQL generators | ||
| Line 60: | Line 67: | ||
; Teaching materials | ; 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) [http://wdvl.internet.com/Authoring/Languages/PHP/Welcome/ Welcome to PHP], somewhat outdated ... | |||
* [http://www.w3schools.com/php/default.asp PHP Tutorial] (W3C Schools, includes a section about PHP/MySQL). | |||
* Gilfillan, Ian (2002). [http://www.databasejournal.com/features/mysql/article.php/1469211 Using a MySQL database with PHP], ''[http://www.databasejournal.com Database Journal]''. (shorter 3-page tutorial) | |||
* Yank, Kevin (2002) wrote a five part series in the ''[http://www.databasejournal.com Database Journal]'' (Ok, but too much advertisement). | |||
** [http://www.databasejournal.com/features/mysql/article.php/1383591 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 1] (Overview) | |||
** [http://www.databasejournal.com/features/mysql/article.php/1384211 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 2] (yet another MySQL tutorial) ** [http://www.databasejournal.com/features/mysql/article.php/1402121 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 3] (PHP Introduction) | |||
** [http://www.databasejournal.com/features/mysql/article.php/1402281 Build Your Own Database Driven Website Using PHP & MySQL: Pt. 4]. (Displaying information on a web page) | |||
* [http://blazonry.com/scripting/linksdb/ 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). [http://www.onlamp.com/pub/a/onlamp/2002/04/04/webdb.html HTML] | |||
* Sample chapter of [http://www.webdatabasebook.com/ Web Database Applications with PHP and MySQL] website. | |||
Revision as of 22:55, 30 January 2010
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)
Slides:
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
Tips for the homework
Links and teaching materials
- Online software
- Teaching materials
- 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.