- Office Hours:
- Mon: 9:00 - 9:50
- Mon: 3:00 - 3:50
- Tues: 8:50 - 9:20 (Hirt M207)
- Tues: 12:00 - 12:50
- Thur: 8:00 - 9:20 (Hirt M207)
- Thur: 12:00 - 12:50
|Instr:||Dr. Roger Griffiths|
|Office:||Old Main 305|
|Location:||Main Computer Lab|
|Class Time:||Monday, Wednesday, Friday; 1:00 - 2:10 (4 semester credits)|
and MySQL for Dynamic Web Sites: Visual QuickPro Guide (5th Edition), by
Publisher: Peachpit Press; ISBN-13: 978-0134301846
|We will continue to use the books from Internet Programming.|
|[You already have this, or similar] HTML5 in easy steps (2nd Edition) by Mike McGrath|
|[You already have this, and will need it] CSS: The Missing Manual (4th ED) by McFarland|
Before enrolling in the course, the student should be competent and comfortable working with HTML5 and CSS at the level required in our MIS280 Introduction to Internet Programming course. And in addition, understand basic computer operations on the operating system of their choice, in particular working with a live Linux server. You may work on any platform you like, Linux, Mac, Windows.
This is not a course in web page production or graphic design; but rather an introductory programming course. As a programming class, we will learn to create valid web content using a simple text editor, with a strong emphasis on validity and web standards compliance (as per the World Wide Web Consortium) and attention to detail (as per client job specifications). We will be working with a live server running Red Hat Enterprise Linux.
In addition to creating actual (live) web sites and enhancing their basic programming skills,
students will learn to embed PHP in HTML, to interact with MySQL databases both at the command
prompt and through the PHP engine, accessibility issues, the basics of (secure) file transfers, file
management, and web server (Apache) configuration.
As a junior/senior level course, the emphasis on you 'learning how to learn' will be even greater. We will also explore some other web technologies as seem applicable to our shared interests, related to our focus on PHP/MySQL.
Learning Objectives:By the end of this course, you will have acquired proficiency with both PHP and MySQL while learning basic server-side scripting and the use of MySQL through the PHP engine. More specifically:
- You will have a good understanding of PHP and programming with PHP, in particular:
- Basic syntax, variables, strings, comments.
- The client server relationship and server processing of PHP and MySQL queries.
- The web development cycle.
- Embedding HTML in a PHP file.
- Conditionals and Operators.
- Creating your own functions.
- Handling Forms.
- Error Handling and Debugging.
- You will have a basic understanding of MySQL and general SQL, including
- Data types, and column properties.
- Accessing MySQL, and the MySQL command prompt.
- Creating Databases and tables.
- Inserting records, and selecting data.
- Database design.
- Performing joins and transactions.
- You will have a good working knowledge of using MySQL with PHP
- Connecting to MySQL
- Retrieving and updating records with PHP.
- Using cookies and sessions.
- Security methods.
- You will be able to use very simple regular expressions.
- You will continue to develop your ability to learn how to learn, arguably one of the most important computer programming skills.
- You will put all of these ideas together
- as you build a complete store (e-commerce) website, and
- enhance your existing (static) web pages
A number of job specifications (programming assignments) will be made during the term, with a
specific due date. Assignments must be finished in on time, unfinished assignments will be graded as they
existed at the deadline, or occasionally, penalized and permitted late.
There will also be two term-long projects:
- You will create an e-commerce site for a fictitious store; this will utilize a database backend.
- You will redo all of your current (static) web content, utilizing PHP.
|Percent %||Letter Grade|
|90 to 100||A|
|87 to 89||B+|
|80 to 86||B|
|77 to 79||C+|
|70 to 76||C|
|60 to 69||D|
- homework assignments, which includes your projects,
- an in class midterm exam (100pt) and,
- a final exam (200pt cumulative)
-- exams are closed-book and without the use of a computer.
- In class exams: 45%
- Assignments: 55%
Your overall performance in the course is measured by the total number of points you accumulate relative to the maximum points possible. These are the only points possible in this class, there is no extra credit or 'make up' for poor examination grades. Your letter grade in this course will be based on the distribution at right. If you ask for extra-credit, I will know that you did not bother to read this syllabus (your contract), which of course is not a good sign.
- You are responsible for all that is announced or covered in class even if you are absent. If you do miss class, you are expected to have a classmate fill you in on everything that was covered in class.
- A prerequisite for additional help outside the classroom is regular class attendance.
- Since you will be sitting in front of a computer every day in class, there is a strong temptation to 'play' during class - my suggestion: "Don't give in to that temptation" - more on this topic in class.
- Email is great for simple communications, but more complex issues must be handled in person.
- Don't use email as an excuse to avoid personal contact.
- Due to the truly overwhelming amount of email I receive, any requests that involve much more than a yes or no response may not get addressed due to time constraints on my day, please come see me in that case.
In keeping with college policy, any student with a disability who needs academic accommodations must call Learning Differences Program secretary at 824-3017, to arrange a confidential appointment with the director of the Learning Differences Program during the first week of classes.
Support of the Mercy Mission:
This course supports the mission of Mercyhurst University by creating students who are intellectually creative. Students will foster this creativity by: applying critical thinking and qualitative reasoning techniques to new disciplines; developing, analyzing, and synthesizing scientific ideas; and engaging in innovative problem solving strategies.