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
- 20 hours per semester
- Participation in classes
- 20 hours per semester
|
prerequisite |
---|
Knowledge |
---|
Knowledge of MS Windows, a text editor. 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, a text editor. 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 |
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 |
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.
|