Information Technology Tools and Applications - Advanced
Topic: Introduction to PHP/MySQL
Summer 2010 Greensheet
Textbooks and Readings
Class Web Site
This class does not use ANGEL! The class Web site is found at: http://profperry.com
This course is an introduction to using PHP to build dynamic Web pages, that is, Web page that automatically change according to a user's input or information on a database. We will be reading from the required text and doing programming exercises. The assignments will be problems that you will solve by coding PHP pages that exercise the concepts learned to date. Additionally, you will learn the fundamentals of MySQL.
Course Prerequisites: LIBR 202 (Recommended: LIBR 240)
Student Learning Objectives
At the conclusion of the course the students are expected to:
- Understand the basic syntax of coding PHP programs.
- Know how use HTML forms with PHP.
- Be able to use standard PHP functions and be able to write your own custom functions;
- Understand the basics of MySQL and be able to use it in a PHP program.
- Build and maintain a small Web application.
LIBR 246 supports the following SLIS Core Competencies:
- design, query and evaluate information retrieval systems;
- demonstrate proficiency in the use of current information and communication technologies, and other related technologies, as they affect the resources and uses of libraries and other types of information providing entities;
- understand the system of standards and methods used to control and create information structures and apply basic principles involved in the organization and representation of knowledge.
Contacting the Instructor
I check my email account at least once per day, Monday-Friday, usually in the daytime. I generally do not check for emails on Saturday, Sunday, and Holidays.
Direct Email: email@example.com
Emergency email: firstname.lastname@example.org
(Use only if no reply received within 48 hours from my regular email)
Semester: Summer 2010 (2010/06/07 through 2010/08/12)
The FINAL DATE of this class is 2010/08/12
No assignments or exams will be accepted after that date!
The class is taken entirely online via the Class Web Site.
There are 9 assignments that will require you to solve programming problems using PHP/MySQL. These assignments are worth 10 points each.
The Final Exam is worth 10 points.
Each assignment has a target due date (details will be posted on the class Web site) and there is a 7-day grace period for each assignment. One penalty point is deducted from your score for each day (past 7 days) that your assignment is turned in late. For example, if an assignment is 10 days late, and is worth 10 points, the highest score you could receive for it would be 7 points.
NO assignments or exams will be accepted after the FINAL DATE of this class (listed at the top of this page) unless I've given you an explicit extension.
You may work through the class faster than the schedule if you wish; however, you may NOT submit more than one assignment on any given day.
Textbooks and Readings
- Welling, L., & Thomson, L. (2009). PHP and MySQL Web Development (4th ed.). Addison-Wesley. Available through Amazon: 0672329166.
The standard SJSU School of Information Grading Scale is utilized for all iSchool courses:
|97 to 100||A|
|94 to 96||A minus|
|91 to 93||B plus|
|88 to 90||B|
|85 to 87||B minus|
|82 to 84||C plus|
|79 to 81||C|
|76 to 78||C minus|
|73 to 75||D plus|
|70 to 72||D|
|67 to 69||D minus|
In order to provide consistent guidelines for assessment for graduate level work in the School, these terms are applied to letter grades:
- C represents Adequate work; a grade of "C" counts for credit for the course;
- B represents Good work; a grade of "B" clearly meets the standards for graduate level work;
For core courses in the MLIS program (not MARA) — INFO 200, INFO 202, INFO 204 — the iSchool requires that students earn a B in the course. If the grade is less than B (B- or lower) after the first attempt you will be placed on administrative probation. You must repeat the class the following semester. If -on the second attempt- you do not pass the class with a grade of B or better (not B- but B) you will be disqualified.
- A represents Exceptional work; a grade of "A" will be assigned for outstanding work only.
Students are advised that it is their responsibility to maintain a 3.0 Grade Point Average (GPA).
General Expectations, Rights and Responsibilities of the Student
As members of the academic community, students accept both the rights and responsibilities incumbent upon all members of the institution. Students are encouraged to familiarize themselves with SJSU's policies and practices pertaining to the procedures to follow if and when questions or concerns about a class arises. See University Policy S90-5 at http://www.sjsu.edu/senate/docs/S90-5.pdf. More detailed information on a variety of related topics is available in the SJSU catalog at http://info.sjsu.edu/web-dbgen/catalog/departments/LIS.html. In general, it is recommended that students begin by seeking clarification or discussing concerns with their instructor. If such conversation is not possible, or if it does not serve to address the issue, it is recommended that the student contact the Department Chair as a next step.
Dropping and Adding
Students are responsible for understanding the policies and procedures about add/drop, grade forgiveness, etc. Refer to the current semester's Catalog Policies section at http://info.sjsu.edu/static/catalog/policies.html. Add/drop deadlines can be found on the current academic year calendars document on the Academic Calendars webpage at http://www.sjsu.edu/provost/services/academic_calendars/. The Late Drop Policy is available at http://www.sjsu.edu/aars/policies/latedrops/policy/. Students should be aware of the current deadlines and penalties for dropping classes.
Information about the latest changes and news is available at the Advising Hub at http://www.sjsu.edu/advising/.
Consent for Recording of Class and Public Sharing of Instructor Material
University Policy S12-7, http://www.sjsu.edu/senate/docs/S12-7.pdf, requires students to obtain instructor's permission to record the course and the following items to be included in the syllabus:
- "Common courtesy and professional behavior dictate that you notify someone when you are recording him/her. You must obtain the instructor's permission to make audio or video recordings in this class. Such permission allows the recordings to be used for your private, study purposes only. The recordings are the intellectual property of the instructor; you have not been given any rights to reproduce or distribute the material."
- It is suggested that the syllabus include the instructor's process for granting permission, whether in writing or orally and whether for the whole semester or on a class by class basis.
- In classes where active participation of students or guests may be on the recording, permission of those students or guests should be obtained as well.
- "Course material developed by the instructor is the intellectual property of the instructor and cannot be shared publicly without his/her approval. You may not publicly share or upload instructor generated material for this course such as exam questions, lecture notes, or homework solutions without instructor consent."
Your commitment, as a student, to learning is evidenced by your enrollment at San Jose State University. The University Academic Integrity Policy F15-7 at http://www.sjsu.edu/senate/docs/F15-7.pdf requires you to be honest in all your academic course work. Faculty members are required to report all infractions to the office of Student Conduct and Ethical Development. The Student Conduct and Ethical Development website is available at http://www.sjsu.edu/studentconduct/.
Campus Policy in Compliance with the American Disabilities Act
If you need course adaptations or accommodations because of a disability, or if you need to make special arrangements in case the building must be evacuated, please make an appointment with me as soon as possible, or see me during office hours. Presidential Directive 97-03 at http://www.sjsu.edu/president/docs/directives/PD_1997-03.pdf requires that students with disabilities requesting accommodations must register with the Accessible Education Center (AEC) at http://www.sjsu.edu/aec to establish a record of their disability.
Download Adobe Acrobat Reader to access PDF files.
More accessibility resources.