Fatih University

Department of Computer Engineering

CENG/BILM 310 Internet Programming, 2010 Spring, Atakan Kurt

Announcements

• Home work 4 is here. It is due Apr 28 2011. Here is a simple Javascript game I wrote in class.
• http://izmir.ceng.fatih.edu.tr adresinde mysql aç kısmı içersinde linux (ssh) kullanici adi ve mysql de sifre yazmaları yeterlidir. Sistem hesap bilgisini otomatik üretecektir.
• Here is a database you could use for assignment 3:
• File (fid, name, initialRowCount, initialColumnCount)
• Sheet (sid, rowCount, columnCount, fid)
• Cell (sid, rowNumber, columnNumber, data)
• Here is another drawing regarding home work 3.
• Homework 3 is due Apr 11. and it is worth 10 points
• Do the questions in midterm for extra 5 points as an extra homework 2 and bring it on this Thursday at the beginning of the class. This is optional, for those interested in extra 5 points. Remember to put files solution1.php, solution2.php, solution3.php in hw2 directory.
• Ödev 1 pazartesiye (28 Mart 2011) ertelenmiştir.
• Ödev için dosyalara gerekli yazma ve okuma izinleri verilmeli (chmod 777 ile web alani-yani public_html klasoru- içerisine yeni bir dizin, o dizine chmod ile gerekli okume/yazma hakkı verebilirsiniz).  Unix/Linux dosya formatina uygun olmali dosya isimleri (kucuk/buyuk harf kontrolu). Ayrıca ödevleri izmir.ceng.fatih.edu.tr ye koyduktan sonra mutlaka kontrol edip çalıştığına emin olun lütfen.

Ödeve Notlandırması (Grading for homework)

1- Açıklama yoksa yada yetersiz ise 5 puan kesilir (Insufficient comments: -5)

2- Kodlarda php komutları bold yada renkli değilse 5 puan kesilir.(php cpde not in bold: -5)

3- Modüler programa kullanılmamışsa (örneğin:tekrarlayan yapılar fonksiyon değilse ) 10 puan kesilir (no modular programming: -10)

4- Yapmış olduğunuz ödev web sayfanızda ödevde belirtilen yerde yoksa yada çalışmıyorsa, linkler yoksa 10 puan kesilir. (not failing to load to the server properly: -10)

5- Değişken isimleri açıklayıcı değilse (yani sadece $a, $b ,$ gibi ne anlama geldiği belli olmayan) 5 puan kesilir (improper variable naming: -5)

6- Ödevde çıktısında indentasyon yoksa 5 puan kesilir (improper indentation: -5)

7- Çıktıda Numaranız/Adınız/Soyadınız, Ödev adı/No, Ders Kodu/Adı ve sayfa numaraları yoksa 5 puan kesilir. (insufficient student/course/homework info: -5)

2 ile 8 şıkları arasındaki puan kesintisi 1. Ödev için toplam 30 puanı geçmeyecektir. Ancak bundan sonraki ödevlerde 45 puana kadar kesinti olacaktır.

Examples in class

• Files
• Regular expressions
• Databases another another
• Sessions (shopping card: shop.php card.php)
• Sessions (login.php main.php)
• Javascript game (Symbol matching)
• Javascript game snippet (tetris)
• Drawing graphics in php (survey chart) figure out the database table yourself from the code
• Database (A simple student info system)

Software

• Notepadd++
• Xampplite
• Firefox

	Hw1	Hw2	Hw3	Hw4	Hw5	Hw6	Hw7	mid
Homework	here	Midterm	here here	here
Points	10	5 bonus	10	5
Due		31.3	11.4	2.5.2011
Solution		Q1(using hidden varibles) Q1(using sessions) Q2(Files) Q3(RE)	here	here

Instructor: Dr. Atakan Kurt, ext 5513, akurt@fatih.edu.tr, room EA306, Office hours: Mon: 13:00-14:00 Thu: 13:00-14:00.

TA: Murat Gezer (mgezer@fatih.edu.tr) (212) 8663300 #5522 E-107 Office hour: Paz/perş 8:00-10:00

Website: htpp://www.fatih.edu.tr/~akurt/courses/ceng310/spring2011/ . Please check the course web site regularly for announcements, homework solutions, grades etc.

Prerequisites: Good OO Programming skills, the basic understanding of Databases Management Systems and SQL. HTML and CSS familiarity is useful.

In this course students will be introduced to developing web applications using a scripting language. Students will learn about application development environment for the web using a web server and database servers. Various subjects including database access, sessions, generating graphics etc will be covered.

Textbook: Please get a copy of the book.

PHP MySQL and Apache All in One, Julie Meloni,SAMS, 2006 0-672-32873-9 (Turkish Translation by ALFA)

Php and MySQL Web Development, 3^rd Edititon Luke Welling and Laura Thomson, SAMS Publishing

Grading (tentative)

4-5 assignments %30-40, midterm %30, final exam %40.

Course Contents (Tentative)

1. Week 1: Introduction: We will discuss the Internet and Network architecture of web computing first. Then we will cover how various servers such as web, database, application, ftp, mail, dns servers and the services come together to provide a unified ISP framework. We will also cover the systems and software that will be used in the class.

2. Week 2: HTML Overview (pass): The Basics of HTML will be briefly covered including tables, forms, image maps, forms, CSS etc, Reference to various versions and technologies will be briefly discussed.

3. Week 3: PHP Crash Course. The main features of PHP will be covered so that students can start using PHP. We will go through some examples.

4. Week 4 and 5: PHP Programming: We will cover programming concepts in PHP, topics that will be covered are OOP, Arrays, Files.

5. Week 6: PHP Regular Expressions are important for many internet applications and is part of mant important software programming languages.

6. Week 7: PHP-Database Interface: We will cover php-mysql interface with a set of examples. Creating database connections, executing SQL queries, formatting query output will be covered

7. Week 8: PHP Authentication/Cookies. HTTP Basic authentication, database authentications will be covered.

8. Week 9: Sessions. HTTP is stateless, so we need a mechanism to carry data between pages. Sessions provide this functionality.

9. Week 10: Producing Graphics. Mamy application requies graphic output in different formats. We will learn how to produce image/graphic output using a php image library.

10. Week 11: Web and e-commerce security issues.

11. Week 13: XML and XML related technolojies will a dramatic effect on internet computing. We will beirefly cover bacis and and touch upon related technolojies such as DTD, XDS, XSLT, etc.

12. Week 14: 1 week will be reserved in the middle of the semester for midterm.

Software: Some useful websites for the software in the course are:

Apache Friends: http://www.xampp.org/

Php interpreter: http://www.php.net ,

Mysql database: http://www.mysql.com,

Apache web server: http://www.apache.org,

Php interface to MySQL: http://phpmyadmin.net

Important Links: www.w3c.org http://sourceforge.net http://freshmeat.net