|
Lecturer(s)
|
-
Kurka Ondřej, RNDr. Ph.D.
|
|
Course content
|
Processing of data inputs in the form of files and/or folders using PHP (reading, searching, creation, editing, transfers). The issues of tailor-made functions writing in the script, local, global and superglobal variables. Software for MySQL database management. Creation of MySQL databases and their connection to PHP scripts. Reading and writing to MySQL databases. HTML document styling using CSS.
|
|
Learning activities and teaching methods
|
Dialogic Lecture (Discussion, Dialog, Brainstorming)
- Attendace
- 26 hours per semester
- Homework for Teaching
- 13 hours per semester
- Preparation for the Exam
- 13 hours per semester
|
|
Learning outcomes
|
The aim of the course is to deepen the knowledge in the area of script writing in PHP and use of an interactive programming environment to process and sort large volumes of data. The class expands the programming skills by introducing principles of file and folder processing, development of tailor-made user functions, and operating a MySQL database. Also, enhancing the user experience by CSS styling will be discussed.
Advanced skills in the PHP programming, basics of MySQL and CSS styling. Algorithmic approach to problem-solving, understanding of interconnection of individual software components.
|
|
Prerequisites
|
Elementary skills in programming (in the scope of ACH/PNAC class).
|
|
Assessment methods and criteria
|
Student performance
Attendance, previous knowledge of elementary programming functions (conditions, cycles - in the scope of ACH/PNAC class), submitting a semestral work (i.e. a script solving a set analytical problem.
|
|
Recommended literature
|
-
Kosek J.: HTML: Tvorba dokonalých stránek, Grada, Praha, 1998.
-
Kosek J.: PHP: Tvorba interaktivních internetových aplikací, Grada, Praha, 1999.
-
Nixon R.: Learning PHP, MySQL and JavaScript, O'Reilly, Sebastopol, CA, 2009.
-
Schafer S. M.: HTML, XHTML a CSS, Grada, Praha, 2009.
-
Welling L., Laura Thomson L.: PHP a MySQL - rozvoj webových aplikací, SoftPress, Praha, 2002.
|