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:
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.
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.
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
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:
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.