MySQL and PHP (CIS159)
Professor: Priscilla Grocer
Email: Priscilla.Grocer@bristolcc.edu Check with me about
other email address to use for homework.
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:
A possible referemce text book if you want one:
- 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.
PHP 6/My SQL by Andy Harris
Premier Press, Course Technology
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
www.homeandlearn.co.uk/php/php.html (this one I just looked at)
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
- String Handling
- Cookies and Sessions
- Relational database structure and design
- Setting up a database
- Setting up a table and populating
- Implementing a database
- Querying a database
- Query techniques
- Maintaining/updating a database
- Other topics will be covered as time permits
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.
- 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 read the chapters in the book and do outside
research as assigned.
||HTML and CSS project
||PHP asssignment, quiz
||PHP assignment - game
||Loop and if assignment, SQL assignment
||SQL assignment, quiz
||Relational database assignment
||SQL play computer assignment, MySQL in PHP assignment
||SQL in PHP assignment
||PHP and MySQL assignment, update
||Array assignment, loops assignment, quiz
||Databases and images quiz, email
||More email assignment
||Debug and maintain, cookie and sessions
||Prepare for 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 and I also am available for help via email. 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.
Methodology: This course is sometimes offered using Student Option and sometimes as a Hybrid.
The material is available in class and on the web: it is a combination of lectures and interactive projects
with supplementary information available on the Web site for the course. Lectures are
recorded and put online and Smartboard notes are captured and put on line for all inclass sessions.
For other classes, lectures and notes are 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 Visual Basic. 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