MySQL and PHP (CIS159)

Professor: Priscilla Grocer

Website: www.pgrocer.net
Office: K-112
Phone: 508-678-2811 ext 2403
Email: Priscilla.Grocer@bristolcc.edu Check with me about other email address to use for homework.
The class is offered online this semester.

Course Description (from catalog): Students in this course learn to work with the open source database MySQL. They learn the concepts of creating a relational open source database using standard query techniques, including SQL and PHP and maintaining the database using SQL and PHP.

Course Objectives: Students who successful complete MySQL and PHP will be able to:

Work with a basic set of data and an analysis of the data needs to create a normalized relational online database.
Create a database and tables with keys to store and maintain data working through SQL and the MySQL database.
Generate SQL to query the database with a wide variety of criteria.
Effectively integrate SQL into PHP programs to handle the database manipulation and maintenance.
Create an maintain an interactive web site using PHP.
Design, develop, execute, debug and maintain web based programs using PHP.

Possible reference text books if you want one:

PHP 6/My SQL by Andy Harris
Premier Press, Course Technology
ISBN-13: 978-1-59863-798-4
ISBN-10: 1-59863-798-3
PHP and MySQL 3rd edition Murach Mike Murach & Associates
ISBN-13: 978-1943872381
ISBN-10: 1943872384
There are a lot of books on PHP and MySQL on the eLearning library. You are welcome to use one of them.
There is also a lot of information on the web in the form of tutorials that I found a reasonable substitute for a text.
devzone PHP
http://www.tutorialspoint.com/php/index.htm
www.homeandlearn.co.uk/php/php.html (this one I just looked at)
W3schools tutorial

Material to be covered:
This is a listing of the topics being covered; the order will change depending on the needs of the class.

Introduction/review of HTML
Introduction/review of CSS
Web environment
Examine the concepts of open source as applicable to database implementation
This course will cover MySQL which allows the user to create a database and PHP which is a programming language that can be used with MySQL The course will mix the learning of MySQL and PHP to achieve the goal of using them together effectively
PHP
1. Variables
2. Conditions
3. Functions
4. Loops
5. Arrays
6. String Handling
7. Files
8. Images
9. Email
10. Cookies and Sessions
11. Databases
12. Objects
MySQL
1. Relational database structure and design
2. Normalization
3. Setting up a database
4. Setting up a table and populating
5. Implementing a database
6. Querying a database
  1. Query techniques
  2. SQL
7. Maintaining/updating a database
Other topics will be covered as time permits

Requirements:

Requirements and Grading: The student will be expected to complete all assigned work. In addition there will be a final exam. A schedule of assignments, projects, exams, quizzes etc. will be posted on the Web site. Students should check on a regular basis.

Grading:

80% Homework, programs, code and quizzes
10% Class participation, responsibility about work, keeping up to date, quality of work, adding extras that are above and beyond, showing initiative, figuring out problems etc.
10% Final

Your commitment: For each hour in class, you should plan to put in 2 to 3 hours outside of class so you need to recognize that commitment and include it in your planning.
Below there is a TENATIVE schedule of homework based on previous semesters that will give you an idea of what you need to accomplish to be successful in the class. You are also required to do outside research as assigned.

Week #1	HTML and CSS project	Week #2	PHP asssignment, quiz
Week #3	PHP assignment - game	Week #4	Loop and if assignment, SQL assignment
Week #5	SQL assignment, quiz	Week #6	Relational database assignment
Week #7	SQL play computer assignment, MySQL in PHP assignment	Week #8	SQL in PHP assignment
Week #9	PHP and MySQL assignment, update	Week #10	Array assignment, loops assignment, quiz
Week #11	PHP program	Week #12	Databases and images quiz, email
Week #13	More email assignment	Week #14	Debug and maintain, cookie and sessions
Week #15	Prepare for final	Final	Final exam and status sheet required

It is very important that you let me know if you are having problems so we can work out a plan. I set up help sessions you can attend every week on line at Zoom and I also am available for help via email or in a Zoom session. Please take advantage of my availability and don't let yourself get behind! I truly want to see you succeed!

Evaluation: Assignments, programs and exams are graded using either number grades or letter grades based on the following (A=90-100, B=80-89, C=70-79, D=60-69, F=below 60). The student's grade for the course will use the same scale and will be based on the percentages explained in the grading section. Plus and minus grades will be given.
Many of the assignments in this class are open ended - the grading will be based on how well the project demonstrates mastery of the material. Students who do a minimum of work will be graded accordingly. Assignments are only accepted if they are credible work and meet the minimum requirements and standards for that assignment. Assignments that are not accepted can be resubmitted. Resubmission is allowed on graded assignments, with permission of the instructor. You cannot earn an A+ on an assignment that is resubmitted. The instructor will only accept, without penalty, resubmissions on credible work. Resubmissions must be done within a week to avoid additional penalties for late assignments.
Note: To achieve an A+, on open-ended assignments, students must have done sufficient extra work in development or implementation tot make the assignment standout. In doing assignments, students must do their own work. Relying too heavily on my examples or working too closely with someone else will be penalized.
Assignments are due the week after they are assigned. Late assignments will be penalized. For purposes of this class, the week will end at midnight on Thursday. The new week will start on Monday morning.

Attendance: Attendance is based on email communication. Students must report their status once a week. This report can be combined with the submission of an assignment.

Bristol Community College Withdrawal Policy:
Students are responsible for withdrawing officially if they stop attending any or all classes. Faculty no longer have the ability to withdraw a student from a class. A grade of "F" will be assigned to any student who stops attending a course but does not officially withdraw. Students are encouraged to meet with an advisor before making any changes to their schedule. Withdrawals effect Satisfactory Academic Progress and can place the student at risk for academic probation or dismissal. Students who use financial aid and who subsequently withdraw may be required to return some or all funds received. Withdrawals are accepted until the tenth week of classes. Students may withdraw online in accessBCC, in person at any Enrollment Center, or via their college email to enrollmentservices@bristolcc.edu. Email requests must come from the student's BCC college email address and must include the student's name, BCC student ID number, and course information (CRN, course and section number). Email from non-college accounts will not be accepted. If a student officially withdraws after the third week of classes, there will be no tuition or college fee refunds. For more information, see the College Catalog at: http://bristolcc.smartcatalogiq.com/en/2017-2018/Catalog/Academic-Information/Withdrawal-Policy-and-Procedure. Students with questions should contact Enrollment Services via any of the methods mentioned above or at 774-357-2590.

Disability Services Disability Accommodations: Bristol Community College complies with federal legislation for individuals with disabilities (Section 504 of the Rehabilitation Act of 1973 and the Americans With Disabilities Act of 1990 and the ADAA of 2009) and offers reasonable accommodations to qualified students with disabilities. It is your responsibility to notify me and the Office of Disability Services (ODS) of your need for classroom accommodations. Accommodations are arranged through ODS, which will issue a confidential Disability Services Accommodation Plan signed by both the Learning Specialist and student. This should be accomplished, when possible, during the first two weeks of class. If you have questions about the process, please contact ODS by calling (508) 678-2811 (Fall River, ext. 2955; Attleboro and Taunton, ext. 2996; New Bedford, ext. 2955 and/or 4011). You may also contact Office of Disability Services (ODS) online at http://www.bristolcc.edu/students/disabilityservices/
If you have a documented disability and will be requiring accommodations, please contact me and the Office of Disability Services (508) 678-2811 (Fall River, ext. 2955; Attleboro and Taunton, ext. 2996; New Bedford, ext. 2955 and/or 4011) as soon as possible to arrange for appropriate accommodations. You may also contact Office of Disability Services (ODS) online at http://www.bristolcc.edu/students/disabilityservices/
Any student with a documented disability in need of academic adjustments or accommodations is requested to speak with me and the Office of Disability Services (508) 678-2811 (Fall River, ext. 2955; Attleboro and Taunton, ext. 2996; New Bedford, ext. 2955 and/or 4011) as soon as possible to arrange for appropriate accommodations. You may also contact the Office of Disability Services (ODS) online at http://www.bristolcc.edu/students/disabilityservices/
I encourage any student in need of accommodations for a specific documented disability to meet with me and the Office of Disability Services (508) 678-2811 (Fall River, ext. 2955; Attleboro and Taunton, ext. 2996; New Bedford, ext. 2955 and/or 4011) at your earliest convenience to ensure timely and appropriate accommodations. You may also contact the Office of Disability Services (ODS) online at http://www.bristolcc.edu/students/disabilityservices/
For Online Courses: If you are a student who would normally seek accommodations in a traditional, face to face classroom, please speak to me and the Office of Disability Services (ODS) as soon as possible. You may contact the Office of Disability Services to arrange for appropriate accommodations by calling (508) 678-2811 (Fall River, ext. 2955; Attleboro and Taunton, ext. 2996; New Bedford, ext.2955 and/or 4011) or by stopping by Room L109. You may also contact the Office of Disability online at http://www.bristolcc.edu/students/disabilityservices/

Methodology: This course is sometimes offered using Student Option, sometimes as a Hybrid and sometimes online. The material is available online in a variety of ways with emphasis on the examples. Lectures are recorded and put online and Smartboard notes are captured and put on line for all inclass sessions. This information from the last time I taught in class is available. All students should read the assigned notes, study the presentations available and avail themselves of other resources at the web site in mastering the course material. In addition, students will be working independently on projects designed to give them additional computer skills and practical experience in PHP. When appropriate, exercises and problem solving techniques are used. This syllabus is not to be construed as a contract in any way, shape, manner or form. This syllabus contains a suggested course outline and will be generally followed, subject to change according to the instructor's discretion and needs. Academic flexibility is important!