MySQL and PHP - CIS159/CIT32

Weekly Schedule

Remember RE-SUBMIT. If you get back a homework with errors and without a grade it means it has not been graded - you need to fix and resubmit to get a grade.

Week Information
Assignments due in one week unless otherwise stated. I may add some things during the week, so double check the schedule each week! For almost all the assignments I want to see the code you write and the output it produces. So send me the address and a copy of the code. With play computer assignments give me the code and the output as you feel it would be generated. Please keep copies of all work you submit until you receive your final grade at the end of the semester.
Week #3
Week of September 17th
We will continue working on information in FirstGroupPHP and SecondGroupPHP and then we will move on to the ThirdGroupPHP and ThirdGroupPlusPHP and BostonTeaPHP. We may get too FourthGroupPHP.
Third Group PHP zipped
Boston Tea party example PHP zipped
Third Group Plus PHP zipped
Please look at "Go West Across America with Lewis and Clark" which is where I got the idea for the Boston Tea Party game. Lewis and Clark adventure
I would like you to write an educational game for kids about some event or series of facts. It should be something along the lines of what I did for the Boston Tea Party. It should have a minimum of 3 pages.
Reference: classtime examples
Decision Quiz
Week #2
Week of September 11th
There are only two people taking this class, so we are essentially doing the course as I did it in the spring. This means you can check the spring audio and Smartboard notes. Hopefully I will catch the references to dates in the spring and fix them, but...
These are the examples we will be using this week.First Group PHP and Second Group PHP under PHP Code Examples at my site.
Please note that we also got to Third Group PHP and Third Group Plus PHP this week.
Comments on some examples
Because a text book is not required, I want to point you to a few good PHP tutorials/ references that you can use throughout the semester. I will also put up sites related to current topics periodically.
Tutorials Point (PHP)
The W3 schools tutorial gives you option to test things
A slow moving basic tutorial
These are the handouts I give out in CIS120 that reference using cisweb. Note we now must use instead of We will look at login to cisweb this week so check the notes on the Smartboard and the accompanying audio as well as the notes below. To load things up on the Internet, we use WINSCP. Please read the WINSCP and cisweb information: (note that in my examples I use as the host, we are now using as the host although the old one is still supported).
Here is information about using cisweb and WINSCP at BCC
Talks more specifically about portfolio We will be looking at making a portfolio later in the semester.
If you want to download WINSCP at home, you can find it at this address.
For all assignments, send me the address that I can run in the browser to test your program and also send a copy of the code.
In class week 2 quiz (must be done and submitted by all students):
Problem #1: Fix this problem that is made up of fix1.html and fix1.php so that it is running:
This includes the third payroll problem from the quiz If you already used the second one to revise, that is fine.
Problem #2: Using payrollbasics3.html and payrollcalc3.php make changes to the php program so that all the code in the body is in one php routine.
Homework: Memo assignment Make up 5 names and use the 7 days of the week. and notice in my example I have you select a first name but I put out the whole name. You can make up the names. Also note that the select is Wed but in the memo I use Wednesday.
Week #1
Week of September 4th
We will start off the semester with a quick review of HTML if needed and then we will actually start the PHP. If you have already had CIS122/44 or have previous experience, this will be a review. If you have taken CIS120/17, you have already been introduced to HTML. For others I suggest that you use resources at the sites for CIS120/17 and CIS122/44 or other resources on the web to accquaint yourself with HTML.
This example covers some of the fundamentals: html5example.html
A great reference for writing HTML is W3Schools
The students in this class have a variety of backgrounds, so for some HTML is review and for others it is relatively new.
Handout on using WinSCP3 Note instead of the host as we are now using
WinSCP3 is available as open source software and you can download it for home use.
You should be getting a username/password for the BCC site at the end of this week.
We will be working exclusively off the BCC cisweb site. You do not need to install PHP or MySQL, they are on the server.
When we start to look at PHPlog into into cisweb and copied my examples from First Group PHP up to the site. You can find First Group PHP under PHP Code Examples.
If you are new to HTML, I want you to build a web page and upload it to the server (that cannot be done until you get your username and password). The page should include at least list, tables, CSS and forms.
If you are experienced with HTML, I want you to develop a page that challenges you and uses elements that you stretch your knowledge - this is the time to explore more CSS or forms - experiment!
Due the Thursday after it is assigned so due September 14th.
For all assignments and quizzes, send me the address that I can run in the browser to test your program and also send a copy of the code.
Quiz this is one of those quizzes where you can talk things through with others in the class, but each person has to do it and pass in their version.Quiz

Send e-mail to Priscilla Grocer:

Back to the Top
Return to home page
Return to previous page