UIINP36 Web Technology II

Faculty of Philosophy and Science in Opava
Summer 2020
Extent and Intensity
0/2/0. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Lucie Ciencialová, Ph.D. (seminar tutor)
RNDr. Michal Perdek (seminar tutor)
Guaranteed by
RNDr. Michal Perdek
Institute of Computer Science – Faculty of Philosophy and Science in Opava
Prerequisites (in Czech)
TYP_STUDIA(B)
Course Enrolment Limitations
The course is offered to students of any study field.
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
Study Materials
The course can also be completed outside the examination period.
The course is also listed under the following terms Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Summer 2020, recent)
  • Permalink: https://is.slu.cz/course/fpf/summer2020/UIINP36