|
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) - Own project - design, coding, testing, publishing
|
|
Learning activities and teaching methods
|
- Preparation for course credit
- 24 hours per semester
- Participation in classes
- 26 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| Knowledge of MS Windows, a text editor. Ability to create static WWW pages (HTML, CSS, basic JavaScript) - CSS layout, navigation, work with texts and tables, incorporation of multimedia content. |
| Knowledge of MS Windows, a text editor. Ability to create static WWW pages (HTML, 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 |
| describe the principles of relational SQL databases, their creation and management |
| Students have knowledge of the principle of operation of dynamic web pages, are able to design and implement a dynamic web presentation with a database as a source of data. Students can design and create a simple secure content management environment (CMS). |
| Students have knowledge of the principle of operation of dynamic web pages, are able to design and implement a dynamic web presentation with a database as a source of data. Students can design and create a simple secure content management environment (CMS). |
| 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 |
| Demonstration |
| Demonstration |
| Practice exercises |
| Practice exercises |
| assessment methods |
|---|
| Analysis of the student's performance |
| Analysis of the student's performance |
|
Recommended literature
|
-
MESSENLEHNER, Brian a Jason COLEMAN. Building Web Apps with WordPress. Sebastopol, CA: O'Reilly, 2014. ISBN 978-1449364076.
-
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.
|