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.

The last day for students to withdraw from classes is November 15th. If at the end of the semester you have not done enough work to pass my only option is to give you an F - I cannot withdraw you. Please evaluate your status and contact me if you have questions.

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 tape all my classes and capture notes on the Smartboard. These are available to you under Audio and Smartboard.
Week #12
Week of November 19th
We are going to look on the section with images.
Images First Group PHP zipped
Images Second Group PHP zipped
Check back!
Assignments:
Quiz on databases and images Just to clarify when you bring up a random picture I want the address taken from the database table to be used. Really more like homework!
Week #11
Week of November 12th
More on arrays.
Array Group Second PHP zipped
Array Group Third PHP zipped
Assignments:
Math Array
Assignment:The statements Multiply by 0, Multiply by 1 are stored in a one dimension array and displayed. You need to extract the message from the array and display it before you show each group. You are going to display the math facts and the answers. The answers need to be stored in a two dimensional array. Set up a two level table to print out the math facts and get the answer from the two dimensional array. The two multipliers are the indexes that allow you to extract the answer. I used a nested while loop to do this and another time I used a nested for loop.
Dave said there is a lot of confusion so here is something that might help... So there should be one array that has messages in it: Multiply by 0, Multiply by 1 etc. Every time you change to multiply by a different number, you display one of them. Then you are going to set up a loop with i and j or x and y whatever. To get the answer you want to display you need to go to a two dimensional array that contains the answers and extract them using the i and j or x and y or whatever. So for the first problem i is 0 and j is 0 so you use those to go to the two dimensional table and extract the answer of 0. For the last problem k is 4 and j is 4 so you use those to go to the two dimensional table and extract the answer of 16. It is kind of like extracting the miles from one city to another using two indexes (from city and two city). Here you are using two indexes that are the two numbers you are multiplying. A few more arrays
Week #10
Week of November 5th
We will start out with catch up time - let me know where you stand.
Week #9
Week of October 29th
We will start the week by looking at updating records using PHP with MySQL.
Next we will start arrays.
Array Group First
Assignments:
Connect quiz
Array Quiz
Update assignment: Create a table through PHP with 5 fields at least one of which should be numeric and populate the table. To get an A you need to follow the outline below. If you decide to write a modified version that is not as demanding you will get a lower grade but it will be accepted (clear the changes with me before writing the code).
I want you to write a program to update. The user should fill out the form as needed and pass to a php program. The form should have a place to fill in whether it is an A, C/U or D and an idno (this is one of your fields and it cannot be changed). Then if the user wants to add/insert they should fill in all the boxes. If the user wants to delete, the idno was enough the other boxes can be blank. If the user wants to update they should fill in the fields they want to change. The PHP program should then add/insert if the code said A, delete if the code says D and change if the code says C or U (you choose which code to use for the change/update). Note that on the change/update I only want you to make changes to the database table where there is content in the field. Otherwise the data should stay the same. In other words if you have a field called city and on the form city was left blank then the city should stay the same. If the city changed then the database table record should contain the new city.
Extra Credit:If you write a program that sets up a parallel array nameArray so that when you sort numArray it will keep the name with the number.
12 twelve
27 twenty-seven
15 fifteen
when you sort you still have the number and name together. This needs to use parallel arrays.
Week #8
Week of October 22th
THURSDAY OPEN LAB for catch-up: This Thursday will be a catch-up day. K101 will be an open lab from 9:30 until 5:00. I will be there until around 3 and Lindsey will be there during 11, 12:30 and after 3.
We will start the week looking at more connection examples. We need to work more on SecondConnectGroupOK and then we will move on to ThirdConnectGroupOK and FunctionGroup.
Third Connect Group
FunctionGroupPHP.zip
UpdateFunctionPHP.zip
Assignments:
Function assignment
Check back!
Week #7
Week of October 15th
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:
MySQL PHP assignment
Check back!
Week #6
Week of October 8th
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
Notes:
Keys, indexes etc.
Subqueries
Multiple tables
Functions
Assignments:
workingwithSQL.doc Something we will start in class and continue next week - show me the output that would be produced.
SQL Assignment 2
Week #5
Week of October 1st
Please be sure you have looked at the examples in the FifthGroupPHP.
We will look at getting into MySQL and the notes from last week.
Assignments:
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.
Week #4
Week of September 24th
We will look at Fourth Group PHP and Fifth Group PHP and then start to look at MySQL.
Fifth Group PHP zipped
Beginning MySQL notes
MySQL and putty
Using Putty in MySQL as of Feb 16,2016
Experiment with MySQL please.
Check back!
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.
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 Plus PHP zipped
Boston Tea party example PHP zipped
Fourth Group PHP zipped
Assignments:
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.
Reference: classtime examples
Decision Quiz
Week #2
Week of September 10th
We will continue with PHP looking at Second Group PHP and Third Group PHP. You can find Second Group PHP at Second Group PHP
You can find Third Group PHP at Third Group PHP
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 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.
WINSCP
Assignments:
IF Assignment
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 3rd
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.
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 February 1st.(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 worked 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: Priscilla.Grocer@bristolcc.edu

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