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. Remember that I record/tape all my classes and capture notes on the Smartboard. These are available to you under Audio and Smartboard.
HELP schedule To contact Joe use moocowoftech@gmail.com. He will be available from 9-2 on Mon thru Fri for open labs at this address: Collaborate
For hours outside of that he will be using Microsoft Teams which is available to you through Office 365. Send him an email from your bcc account with the classes you want to connect to and you will get a link to join. Here is a brief run down on how it works and what to expect: Microsoft Teams overview
Week #10
Week of March 30th
I will give extra credit to anyone who goes to the Collaborate site (see link in HELP above) and either works with Joe on something they need help with or shows him something they have done for the course. Send me an email and let me know what you did. Actually this applies to doing something with Joe using Teams app as well.
We will continue looking at taking in and processing data in the same page and updates.
UpdateFunctionPHP.zip
Assignments:
You need to write an update program that can add, change or delete the fields on a table. I am looking for effective maintenance and something easy for the user to work with. I suggest you use my update as a model to create one of your own with a different table. You can also decide to write one from scratch. If you do both, I will give you extra credit. If you need some extra time on this, let me know.
Week #9
Week of March 23rd
Officially there are no classes and no assignments this week. However, I decided to post this weeks work anyway so you can get started on it if you choose to. I feel that choosing to do the work this week will spread the work out better and make the end of the semester easier no matter how it is handled. I will keep putting out the work for each week as originally planned to give you more flexibility. Late points will not be taken. Again, it is your choice whether you do the work this week or leave it for next week.
FunctionGroupPHP.zip
FunctionsBuiltinGroupPHP.zip
Assignments:
Functions
Weel #8
Week of March 9th
I will not be on campus Thursday, March 12th - the material for the class will be online. The group advising session is also cancelled, we will reschedule if possible.
We need to go back and finish up First Connect Group and Second Connect Group. Then we will move on to Third Connect Group. Third Connect Group
Assignments:
PHP connect quiz
Third Connect Group Assignment
Check back!
Week #7
Week of March 2nd
We will look a some more at SQL, relational databases and then move on to linking MySQL into PHP.
We will finish up our quick introduction to MySQL and using SQL and start incorporating it into PHP.
First Connect Group zipped
Connect Explanation
Second Connect Group OK
Assignments:
First assignment: Get connected to the database from within your PHP program and display information from the database in two different ways. See my examples.
Second assignment: MySQL PHP assignment
Some of the information for this asssignment is in Second Connect Group (maybe a little in First Connect Group). We will be working with that on Tuesday or better yet you can read ahead - either way you can have extra time for this assignment.
Week #6
Week of February 24th
I will not be on campus Thursday, February 27th. It is an online day. Check back!
We will move on with our overview coverage of SQL within MySQL.
Notes (some of which may be next week):
Keys, indexes etc.
Subqueries
Multiple tables
Functions
Assignments:
workingwithSQL.doc Play computer (do not actually run) and show me the output that would be produced.
SQL Assignment 2
A couple of the problems involve functions or subqueries - you can read ahead or wait on those questions until we go over them next Tuesday.
Week #5
Week of February 17th
We will work with MySQL/MariaDB and Putty and there are a lot of resources on the web for reference.
We will start with these and move on as time allows:
Beginning MySQL notes
Data types
More SQL
Assignments:
Select try
SQL assignment I know the directions say picture of screen but in fact I would prefer just copying the output and pasting it in so it is more readable - check putty directions for doing this!
Note that in the sample, I took an example I had used in Oracle. You need to check out how to do the date in MySQL.
Check back!
Week #4
Week of February 10th
My husband is still in the hospital recovering from open heart surgery, so I will do all my classes online.
We will start out by looking at GroupThreePlusPHP Boston Tea Party, GroupFourPHP and GroupFivePHP.
Third Group Plus PHP zipped
Fourth Group PHP zipped
Boston Tea party example PHP zipped
Fifth Group PHP zipped
Next we will start looking at MySQL.
In using these notes remember that the port is now 220.
Beginning MySQL notes
MySQL and putty
Using Putty in MySQL as of Feb 16,2016
I heard back from Eric and apparently we are now using MariaDB instead of MySQL at the prompt. However they changed the prompt back to MySQL so...
Experiment with MySQL please.
Assignments:
Assignment #1: 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 4 pages.
Assignment#2: Develop a table with at least 5 fields and at least two different types. Populate the table and then do five different queries using ANDs and ORs.
Check back.
Week #3
Week of February 3rd
My husband is having emergency surgery this week so I will not be in for class on Tuesday and Thursday.
Joe Fletcher is available for help if you encounter probems - check the help session above and look for him in K101 for the 11:00 class and the 12:30 class.
You can find Third Group Plus PHP at Third Group Plus PHP
Fourth Group PHP zipped
I strongly recommend that you go to the audio and Smartboard from last Spring and find the lectures on the third and fourth group.
Assignments:
Loop Quiz: without loop program Please download this program and modify it three times. Once to use a while loop, once to use a do...while loop and once to use a for loop.
Program to write: Write a program to do the algebraic equation x = a +a(b+4)/2 multiple times within loops that vary a and b. The variable a should start at 1 go to 10 and increment by 1. The variable b should start at 2 and go to 10 and increment by 2. When you display the answer show the formula in php. I want you to do this three times: once with a for...next, once with a do...while and once with a while.
Check back!
Week #2
Week of January 27th
We will continue with PHP looking at Second Group PHP and we might even start Third Group PHP. You can find Second Group PHP at Second Group PHP
You can find Third Group PHP at Third Group PHP
Below is a presentation on the structure of IF statements.
Presentation on logical if structures - review
    Separate speaker notes to accompany presentation on logical if structures
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
To load things up on the Internet, we use WINSCP. Please read the WINSCP and cisweb information: (note that in my examples I use cisweb.bristol.mass.edu as the host, we are now using cisweb.bristolcc.edu as the host. The port has also changed to 220.
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.
WINSCP
Assignments:
Assignment #1: Write an HTML that takes in at least three pieces of data. Pass the data to a PHP program that processes the data and displays the results.
Assignment #2: 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 January 20th
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 cisweb.bristol.mass.edu we are now using cisweb.bristolcc.edu.
The port is now 220.
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 cisweb and copy my examples from First Group PHP up to the site.
You can find First Group PHP at First Group PHP revised - a few things have been added
Assignments:
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 the week it is assigned so due January 30th.(Note that homework is always due the Thursday of the week after it is assigned unless I give a specific due date - usually because I want to go over the assignment).
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.
Check back after we have held a class

Send e-mail to Priscilla Grocer: Priscilla.Grocer@bristolcc.edu

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