|
|
| YZM2016 | Advanced Web Applications | 2+2+0 | ECTS:5 | | Year / Semester | Spring Semester | | Level of Course | First Cycle | | Status | Compulsory | | Department | DEPARTMENT of SOFTWARE ENGINEERING | | Prerequisites and co-requisites | None | | Mode of Delivery | | | Contact Hours | 14 weeks - 2 hours of lectures and 2 hours of practicals per week | | Lecturer | Öğr. Gör. Dr Celal ATALAR | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | With this course students can develop web applications that can perform many operations on databases also various web management systems with interactive users on the internet |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | You can learn the basic knowledge and skills on PHP programming language and the algorithmic approach to problem solving | 2,3,7 | 1, | | LO - 2 : | Having information about the web server and database servers | 2,3,7 | 1, | | LO - 3 : | Developing application with PHP | 2,3 | 1, | | LO - 4 : | Be able to use the MySQL database with PHP | 2,3,7 | 1, | | LO - 5 : | Managing the MySQL database | 2,3,7 | 1, | | LO - 6 : | Developing browser-based and database-related programs | 2,3 | 1, | | LO - 7 : | Realizing object oriented programming concept | 2,3,7 | 1, | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome | | |
| 1. Introduction to PHP, Client Server Architecture, Application Softwares Installation and Testing
2. Variable Concept, Constants, Operators and Predefined Variables
3. Predefined Mathematical Functions and Decision Control Structures
4. Arrays
5. Text Operations and Predefined Text Functions
6. Loop Control Structures
7. File Management
8. Session and Cookies Concepts
9. Working with Forms on PHP, Date and Time Functions
10. Functions, Sending Mail with PHP
11. MySQL and PhpMyAdmin, Make MySQL Database Connectivity with PHP, Insert Data to Table on MySQL Database with PHP
12. Make Query, Erase Data, Update Data on MySQL Database Table with PHP
13. Object Oriented Programming on PHP
14. Inheritance Concept on PHP with Respect Object Oriented Programming
|
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Introduction to PHP, Client Server Architecture, Application Software Installation and Testing, XAMPP Installation, Learning and Making the Apache Settings | | | Week 2 | Variables, Data Types, Variables Assignment, Variable Scope, Constants, Define Constant, Value Assignment, Operators, Mathematical Operators, String Operators, Assignment Operators, Logical operators, Comparison Operators, Bit Processing Operators, Operators of Decrease Increase, Predefined Variables | | | Week 3 | Predefined Mathematical Functions, Decision Control Structures, if else Statements, Switch Statement , Triple Conditional Statement and Use of ? Statement | | | Week 4 | Arrays, Define Array, Value Assignment, Array Procedures, Arrays Combine, Adding Variable to Arrays, Deleting First Element of Array, Fetching a Section of Array, Sorting Array, Multi Dimensions Arrays | | | Week 5 | Text Operations in PHP, Sting Functions, . Operator, urlencode and urldecode Functions, Encryption Functions, String Disassembly Operations | | | Week 6 | Loop control statements, For statement, the While statement, the Do While statement, the loop flow control statements, Break, Continue | | | Week 7 | Filing Procedures, Create File and Open File, Read from File, Write to File, Close File, Delete File, Copy File, Change File Name, Predefined File Functions, Create Directory, Delete Directory, Listing of Directory Contents | | | Week 8 | Cookies and Session Concepts on PHP | | | Week 9 | Midterm Exam | | | Week 10 | Working with Forms on PHP, Retrieving and Processing from HTML Elements, Predefined Date and Time Functions, Using Parameters on Date and Time Functions | | | Week 11 | Functions on PHP, Defining and Using Function, Sending Mail with PHP | | | Week 12 | What is MySQL, Using PhpMyAdmin, Create Database and Table over PhpMyAdmin, Make MySQL Database Connectivity with PHP, Insert Data to Table on MySQL Database with PHP, Using PhpMyAdmin | | | Week 13 | Data Query, Data Delete, Data Update on MySQL Database with PHP | | | Week 14 | Object Oriented Programming on PHP , Define and Using Object | | | Week 15 | Inheritance Concept on PHP with Respect Object Oriented Programming , Public, Private and Protected Concepts Related With Inheritance | | | Week 16 | Final Exam | | | |
| 1 | Yüksel, E. 2023; Sıfırdan ileri Seviyeye Php Web Programlama, Kodlab Yayın Dağıtım | | | |
| 1 | Şamlı, M. 2013; Uzmanlar İçin Php, Kodlab Yayınları | | | 2 | Balaban, E. 2013; Php ve MYSQL, Pusula Yayıncılık | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | | 1 | 50 | | End-of-term exam | 16 | | 2 | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | Yüz yüze eğitim | 4 | 14 | 56 | | Sınıf dışı çalışma | 2 | 14 | 28 | | Arasınav için hazırlık | 2 | 7 | 14 | | Arasınav | 1 | 1 | 1 | | Dönem sonu sınavı için hazırlık | 4 | 6 | 24 | | Dönem sonu sınavı | 2 | 1 | 2 | | Total work load | | | 125 |
|