CLEII

Language:

Italian
Textbooks:

- Course notes
- Enrico Zimuel. Sviluppare in PHP 7. Tecniche Nuove
- Mark Wandschneider. Sviluppare applicazioni web con PHP e MySQL. Apogeo
Learning objectives:

The educational objective for the student is to achieve the following learning outcomes.

Knowledge and understanding

The course aims to provide the relevant fundamental knowledge about architectures, standards, protocols, markup languages, client-side and server-side programming languages, and tools used for developing dynamic web applications that manipulate data stored in databases.

Attention will be paid to the general principles to be followed for development of web applications with regard to the following aspects:
- application security;
- user interaction (e.g. navigability and usability)
- code quality (e.g. readability, use of conventions, documentation, modularity and parametricity, model-view-controller separation).

At the end of the course the student will be able to understand how a web application works and the role of the different technologies used in its implementation.

Applying knowledge and understanding

At the end of the course the student will be able to develop dynamic web applications that interact with databases integrating client-side and server-side technologies, starting from a specification in natural language.
Prerequisite:

- Knowledge of the principles of imperative and object-oriented programming.
- Knowledge of databases and of the SQL language.
- Ability to write small programs and to design databases.
- Ability to understand documentation and guides in English.
Teaching methods:

Frontal oral lectures and seminars.
Presentation of case studies.
Exam type:

Knowledge and understanding
Learning assessment can be carried out in two alternative ways.
The first method involves one or more written tests containing theoretical questions and/or empirical exercises for the creation of web applications using PHP and JavaScript languages. After passing the written tests, an oral test may be taken (at the student's request and at the discretion of the teacher).
The second method is reserved for those who already have experience in web programming and involves replacing one or more written tests with an in-depth project (or the development of an application) carried out individually or in small groups. At the end of this work, a written report must be submitted, accompanied by any software artifacts created during its completion. Subsequently, an oral exam will be taken to assess the student's individual contribution to the in-depth study (or project) and to verify their knowledge of the theoretical and basic content presented in class.
The final grade will be expressed in thirtieths and will be based on the evaluation of the tests taken and any in-depth work (or project).
Ability to apply knowledge and understanding
During the exams and the completion of any project or in-depth work, students' ability to apply the knowledge acquired to create web applications using client-side and server-side technologies is assessed.
Sostenibilità:
Further information:

- Client-server architectures and HTTP. HTML and CSS.
- Introduction to the PHP language.
- Forms, Cookies and Sessions. User authentication.
- Accessing databases.
- Browser Object Model, Document Object Model, Javascript and asynchronous interaction via AJAX.
- Security: access control, data protection. Vulnerability of web applications and countermeasures.

- Client-server architectures of web applications and the HTTP protocol.
- The HTML markup language. Elements of CSS.

- The PHP language. Variables, expressions, control structures and loops, arrays, functions and methods.
- Cookies for storing data on the client
- Sessions for storing data on the server and creating stateful applications.
- Management of user authentication and access control
- Access to databases via the PHP PDO library.
- SQL injection security attacks and countermeasures based on prepared statements.
- Design of PHP programs to manage user interaction to view, insert, modify and delete data stored on a database.

- The Javascript language. Variables, expressions, control structures and cycles, arrays, functions, methods and events.
- Use of Javascript for the validation of HTML forms.
- Browser Object Model and Document Object Model.
- Asynchronous interaction with a server via AJAX.