>
Courses Autumn 2002
>
Web Publishing with Databases
Home page for the course Web Publishing with Databases, autumn 2002 (DKM)
| Schedule | Manual | PHP.net | Literature | Students | Hand-in | Course Grader | News | Using Ssh |
| Course Responsiple | Office | |
|---|---|---|
| Mejner Olesen (mejner@it-c.dk) | 1.49 | |
| Teaching Assistants | Office | Office hours |
| Lasse Steensgaard (xls@it.edu) | 1.49 | Tuesdays, 12-13 |
| Jakob Tholle (jth@it-c.dk) | 1.49 | Thursdays, 12-13 |
News
- See samples: Database connection function: executeSQL(). Solution set 7 and set 8 (Thanks to Camilla Krag Jensen!),
- See the tabels and explanations of normalization: 1NF, 2.NF and 3. NF (From hager.dk).
- Is the server running?? Check out Lasse's server_test-script...
- See sample with comments explaining how to capture forminput and store it in the MySQL-database.
- Please subscribe to the newsgroup it-c.courses.w2 on the newsserver at news.it-c.dk
- Class hours wednesday morning from 8.00 -12.00. Lectures from 13.00 - 16.00
- 4 week-projects
| Følger du med i kursets nyhedsgruppe? Dér kommer mange vigtige informationer, og det er stedet, hvor man kan få hjælp uden normal åbningstid... Kort sagt: Et vigtigt sted, husk at følge med! |
Course Objectives
Learn to use advanced Web techniques to develop realistic, usable Web sites involving interchange of information with a database.Prerequisites
The course Grundlæggende Web-design or similar prerequisites. If you have no programming experience, then you must be motivated and prepared to put extra effort into the problem sets.Course Description
Based on knowledge about the creation of static Web sites, the course provides the student with techniques for creating Web sites that are programs and Web sites that are databases. The students are introduced to the programming language PHP4 , for generating HTML code dynamically, and database-programming SQL (Structured Query Language), for enriching Web pages with dynamic content. See the schedule below for details. Size of course: (e.g., 7.5 ECTS)There is a homepage for this course taught last term.
You may also find more information in the course book (Danish).
When and Where
12 weeks in the autumn semester. Lectures are on Wednesdays from 13.00 to 16.00 in room 0.19. Class hours are on Wednesdays from 8.00 to 12.00 in rooms 3.15, 3.16 (or 3.19)Grading Policy
Each student is evaluated with a grade in the 13-point scale. The grade is computed from completion of problem sets (50 percent) and a 4-hour written exam (50 percent). The problem sets and the written exam must be passed independently with a grade of 6 to pass the course.Students turn-in 11 problem sets, individually. Each turned-in problem set is graded with points in the range 0 to 100. A non-turned-in problem set is graded with 0 points. For each student, only the problem sets with the 8 highest scores counts. To get credit for problem set solutions, the student must turn-in the solutions using CourseGrader before 12.00 on the day following the assignment. Here is how you turn-in the first problem set:
To turn-in your solution to ``Problem set 1'', first make CourseGrader email you your password by providing CourseGrader with your IT-C email address (i.e., login@it-c.dk). You can then login to CourseGrader and turn-in your problem set by pressing the ``status'' link for the course and then the ``turn-in'' link for ``Problem set 1''. You may enter the entire solution in the text-box or you can enter a link to your index-page and briefly describe what you have done and what you have not done.For the written exam all kinds of helping material (books, notes, old problem sets, calculators) is allowed, exept programmable computers (or programmable calculators).
Got Questions?
If you have a question about the course or the problem sets, you can post your question on the Q&A forum for the course. In this way, other people benefit from the answers.You are also welcome to visit the course responsible or a teaching assistant during office hours.
Schedule
The schedule below is tentative and subject to changes:| Day | Week | Topic | Followed by reading in "Beginning PHP4" (pagenumber) |
Followed by solving problem set |
|---|---|---|---|---|
| 28/8 | 35 | Introduction. Static sites. HTML. Slides: PPT-HTML-PDF | 39 - 69 | set 1 |
| 4/9 | 36 | Introduction to the programming language PHP. My first dynamic Web page. Forms. Obtaining data from users. Conditional or Branching Statements Slides:PPT-HTML-PDF | 71 - 144 | set 2 |
| 11/9 | 37 | PHP continued. Loops and arrays. Functions. Slides:PPT-HTML-PDF | 147 - 202 | set 3 |
| 18/9 | 38 | PHP. Organizing your code. Handling and Avoiding Errors. Slides:PPT-HTML-PDF | (203 - 224), 227 - 259 | set 4 |
| 25/9 | 39 | PHP. HTTP. Arrays. Functions. Regular Expressions.Slides:PPT-HTML-PDF | 44-52, 182-183,194-206,243-255 | set 5 |
| 2/10 | 40 | PHP. Relational databases. MS-Access. MySQL and PHP. Slides:PPT-HTML-PDF | 384. 388-393,400-402,411- 412 | set 6 |
| 9/10 | 41 | Datamodel. Indexing. SQL (Structured Query Language).Slides:PPT-HTML-PDF | 379 - 384 | set 7 |
| 16/10 | 42 | Mid-term holiday. | ||
| 23/10 | 43 | SQL. Database-transactions via Web forms.Slides:PPT-HTML-PDF | See resources http://www.mysql.com/doc/en/SELECT.html http://www.mysql.com/doc/en/INSERT.html http://www.mysql.com/doc/en/UPDATE.html http://www.mysql.com/doc/en/DELETE.html |
set 8 |
| 30/10 | 44 | http://www.mysql.com/doc/en/JOIN.html http://www.developers-resources.com/stories.php?story=01/10/25/0549771 |
set 9 | |
| 6/11 | 45 | HTTP - again. Cookies and session. Slides:PPT-HTML-PDF | 44 - 50, 280 - 291 | set 10 |
| 13/11 | 46 | File and Directory Handling. Slides:PPT-HTML-PDF | 323 - 377 | set 11 |
| 20/11 | 47 | Opsamling og repetition. Send gerne forslag! Slides:PPT-HTML-PDF | ||
| 8/1 | 47 | Eksamen |
Literature
- Choi,W etc. Beginning PHP4 (Wrox Press ISBN 1861003730)
Related Literature
- Peter Sestoft. HTML overview. Notes from KVL.
- Mads Tofte. En kort introduktion til skrivning af HTML-dokumenter.
- MIT/W3C. HTML-codes for unusual characters and symbols
- A Beginner's Guide to HTML
- Jakob Nielsen. Designing Web Usability.
Previous Exams
Development Server
You are personally responsible for backing up your files on the ITC - network.
You will get specific information about how to deliver solutions.
Software
- ssh - software for logging in to remote machines securely and for transferring files to and from remote machines securely
