Programming Languages II

Presentation

Acquire skills in web application development through HTML5, CSS and PHP. Develop ability to integrate open source classes in developed systems. Develop online applications in PHP with integration of MYSQL databases.

Programme

IT Engineering

Level of Qualification|Semesters|ECTS

| Semestral | 6

Year | Type of course unit | Language

2 |Mandatory |Português

Code

ULP452-898

Recommended complementary curricular units

Programming Fundamentals 

Algorithm

Databases

Professional Internship

Não

Syllabus

1. PHP, Apache and MySQL

A. PHP language

B. Apache Server

C. MySQL- architecture and graphic tools

2. Feature Installation

A. Xampp installation

B. Phpmyadmin

C. IDE / text editors for PHP and HTML i. Netbeans ii. Sublime Text iii. FtpSync for sublime iv. MySQL Workbench

3. Development web pages and PHP

A. Dynamic variables

B. Environment variables

C. Arrays

D. For and While Cycles and. Functions

4. MySQL Usage

A. SQL commands

B. Database Creation

C. Development of database queries

D. Development of query and writing forms in the database.

5. User Management

A. Login System Development

B. Authentication Forms

C. User Management

6. Formatting Styles and Web Pages

A. Development of CSS classes for page formatting

B. HTML5 integration

C. Using HTML5 Page Templates

7. Other Functions: Email, CAPTCHA, PDF Reporting

Objectives

The themes developed in the UC are grouped in fundamental modules. These, in an integrated way, seek to promote a set of skills in the students, particularly the following: To foster students' sensitivity to web application development. Raise awareness and present the classic tools available for developing web applications with PHP. Provide students with the necessary knowledge to integrate open source classes into their applications. Empower students to set up and install apache and MYSQL servers and online.

Teaching methodologies and assessment

The classes are theoretical practical, where the theoretical exposition is interconnected with tools such as brainstorming in order to apply the practice associated with the concepts conveyed.

Constant challenges of logical reasoning will be launched to foster critical thinking and self-learning.

The assessment is continuous and consists of 4 elements:

• Performing individual assignments in class with weighting 35%.
• Assessment in class by carrying out individual practical work, evaluating from 1 to 5 the work developed by the student, as well as the effort and commitment to perform each practical work, with a weight of 20%.
• Presentation of a final project, including all the subjects taught with a 30% weighting.
• Assessment of attendance, attendance and posture of the student with a weighting of 15%.

References

• Lerdorf, R., Tatroe, K., & MacIntyre, P. (2006). Programming PHP. O'Reilly. Obtido de https://goo.gl/f2Acin
• Moreira, J. P. (2015). Apontamento da unidade curricular. Porto: Universidade Lusófona do Porto.
• Tavares, F. (2012). Desenvolvimento de Aplicações em PHP. Lisboa: FCA Editora.

Office Hours