Title: Syllabus
Course: PHP/MySQL Course

CBIS 420 Syllabus (73764) Fall 2009

Syllabus
CBIS 420 - PHP & MySQL for the Web

Semester: Fall 2008
Section: 73764
Session Dates : September 8th to December 16th, 2009
Format: Online
Units: 3.5

Instructor: Gerry Jenkins
email: gjenkins@lbcc.edu phone: (562) 938-4623
Office Hours: see gjenkins.lbcc.edu

Recommended Preparation:

You should have previous experience with a programming language that uses arrays, variables, if, loops, and be able to write simple programs.

You should have also had some previous Database Principles of relational databases. And It will help to have had some SQL language.

You will also get more out of class if you have previous HTML/CSS experience.

Course Description

This course covers PHP & MySQL, one of the fastest growing technology combinations for developing interactive Web sites. It is designed at a level for personal web development projects, as well as small to medium business Web development needs.

You should be able to do the following at the end of the course:
1. Design PHP based web pages using correct php, css, and xhtml syntax, structure.
2. Create Web forms and pages that properly use HTTP GET and POST protocol as appropriate.
3. Design SQL language within MySQL and PHP to access and manipulate databases.
4. Install and configure both PHP and MySQL.
5. Create PHP code that utilizes the commonly used API library functions built in to PHP.
6. Demonstrate use of cookie, session, and authentication programming in PHP.
7. Design and create a complete web site that demonstrates good PHP/MySQL client/server design.

Course Content and Delivery

This course is an online course.

The activities that you will be involved in will be researching information from the Internet, reading textbooks and online materials, completing online lessons, quizzes and other things, and completing assignments including programming assignments.

Contacting me:

The primary way to contact me is to email me at gjenkins@lbcc.edu

I only read my email Monday to Friday. I do not answer on weekends or holidays. You can expect a response within 24 hours of my reading the email.

You can also phone me and leave a message at (562) 938-4623 or come to my office hours posted on http://gjenkins.lbcc.edu.

Please contact me for help when ever you need it. Attach you assignment or other related files if you are asking about work you are doing. Please give specific error messages and conditions if you are reporting an error. You should also attach any file you need help on.

Textbook and Technical requirements

Two textbooks are required for class .

Text book: "Sams Teach Yourself PHP, MySQL, and Apache All in One" by Julie C. Meloni, publisher: SAMS
ISBN 0-672-32976-X (List Price $35.99)

You can purchase this from our LBCC LAC book store. You can also order them online at http://www.lbccbookstore.com They are also available though a variety of online sources, just be aware of order delays.

All the software we will be using is free. You can certainly choose to pay for a commercial IDE or editor.

You will need a computer with internet access, a stable email account (not aol), and a computer that you can install software on (A PC or a Mac).

We will also be referring you to the excellent videos on the site KillerPHP.com. We have gotten special permission from Stefan Mischook who is the author of these videos. These practical demonstration based videos are an great complement to your text books.

Grading

The grade for his class is 'Student Choice': you can choose a letter grade or just a Credit/No Credit grade. Letter grades are graded to a standard scale. and you need a 70% to receive a Credit grade.

Percent | Grade | Credit/No Credit
90% and above | A | Credit
80% and below 90% | B | Credit
70% and below 80% | C | Credit
60% and below 70% | D | No Credit
Below 600 | F | No Credit

Your total grade will be based on the sum of these components:

Assignment or Evaluation | Percent contribution to overall
Lessons/Quzzies/Other | 30%
Sample Code Programs | 30%
Programming Projects | 32%
Final Program | 8%
Total | 100%

Course Policies

Due Dates: All assignments will be due at the end date set for the topic it is in. For late programming assignments, 75% of the possible points will be deducted for the first two weeks or part of a week the assignment is late. Assignments that are turned in more than two weeks late will be given zero points.

Quizzes and Lessons will not be penalized for being late.

All assignments and quizzes must be in on or before the last date of class.

Use of CBIS3 Server Account: You will be given an account on a public Linux based web server. You are not to use the account, or files space for any activity not assigned as part of the class. If you use if for hacking, web content that is any kind of hacking, obscene or illegal activity, your account will be closed.

Technical Problems:

If you can not complete assignments, exams, or tests at home for any technical breakdown or virus on your computer, you are solely responsible to still do the work by arranging to use another system. You can sign up for CBIS 673 Open Lab and use our computer systems and software at either campus during the hours they are open. The CBIS department and your instructors are not repair technicians, you must pursue repair of technical problems on your own. If you wait till the last minute to do your work, you will not be given any special consideration.

Cheating:

You can not use someone else's work or copy from any source. This includes using the same file from a friend, relative, or anyone else. Anyone participating in any form of academic dishonesty will be withdrawn from the class and your case forwarded to the Dean of Student Affairs for consideration of any other actions. This includes the originator of any work that is copied. You are responsible to protect your work. If it is stolen, you have to report it immediately to your instructor. Please contact the Student Affairs office to be informed of your rights.

Cheating includes: copying any part of a document that is not yours, including copy and paste from the Internet, using any communication device or method in a test, doing someone else's work in part or whole, plagiarism in any form, and using any form of note in a closed book test.

Do not let any student use your files, media or computer. You may be responsible for any material they use from you.

Withdrawal from class :

If you are enrolled in the class at the start of the semester but never contact the instructor and participate in the class by the census date of the class (see the deadlines at http://admissions.lbcc.edu) , you will be considered a "No Show" and I will drop you from the class. In all other circumstances, if you need to withdraw from this class, you are responsible for dropping the class through Admissions and Records or online. If for some reason you decide to drop the class early in the semester and do not wish to receive a "W" grade on your transcript, you must go to the Admissions and Records Office and drop the class by date indicated as the last day to drop and recieve a "W" (see the deadlines at http://admissions.lbcc.edu) . (You can also drop the class online.) If you have not dropped the class as of this date, you will be assigned a letter grade (A, B, C, D, F, Cr or NC) in the course, whether or not you are attending class.

PLEASE NOTE THAT IF YOU NEED TO WITHDRAW FROM THIS CLASS, YOU ARE RESPONSIBLE FOR DROPPING THE CLASS THROUGH ADMISSIONS AND RECORDS OR ONLINE. If you simply stop participating in class and do not drop the class, you will be kept on the rollbook and you will be assigned a grade in the class.