This hands-on PHP programming course uses open source software, PHP and MySQL, to provide the student with a limited programming background with the applied skills to build professional-quality, database-driven Web sites. By integrating PHP and MySQL with the XHTML and CSS frameworks, the student will develop the skills to build interactive Web sites with authentication and security. Topics include introduction to XHTML, CSS, Java Script, web development and PHP, working with data types and operators, building functions and control structures, manipulating strings, manipulating data in arrays and strings, working with databases and MySQL, manipulating MySQL databases with PHP, managing state information, developing object-oriented PHP, and debugging and error handling.




Upon completion of this course, students should have a critical and informed understanding and ability related to the following:


  • Applying the W3C standard syntax and structure for XHTML documents
  • Formatting Web pages using Cascading Style Sheets (CSS)
  • Performing client-side scripting using JavaScript
  • Learning the basic structure and syntax of the PHP scripting language
  • Integrating XHTML, CSS, and PHP to build interactive Web sites
  • Handling user input via form processing and URL tokens
  • Performing other Web-based activities (send e-mail, upload files to a server, manage file directories, authenticate users, handle cookies and sessions, and implement object-oriented programming)
  • Understanding the application of the MVC design pattern to build scalable web database systems





Students will be engaged in the following learning activities: hands-on lab exercises, class discussions, as well as readings in text books and articles, and other assignments.


Required Readings:


Deitel, Paul, Internet & World Wide Web: How to Program, 4th Edition, Prentice Hall Incorporated, 2007. ISDN: 978-0131752429

Gosselin, Don, PHP Programming with MySQL, First Edition.  Course Technology Incorporated, 2005, ISBN 0-619-21687-5.

Recommended Readings


Garrett (2005), Garrett, J.J., “Ajax: A New Approach to Web Applications”, Adaptive Path publications, Feb 2005,  http://adaptivepath.com/publications/essays/archives/000385.php, accessed May 2009

Heinle, N., Pena, B., (2001), Designing with JavaScript, 2nd edition, O’Reilly, 2001

McLaughlin, B., (2001),,Java & XML, 2nd Edition: Solutions to Real-World Problems,  O’Reilly

Musciano, C., Kennedy, B.,  (2001) HTML & XHTML : The Definitive Guide, 4th edition,  O’Reilly

Ullman, L., (2003), PHP and MySQL for dynamic web sites, Peachpit Press, 2003

Wong, B. (2003), Building Database Interfaces, Zend (The php Company), Accessed October 2009, http://www.zend.com/zend/tut/tutorial-wong4.php





The methods and criteria of evaluation will be based on the following:


Assignments/Lab Practice 15%
Project 15%
Midterm 30%
Final 40%


Criteria:  The criteria of evaluation will be based on how well the student has fulfilled the projected learning outcomes established for the course.




Participation: Participation extends beyond mere attendance. Expect your instructor to keep track of how often you contribute to class discussion (as a whole), particularly during the panel discussion section. You may miss up to three classes without penalty – your first two absences count whether you have a good excuse or not. Each absence beyond the first three will cost you points off of your participation grade. The only exceptions to this rule are severe illness (doctor’s note required) and UNYT approved trips/activities. Appropriate documentation for absences beyond the first three is necessary the class day directly before or after the one you miss. In general: this class is intensive and interactive. Missing class could seriously affect your grade! Students are reminded not to approach the instructor for copies of the previous week’s materials during immediately before, during, or immediately after class. Students are expected to collect materials from their classmates or see the instructor during consultation hours.


Exams: Two examinations will be taken, a midterm and a final exam covering all course content during the final examination period. Test format may combine a mixture of short answer, true/false, matching, sort answer, and one or two essay questions covering all readings, lecture, hand-out and class discussion content.


Faculty: Arts & Sciences.

Department: Comp.Science.

Grade: Undergraduate.

Majors: Computer Sciences.

Study Fileds: Computer Science and Management of Information Systems.

Course Year: 3.

Course Program: ESC.

Scheduele: WED 09-13:00

Instructor: Vajjhala, Narasimha Rao

Credits: 4

Prerequisite: Intro to Programming