INTERNET PROGRAMMING II

BİLP232

Course Code: BİLP232
Semester: Fourth Term (Spring)
Theory+Practice: 2 + 1
ECTS: 3

Course Type

Compulsory Course

Course Level

Associate Degree

Year of Study

Semester

Fourth Term (Spring)

ECTS

Name of Lecturer(s)

Instructor Tuğba Altındağ

Learning Outcomes

At the end of this course, the students;

Installs and tests software for web based programming.
Pprepares web pages with basic commands of open source web programming tools.
Realize form applications at advanced level.
Uses web services.

Mode of Delivery

Face to face

Prerequisites

Recommended Optional Programme Components

BİLP 201 INTERNET PROGRAMMING I

Course Description

In this course students; it is aimed to gain proficiency in writing open source code programs that can work on the internet. It is the second part of Internet Programming I BİLP 201 course. Introduction to PHP programming, basic concepts, syntax and rules, development environments. Operators, variable types, operations on variables. Comparison and program flow control: if, else if structures, triple condition operator, switch case. Loops: for, while, do..while, break foreach. Arrays: Array variables, addition and subtraction in arrays, nested and multidimensional arrays, built-in array functions: is_array, list, array_sum, array_search, ksort. Functions: Function creation, return value, default value, global variables, call by reference. Forms: Getting information from forms, POST and GET methods, writing and selecting information on forms, Form validation processes. Session and Date: Super global variables, cookie reading, login and deletion operations, exit() and die() functions, date and time functions, date, getdate, mktime, localetime. Database fundamentals, basic definitions and terms. Table creation, and basic query operations SELECT, INSERT, UPDATE, DELETE. PHP and mySQL programming, connecting to the database, adding records to the table, paging records. Deleting records from the table, updating records. Table operations with the PDO extension.

Course Contents

WEEK	TOPICS
1^st Week	Introduction and Basic Concepts: Information about the course. Introduction to PHP programming, basic concepts and spelling rules, development environments introduction, operators, variables and their types, operations on variables.
2^nd Week	Comparison and Checking: if, else if constructs, triple condition operator, switch case
3^rd Week	Loops: Using for, while, do..while, break foreach,
4^th Week	Arrays: Array variables, addition and subtraction in arrays, nested and multidimensional arrays, literal array functions: is_array, list, array_sum, array_search, ksort
5^th Week	Functions: Create function, return value, default value, global variables, call by reference
6^th Week	Forms: Getting information from forms, POST and GET methods, writing and selecting information on forms, Form validation processes
7^th Week	Session and Date: Super global variables, cookie reading, login and deletion, exit() and die() functions, date and time functions, date, getdate, mktime, localetime
8^th Week	MIDTERM
9^th Week	Database 1: Fundamentals, basic definitions and terms. Table creation, and basic query operations SELECT, INSERT, UPDATE, DELETE
10^th Week	Database 1: Fundamentals, basic definitions and terms. Table creation, and basic query operations SELECT, INSERT, UPDATE, DELETE
11^th Week	Database 2: PHP and mySQL programming, connecting to the database, adding records to the table, paging records,
12^th Week	Database 2: PHP and mySQL programming, connecting to the database, adding records to the table, paging records,
13^th Week	Database 3: Deleting records from the table, updating records.
14^th Week	Database 4: Table operations with the PDO extension.
15^th Week

Programme Qualifications / Learning Outcomes

	LO1	LO2	LO3	LO4
K1
K2
K3	X
K4
K5	X	X
K6
K7
K8			X	X
K9				X
K10		X	X
K11
K12
K13
K14
K15