UIAI221 Web Technology II

Faculty of Philosophy and Science in Opava
Summer 2022
Extent and Intensity
0/6/0. 4 credit(s). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Lucie Ciencialová, Ph.D. (seminar tutor)
RNDr. Michal Pobucký, DiS. (seminar tutor)
Guaranteed by
doc. RNDr. Lucie Ciencialová, Ph.D.
Institute of Computer Science – Faculty of Philosophy and Science in Opava
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The aim of the course is to familiarize students with the design and creation of dynamic web pages using PHP and MySQL.
Learning outcomes
Students will be able to:
- use PHP to simplify website creation;
- analyze the use of the database in specific cases;
- design a simple relational database meeting 2NF
- Serve this database with PHP scripts
Syllabus
  • 1. Introduction to PHP
  • 2. Forms
  • 3. Field + FOR and WHILE commands + Database connection
  • 4. Database structure
  • 5. Insert, edit, and view
  • data 6. Creating homepage
  • 7. Cookies and Session
  • 8. Examples of usage - access counter, e-mail with attachment, generation of images
  • 9. AJAX
Literature
    required literature
  • HOPKINS, Callum. PHP okamžitě. Brno: Computer Press, 2014. ISBN 978-80-251-4196-0. info
    recommended literature
  • The PHP Group. PHP Hypertext Preprocessor. URL info
  • WELLING, Luke and Laura THOMSON. PHP and MySQL web development. Fifth edition. Hoboken, NJ: Addison-Wesley, 2017. ISBN 978-0-321-83389-1. info
  • ULLMAN, Larry E. PHP for the web. Fifth edition. San Francisco: Peachpit Press, 2016. ISBN 0-13-429125-5. info
  • W3SCHOOLS. W3Schools.com - THE WORLD'S LARGEST WEB DEVELOPER SITE. 2016. URL info
  • BÖHMER, Marian. Návrhové vzory v PHP: 23 vzorových postupů pro rychlejší vývoj. Computer Press, 2012. ISBN 978-80-251-3338-5. info
  • GILMORE, W. J. Beginning PHP 5 and MySQL: From novice to professional. CA United States: Apress, 2008. ISBN 978-1590598627. info
Teaching methods
Tutorials in the computer lab
Discussions
Assessment methods
Credit:
1. Creating dynamic pages - on a given topic
2. Use of MySQL database
3. In the credit week, the test - more than 50% points must be earned.
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
The course can also be completed outside the examination period.
Information on the extent and intensity of the course: Cvičení 6 HOD/SEM.
The course is also listed under the following terms Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2017, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2023.
  • Enrolment Statistics (Summer 2022, recent)
  • Permalink: https://is.slu.cz/course/fpf/summer2022/UIAI221