Final questions in Web Programming, Spring semester 2014

Technologies used programming web sites - client side and server side.
Client side programming possibilities, limitations and examples.
Anatomy of displaying web page - sending request, getting answers, displaying pictures
Server side programming possibilities, limitations and dangers.
Traditional and less traditional uses of PHP
Variables, conditions and loops - roles and examples

Constructing page from subcomponents - header, footer, menu and content. Including files.
Using user data in web pages. Input controls, reading data in server. Methods get and post, variable $_REQUEST. 
Simple calculator example

Using database in web site. Relational databases, data tables, columns, column types. 
Making web interface to data table.
Creating multi-role workflow web application based to one data table.
SQL commands for creating data tables. Inserting data, deleting, modifying it. Ordering and filtering.

Joining data tables. One to many and many to many connection. Sample SQL-queries with join.
Creating web interface to joined data tables
Designing database schema. Normal forms, examples.

Using templates to separate designing and business logic side, Smarty
Using XML in web applications
Connecting Javascript and PHP to make applications for users more comfortable