ITEC327

 On successful completion of this course students will be able to:

• Use primitive data types and data structures offered by PHP
• Choose an appropriate data structure for modelling a simple problem
• Understand the importance and the use of server side programming languages
• Apply programming concepts
• Apply core program control structures
• Design, implement, test, and debug a program
• Test applications with sample data
• Write database driven Web applications that relate to a specific task

The students are expected to be active learners in this course. The teaching methodology of this course is based on a lecture based discussion of concepts followed by supervised as well as unsupervised applications of these concepts in Lab.  At the end of every major topic discussion, the students will have to work on corresponding Lab assignments where they have to apply the knowledge and skills they learned in class.

The course has three hours of lectures in a week mainly held in the form of a seminar.

There is two hours of laboratory per week which is organized for practicing the commands learned (lab assignment) and related to lectures and encourages students to voice their difficulties about solving these questions.

Lecture notes and laboratory questions are posted on the course web site.

There are two written quizzes which are held one week before the midterm and final exam periods.

The duration of the quizzes is 50 mins.

There is a written midterm exam which covers weeks 1, 2, 3, 4, 5, 6 and 7.

There is a written final exam which includes all the chapters but mainly the weeks 10, 11, 12, 13, 14 and 15.

Term project/assignment will be assigned individually at the third week of classes.

Class attendance is compulsory.

The student is responsible to check the course web site regularly and view the latest announcements.

Students are responsible to know and use all the course material placed on the web (http:// http://staff.emu.edu.tr/emreozen/en/itec327) and track the designated dates for timely submission of the assignment and for timely attendance to all quizzes.

Text Book:

• http://www.php.net/manual/en/
• Mark Lassoff, "PHP and MySQL for Beginners",LearnToProgram.tv,2014
  
  Resource Books:
• Joel Murach, Ray Harris, "Murach's PHP and MySql -Training Reference", Mike Murach & Associates Inc.,2012. ISBN: 9781890774561
• Julie C: Mellonie, "Sams Teach Yourself PHP, MYSQL and Apache All in One",5th Edition, Pearson Education, 2012.
• Matt Doyle,"Beginning PHP 5.3", Wiley Publishing, October 2009.
  
  Lecture Notes:
• Click to Download
  
   

PHP

• What PHP is, HTTP transactions, Multitier Application Architecture, Client-side vs Server-side scripting

PHP

• PHP installation, settings, PHP Syntax variables and expressions,

PHP

• Flow Controls, Data Types, type conversions, strings and predefined functions

PHP

• Arrays

PHP

• Functions

PHP

• Random numbers, additional predefined math functions(like round,ceil,floor, etc)

Review of HTML & JavaScript  :

• HTML elements, HTML form elements and their attributes, JavaScript Interacting with users: Form with validation

PHP

• Handling HTML Forms with PHP

PHP

• Classes & Objects (How to create and use objects/classes, predefined objects)

PHP

• Introduction to MYSQL RDBMS, MYSQLs' SQL dialects, usage of  PhpMyAdmin Tool

PHP

• PHP-MYSQL database programming  (mysqli_ methods, mysqli as object  and PDO object)

PHP

• Error handling(try except, try finally, throw etc…)

PHP

• Client/Server Environment variables, Session and Cookie variables, user authentication

PHP

• How to read/write from/to text files, How to use include, require predefined functions

PHP

• Security issues in PHP

PHP

• Namespaces and Model View Controller(MVC) in PHP

• Each student can have only one make-up exam. One who misses an exam should provide a medical report within 3 days after the missed exam. The make-up exam will be organized at the end of the term after the finals and will cover all the topics. No make-up exam will be given for the quizzes.
• Students who do not pass the course and fail to attend the lectures regularly may be given NG grade.
• Once the grades are announced, the students have only one week to do objection about their grades.
• It is the students' responsibility to follow the announcement in the course web site.
• Students who arrives after the first 20 minutes of laboratory session will not be accepted to the Laboratory.
• At the beginning of each lab session the corresponding Lab assignments in printed or electronic form will be provided to student.

Letter grades will be decided upon after calculating the averages at the end of the semester. Distribution of the averages will play a significant role in the evaluation of the Letter Grades.