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.

Assignments passed in have to include the code and the output unless other directions are specifically given.

Assignments are individual projects. Play computer means to figure out the results yourself by evaluating the data rather than running the query. When you are asked to write code you should also show the results that the code generated unless specifically told not to.

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.
HELP schedule	I will set up some optional class Zoom meetings that you can attend. Check the week of information to see the times and dates. I am also available by request (give me a few time options) especially while we get other support in place. I have been meeting with a lot of students that request it, maybe something you should consider doing. You can email me with a couple of times you can meet and usually one of those will work. I will send out the information to contact me on Zoom. I will post availability but you can also set something up with me.
Week #8 Week of October 20th	INFORMATION: Now we will move on to ThirdConnectGroup. EXAMPLES TO LOOK AT: Third Connect Group zipped Sometimes you may find an extra program being discussed or some small change made when you look at the videos. I experiment sometimes! TOPIC VIDEOS: Insert into MySQL using PHP Delete and update MySQL using PHP More on insert, update, delete MySQL using PHP Continuing ACD (add, change, delete) MySQL using PHP Misc other things using PHP and MySQL Rest of the misc examples in Third Connect Group using PHP and MySQL SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: Connecting PHP and MySQL cont (3/19/19) in PDF format Accompanying audio Connecting PHP and MySQL cont (3/19/19) Accompanying Smartboard presentations Third Connect Group (3/26/19) in PDF format Accompanying audio Third Connect Group (3/26/19) Accompanying Smartboard presentations ASSIGNMENTS TO DO: PHP connect quiz Third Connect Group Assignment Check back!
Week #7 Week of October 13th	INFORMATION: Remember that if you get something returned with errors that means you do not have a grade and you need to fix and resubmit. 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. EXAMPLES TO LOOK AT: First Connect Group zipped Connect Explanation Note that some versions require the database name (that I call OptionalDB) in the code for the link (linkpass.php) Second Connect Group OK TOPIC VIDEOS: First Connect Group Second Connect Group part 1 Second Connect Group part 2 SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: Finishing SQL & Connecting (3/3/20) in PDF format Accompanying audio Finishing SQL & Connecting (3/3/20) Accompanying Smartboard presentations Relational database (3/5/20) in PDF format Accompanying audio Relational database (3/5/20) Accompanying Smartboard presentations Connecting MySQL and PHP (3/10/20) in PDF format Accompanying audio Connecting MySQL and PHP (3/10/20) Accompanying Smartboard presentations ASSIGNMENTS TO DO: Basic Connect Check back!
Week #6 Week of October 6th	INFORMATION: Using Putty (copy and paste) EXAMPLES TO LOOK AT for MySQL: Keys, indexes etc. Subqueries Multiple tables Functions TOPIC VIDEOS: Keys and indexes etc Subqueries etc Multiple tables Functions SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: More MySQL (thru indexes) (2/26/19) in PDF format Accompanying audio More MySQL (thru indexes) (2/26/19) Accompanying Smartboard presentations MySQL (thru functions) (2/28/19) in PDF format Accompanying audio MySQL (thru functions) (2/28/19) Accompanying Smartboard presentations ASSIGNMENTS TO DO: workingwithSQL.doc Play computer (do not actually run) and show me the output that would be produced. SQL Assignment 2
Week #5 Week of September 29th	INFORMATION: We will start out by looking at the layout of tables when we create a database. Specifically we will look at third normal form. Then we will look at SQL focusing on the notes from last week. Next week we will look at multiple tables in SQL among other things. Notes on relational database The MySQL notes from last week and this week will be the major source of information to do the assignments. See page in browser EXAMPLES TO LOOK AT for MySQL: Beginning MySQL notes (repeat from last week) Data types More SQL TOPIC VIDEOS: 3rd normal form - intro student 3rd normal form - order and donor 3rd normal form - one to many MySQL more SQL MySQL more SQL continued ASSIGNMENTS TO DO: 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. For students taking Oracle and MySQL I wanted to highlight the similarity in SQL. Check back!
Week #4 Week of September 22nd	INFORMATION: We will start out by looking at or continuing to look at GroupThreePlusPHP Boston Tea Party, GroupFourPHP and GroupFivePHP. EXAMPLES TO LOOK AT for PHP: Some are repeated from last week since these topics really run over last week. Third Group Plus PHP zipped Fourth Group PHP zipped Boston Tea party example PHP zipped Fifth Group PHP zipped TOPIC VIDEOS for PHP example: Group 5 examples explained Topic videos for 4 and Boston Tea are under last week. Coverage of these spread over two weeks. In using these notes remember that the port is now 220. EXAMPLES TO LOOK AT for MySQL: Beginning MySQL notes Things that change! Note that the host is cisweb.bristolcc.edu, the port is 220 and the prompt does not have MariaDB in it it has MySQL. MySQL and putty - pre apporto - focus on SQL Experiment with MySQL please. TOPIC VIDEOS for MySQL examples: Bringing up MySQL in putty MySQL introduction - pre apporto MySQL introduction continued SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: Introduction to MySQL (2/19/19) in PDF format Accompanying audio Introduction to MySQL (2/19/19) Accompanying Smartboard presentations Continuing Intro to MySQL (2/21/19) in PDF format Accompanying audio Continuing Intro to MySQL (2/21/19) Accompanying Smartboard presentations ASSIGNMENTS TO DO: 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.This should be done with PHP Assignment#2: Basic Queries The queries should be done using MySQL within putty.
Week #3 Week of September 15th	INFORMATION: Continuing with PHP Basics. We are looking at Group 3, Group 4 and Boston Tea this week and into next. If you are having trouble connecting or running PHP, please contact me or your tutor Tom. We can set up a Zoom if that would help. EXAMPLES TO LOOK AT: You can find Third Group Plus PHP at Third Group Plus PHP Fourth Group PHP zipped You should also work on the Bston Tea Party educational example. Boston Tea Party PHP zipped TOPIC VIDEOS: Group 3+ Group 3+ continued Group 4 while loop Group 4 do while loop Group 4 for loop misc Group 4 loop within loop Boston Tea Party SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: PHP Fourth Group LOOP (2/7/19) in PDF format Accompanying audio PHP Fourth Group LOOP (2/7/19) Accompanying Smartboard presentations Boston Tea, Third Plus Group, Fifth Group (2/12/19) in PDF format Accompanying audio Boston Tea, Third Plus Group, Fifth Group LOOP (2/12/19) Accompanying Smartboard presentations ASSIGNMENTS TO DO: 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 September 8th	INFORMATION: 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 I have broken the PHP down into groups of examples with accompanying videos. During week #1, I suggested you look at First Group PHP to get familiar with the basics and now we are going to move on to Second Group PHP and Third Group PHP (Third Group will also be a topic in Week #3. 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. Old video: Here is information about using cisweb and WINSCP at BCC Once you log into cisweb, you can write your PHP and store it on cisweb. You should back up your work. You can then go to a browser and bring up the work. If you want to download WINSCP at home, you can find it at this address. WINSCP EXAMPLES TO LOOK AT: We will continue with PHP looking at Second Group PHP and we will start Third Group PHP. You can find Second Group PHP at Second Group PHP You can find Third Group PHP at Third Group PHP TOPIC VIDEOS: Group 2 payroll examples Group 2 sentence examples Misc from Group 2 Group 3 if and Group 3 if or both SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: PHP Second Group (1/31/19) in PDF format Accompanying audio PHP Second Group (1/31/19) Accompanying Smartboard presentations PHP Third Group IF (2/5/19) in PDF format Accompanying audio PHP Third Group IF (2/5/19) Accompanying Smartboard presentations PRESENTATIONS: Below is a presentation on the structure of IF statements. Presentation on logical if structures - review ASSIGNMENTS TO DO: 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 September 1st	INFORMATION: CIS159 - Fall 2025 Introduction to CIS159 - Spring 2025 Introduction to CIS159 - Spring 2024 We will start off the semester with a quick review of HTML and CSS and then we will actually start PHP. You can find review information at CIS120 at this website. As I am sure you know, a great reference for writing HTML is W3Schools You should be getting a username/password for the Bristol site at the end of this week. We will be working exclusively off the Bristol cisweb site. You do not need to install PHP or MySQL, they are on the server. EXAMPLES TO LOOK AT: When we start to look at PHP log into cisweb and copy my examples from First Group PHP up to the site. You cannot do this until you have received password information from IT. You can find First Group PHP at First Group PHP revised - a few things have been added TOPIC VIDEOS: Apporto instructions for using WinSCP. FirstGroupPHP - hello world through name FirstGroupPHP - html to PHP Downloading and uploading PHP examples Another example of downloading and uploading PHP SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: First day, review HTML, intro PHP (1/23/20) in PDF format Accompanying audio First day, review of HTML, introPHP (1/23/20) Accompanying Smartboard presentations First group PHP (1/28/20) in PDF format Accompanying audio First group PHP (1/28/20) Accompanying Smartboard presentations ASSIGNMENTS TO DO: I want you to build a web site using HTML and CSS that introduces yourself (need to send me a link to the site out on the web).. The site should include two linked pages and some images. 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 and use of forms - experiment! Due the Thursday after the week it is assigned so due September 11th. (Note that homework is always due the Thursday of the week after it is assigned unless I give a specific due date.) 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.

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

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