|
Lecturer(s)
|
|
|
|
Course content
|
- Dynamic web pages - The PHP scripting language - SQL Database (MySQL) - Development environment settings - local vs. remote web and database server - PHP Data Objects (PDO) - basic database operations (CRUD) - PHP frameworks (Model-View-Controller) - Project - design, coding, testing, publishing
|
|
Learning activities and teaching methods
|
Demonstration, Exercises on PC, Practice exercises
- Preparation for course credit
- 20 hours per semester
- Participation in classes
- 20 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| Knowledge of MS Windows, WYSIWYG editor (preferrably Adobe Dreamweaver CS4 and higher). Ability to create static WWW pages (XHTML, CSS, basic JavaScript) - CSS layout, navigation, work with texts and tables, incorporation of multimedia content. |
| Knowledge of MS Windows, WYSIWYG editor (preferrably Adobe Dreamweaver CS4 and higher). Ability to create static WWW pages (XHTML, CSS, basic JavaScript) - CSS layout, navigation, work with texts and tables, incorporation of multimedia content. |
| learning outcomes |
|---|
| define the differences between static and dynamic websites/web applications |
| define the differences between static and dynamic websites/web applications |
| The student has knowledge of the principles of functioning of dynamic WWW pages and is able to design and create a dynamic web site using database as a source of data. The student is able to design and create a simple secured content management system. |
| The student has knowledge of the principles of functioning of dynamic WWW pages and is able to design and create a dynamic web site using database as a source of data. The student is able to design and create a simple secured content management system. |
| describe the principles of relational SQL databases, their creation and management |
| describe the principles of relational SQL databases, their creation and management |
| characterize the PHP scripting language and describe how it works |
| characterize the PHP scripting language and describe how it works |
| characterize basic SQL relational database operations (CRUD) |
| characterize basic SQL relational database operations (CRUD) |
| describe how dynamic web pages/web applications are generated using PHP and an SQL database (PHP Data Objects) |
| describe how dynamic web pages/web applications are generated using PHP and an SQL database (PHP Data Objects) |
| explain the difference between frontend and backend of websites/web applications and enumerate tools for their creation |
| explain the difference between frontend and backend of websites/web applications and enumerate tools for their creation |
| Skills |
|---|
| design a dynamic website/web application project using PHP and SQL database |
| design a dynamic website/web application project using PHP and SQL database |
| design the structure of an SQL database |
| design the structure of an SQL database |
| create and SQL database and insert/import data |
| create and SQL database and insert/import data |
| create dynamic pages/web application using the PHP scripting language to generate pages from database |
| create dynamic pages/web application using the PHP scripting language to generate pages from database |
| identify problems in dynamic page generation, analyze and solve them (debugging) |
| identify problems in dynamic page generation, analyze and solve them (debugging) |
| teaching methods |
|---|
| Knowledge |
|---|
| Exercises on PC |
| Exercises on PC |
| Practice exercises |
| Demonstration |
| Practice exercises |
| Demonstration |
| assessment methods |
|---|
| Analysis of the student's performance |
| Analysis of the student's performance |
|
Recommended literature
|
-
NIXON, Robin. Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5. Sebastopol, CA: O'Reilly Media, 2018. ISBN 978-1491978917.
-
TATROE, Kevin a Peter MCINTYRE. PHP & MySQL: The Missing Manual. Sebastopol, CA: O'Reilly Media, 2020. ISBN 978-1492054122.
|