Course pre-requisites :

• CISY 225 - Web Page Development 1 -and- a Computer Science Elective

• Other required knowledge:

Prior programming experience in any of these languages: JavaScript, C, C++, Java, C#/VB.Net

Any other programming language involving decisions, branching, logic flow

Prior database experience(table design/creation,database queries) in : Access, Oracle, Sql Server, Sybase, MySQL

HTML - which IS NOT a programming language

NOTE - This is a programming course :

• -->EVERY<-- course session you will be coding, compling and debugging application code samples relevant to the course topic for the evening.

• This will be done interactively with the instructor.

• All code created in the class will be posted to the course website by the instructor for student download.

• Each student will present a homework assignment to the class where we will conduct a 'code review' and discuss the assignment

NOTE - This is ALSO a database course :

• You will -->NEED<-- to become familiar with the concepts of a relational database system

• You will be expected to code a database table structure using SQL syntax

• You will be expected to query a datbase using SQL, including inserting, updating and deleting records from the database

Goals of the Course : PHP(Personal Hypertext Preprocessor) is an open source, server-side, HTML embedded scripting language used to create dynamic Web pages. MySQL, pronounced either "My S-Q-L" or "My Sequel," is an open source relational database management system(RDBMS) and it is the world's second most widely used open-source relational database management system . It is named after co-founder Michael Widenius's daughter, My. The SQL phrase stands for Structured Query Language. The Apache HTTP Server, colloquially called Apache, is the world's most widely-used web server software. The course introduces the student to the concepts and features of the PHP programming language in conjunction with the Apache Web server as well as the syntax of the MySQL DBMS with the following outcomes:

• How to code and debug a PHP application

• How to work with Form data

• How to work with numbers and strings

• How to code control statements

• How to create and use functions

• How to create and use arrays

• How to setup and install MySQL databse

• How to create MySQL database tables

• How to use SQL to query(select, update, insert and delete) data into/from a MySQL database

• How to use PHP and MySQL to create a dynamic, data driven website

• NetBeans IDE will be the preferred development environment that will be used in class examples, labs and homework assignments

Course Textbooks :

• Murach's PHP and MySQL, Joel Murach, Ray Harris(ISBN-13: 978-1-890774-56-1)

• NOTE: the textbook is mandatory for the course and will be used as a basis for labs and homework assignments as well as the final exam.

How your grade will be determined : A final grade will be determined based on the following criteria:

• 20% - Course participation - includes attendance

• 50% - Completing the chapter homework assignments. o There are 5 assignments so therefore they each account for 10%(.10) each to arrive at a total of 50% o These assignments are in the form of applications demonstrating the students knowledge of the chapter o Each student WILL present 1 homework assignment to the class

• 20% - Completing the in class lab assignments.

• 10% - Grade from Final Exam

• I may, at my discretion and depending upon the progress of the class, assign another homework assignment whose grade may be used for extra credit . NOTE: Extra credit assignments will affect the grade given for participation.

Grade Scale : A final grade will be determined based on the weighted average of your grade received times the percentage of credit for that item. For example: If you attend all classes, are not late and participate in class you will get an A+ for attendance which equates to a 4.5.

• A+: 4.5

• A: 4.0 - 4.49

• B+: 3.50 - 3.99

• B: 3.0 - 3.49

• C+: 2.5 - 2.99

• C: 2.0 - 2.49

• D: 1.5 - 1.00

• F: 0.

Homework Assignments : There are several assignments that will be given throughout the course:

• Assignments MUST compile and run flawlessly in the Internet Explorer browser installed in the compter labs.

• Assignments are expected to be handed in within ONE week of being issued. NO EXCEPTIONS unless prior arrangements have been made with the instructor.

• Assignments will be handed in as the zipped contents of your your NetBeans project directory, including the project directory and all of its contents and subdirectories(for programming assignments), or, the zipped file of SQL statements for the database homework. NOTE: After zipping, please unzip to a different location on your hard drive and test the opening and compilation of your projects. If there is any information that the student wishes to impart to the instructor concerning the assignment, they should be placed within a text or MS Word file with the filename of Readme (ex. Readme.txt or Readme.doc).

• Projects will be handed in via the CourseMgr website(link on homework assignment download tab). The assignment MUST BE ZIPPED, VIRUS FREE and follow the naming convention noted on the CourseMgr Assignment upload page(i.e. (LastName_GNbr_AssignmentName.zip) Example: Mayo_g99990_Assignment1.zip ). The instructor will download your assignment from the CourseMgr website, review your submission, and post a grade on the CourseMgr website. As soon as the assignment is graded by the instructor, it will be available for your review on the CourseMgr website. If there is any information that the student wishes to impart to the instructor concerning the assignment, they should be placed within a text or MS Word file with the filename of Readme (ex. Readme.txt or Readme.doc).

• IMPORTANT: Your grade will be reduced by one grade point (Ex: an A+ becomes a B+, A becomes a B, etc.) if any of the following occur: 1) If a virus is detected on your zipped file. So, it is STRONGLY RECOMMENDED that you download the latest virus definitions and scan your diskette PRIOR to submitting it for grading. 2) If your zipped file is un-readable. So, it is strongly recommended that unzipp your assignment and test it before submitting it. 3) If you hand in a zipped project that is incomplete - missing files or folders. 4) If the assignment is handed in late without making prior arrangements with the instructor.

• NOTE: If your assignment DOES NOT compile, or, if it compiles but does not contain sufficient coding to warrant a grade, or, if it contains runtime errors that should have been caught during testing, you will receive an F for the assignment.

• Projects are expected to be handed in within ONE week of being issued. NO EXCEPTIONS unless prior arrangements have been made with the instructor.

Attendance :

• Attendance is required, and it means arriving to class on time, remaining for the duration of class, and staying awake.

• For every three times you arrive late and/or leave early, an absence will be counted.

• Attendance and Withdrawal Policy: All students are expected to attend all classes. Regular attendance is essential for success in the course. If you miss more than one-fifth(3) of the class meetings, you may be asked to withdraw from the course. In all cases, the responsibility for withdrawing from the course is the individual student's. Failure to withdraw may result in an "F" grade for the course. Those who simply stop attending the class may receive an "F" grade for the course.

Cheating :

• From the Student Code of Conduct: Raritan Valley Community College requires independent, honest work on the part of its students,and students are expected to conduct themselves with scholarly integrity. Each confirmed incident of academic dishonesty, cheating or plagiarism must be reported by the faculty member,in writing, to the Dean of Instruction. Violations of academic dishonesty and cheating include, but are not limited to: 1) Copying graded homework assignments from another student. 2) Working together on an assignment without being authorized by the faculty member to do so. 3) Looking at another student’s paper during an exam. 4) Copying another student’s computer program or class project and submitting it as one’s own. 5) Stealing or borrowing all or part of an exam’s questions or answers. 6) Entering a computer file without authorization. 7) Giving someone answers to exam question while the exam is being given. 8) Giving or selling a term paper, report, drawing, or computer program to another student for submission to the faculty member. 9) Deceiving a faculty member to improve one’s grade. 10) Falsifying data or a source of information. 11) Use of any technology to gain access to test answers, test questions or prohibited materials such as notes, online databases and websites during a test. 12) Submitting work for a grade that was executed in another class or previous semester without the instructor’s permission.

• In addition to reporting the incident to the Dean of Instruction, you will receive an F for the assignment.

Recording Devices :

• Video and/or audio recording of the whole or any part of any class session requires the prior approval of the Instructor – no exceptions.

RVCC Reasonable Accommodation Policy :

• Students with disabilities who require accommodations (academic adjustments and/or auxiliary aids or services) for this course MUST provide documentation of accommodations from the RVCC office of Disability Services, C143 . No accommodations will be made without this documentation.