| 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 #15 Week of May 5thth |
Required Status Sheet Note that the Status Sheet is required and I do not calculate your grade until I get it. It is your insurance policy and mine as well. If you say you passed something in and I don't have it, I will contact you to straighten it out. Homework is due on Monday, May 12th, but I will take things up until the last day of classes, Wednesday, May 14th. I would appreciate them coming in sooner so send them as you complete them.If you owe a lot, I absolutely need to get most of them in the next week and not a load at the end. I have been sick so I am a little behind - sorry! Check back! |
| Week #14 Week of April 28th |
INFORMATION: Be sure to look at the update examples and a video on Update1a.EXAMPLES TO LOOK AT: Here are some examples of updating.UpdateFunctionPHP.zip TOPIC VIDEOS: Update1a notesSMARTBOARD AND AUDIO NOTES FROM Spring 2018/2019/2020 and Fall 2019: Update and builtin functions (4/4/19) in PDF format Accompanying audioUpdates and builtin functions (4/4/19) Accompanying Smartboard presentations ASSIGNMENTS TO DO: You need to write an update program that can add, change or delete records in a database table. I am looking for effective maintenance and something easy for the user to work with. You need to be able to add a record to the database table, change an existing database record and delete a record from a database record. I suggest you use my update as a model to create one of your own with a different database table. You can also decide to write one from scratch. Note the table I am referring to here is a file in a database.Check back! |
| Week #13 Week of April 21st |
At the beginning of the week we will look at images. Then we will look at email, cookies and sessions. Please read the following: Cookies Sessions More on sessions EXAMPLES TO LOOK AT: Images First Group PHP zippedImages Second Group PHP zipped Email Group One PHP zipped Email Group Two PHP zipped cookies session zipped SessionsGuess.zip More on session guess games TOPIC VIDEOS: Images in First GroupImages in First Group continued Images in Second Group Basic email Images in email Using databases in email Form using header(location) Cookies Sessions using guess game SMARTBOARD AND AUDIO NOTES FROM Spring 2018/2019/2020 and Fall 2019: Images first group (4/18/19) in PDF format Partial accompanying audioThird Arrays and first images (4/18/19) Accompanying Smartboard presentations Images second and email first (4/23/19) in PDF format Partial accompanying audio Second images and first email (4/23/19) Accompanying Smartboard presentations Email and sessions and cookies (4/30/19) in PDF format Partial accompanying audio Email and sessions and cookies (4/30/19) Accompanying Smartboard presentations ASSIGNMENTS TO DO: Quiz: 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!You need to identify yourself on the emails you send through PHP so I know who sent them. I have had some that were unclaimed in previous years, so if you have not heard back, resend Email First: Make a email using html and php. It should include an image, color and several different html features. Email Second: Set up a database table with idno, name, email and major. Send an email to everyone in the database. Clearly I should be in the database. Please test sending it to yourself and only send me the email when it is working - you need to send it to my Bristol email. Actually the Bristol email seems to have problems with images so test things out with your own email address. Check back as usual. |
| Week #12 Week of April 14th |
INFORMATION: CATCH UP WEEK |
| Week #11 Week of April 7th |
INFORMATION: CIS Alum Panel on Zoom at 12 noon on Thursday, April 10th. I will send the address to your Bristol email. Please try to come, it is highly recommended by many students who have attended.This is a part of CIS120, but everyone is invited and since it is about career paths, I think it is valuable.CIS Alum Panel April 10, 2025 - recording audio only We are going to continue looking at arrays this week. EXAMPLES TO LOOK AT: Array Group Second PHP zipped Started last week.Array Group Third PHP zipped TOPIC VIDEOS: Misc in Second Array GroupArray second another2dim (first two) Array second another2dim (next two) Misc examples from third array group Misc examples from third array group continued Sequence of programs about rainbow colors SMARTBOARD AND AUDIO NOTES FROM Spring 2018/2019/2020 and Fall 2019: Second/Third Arrays (4/16/19) in PDF format Partial accompanying audioNote the Smartboard was a problem and the second part of Third Arrays was lost. I suggest you look at Spring 2018 c159Apr1218.pdf). Second/Third Arrays (missed the first part) (4/16/19) Accompanying Smartboard presentations More arrays (4/10/18) Accompanying audio More arrays (4/10/18) Accompanying Smartboard presentations Even more arrays (4/12/18) Accompanying audio Even more arrays (4/12/18) Accompanying Smartboard presentations ASSIGNMENTS TO DO: Solve using arraysCheck back! |
| Week #10 Week of March 31st |
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.If you are far behind, you need to make a decision about dropping the course or continuing. Wednesday, April 2 is the last day to withdraw from classes with a W. If you do not withdraw and are not passing at the end of the semester I cannot withdraw you so I will have to give you an F unless there are extenuating circumstances that we have discussed and agreed upon. This week we are going to start to look at arrays. We will return to updating after we cover arrays. EXAMPLES TO LOOK AT: Array Group FirstArray Group Second PHP zipped Start this - it will also be next week. TOPIC VIDEOS: Introduction to arrays using using PHPTwo dimensional array using PHP SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: Intro arrays and guest speaker (4/9/19) in PDF format Accompanying audioIntro arrays and guest speaker (4/9/19) Accompanying Smartboard presentations Arrays continued (4/11/19) in PDF format Accompanying audio Arrays continued (4/11/19) Accompanying Smartboard presentations ASSIGNMENTS TO DO: Math ArrayAssignment: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. To clarify (I hope)... 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. Check back! |
| Week #9 Week of March 24th |
INFORMATION: Let me know if there is something you would like to go over.EXAMPLES TO LOOK AT: FunctionGroupPHP.zipFunctionsBuiltinGroupPHP.zip TOPIC VIDEOS: FunctionGroupBasics.mp4get proc 1 and 2 get proc 3 and 4 builtinfunctionsPHP ASSIGNMENTS TO DO: FunctionsCheck back! |
| Vacation Week Week of March 17th |
Enjoy your vacation but not so much that you don't do a lot of catch up if you are behind. I will be around for questions most of the week although toward the end less so. |
| Week #8 Week of March 10th |
INFORMATION: Now we will move on to ThirdConnectGroup.EXAMPLES TO LOOK AT: Third Connect Group zippedSometimes 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 PHPDelete 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 exmples 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 audioConnecting 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 quizThird Connect Group Assignment Check back! |
| Week #7 Week of March 3rd |
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 zippedConnect 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 GroupSecond 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 audioFinishing 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 ConnectCheck back! |
| Week #6 Week of February 24th |
INFORMATION: Using Putty (copy and paste)EXAMPLES TO LOOK AT for MySQL: Keys, indexes etc.Subqueries Multiple tables Functions TOPIC VIDEOS: Keys and indexes etcSubqueries 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 audioMore 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 February 17th |
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 student3rd 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 February 10th |
INFORMATION: I am going to be away for a long weekend, still checking my email periodically, but I decided to load the week of early.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 zippedFourth Group PHP zipped Boston Tea party example PHP zipped Fifth Group PHP zipped TOPIC VIDEOS for PHP example: Group 5 examples explainedTopic 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 notesThings 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 puttyMySQL 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 audioIntroduction 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 PHPAssignment#2: Basic Queries The queries should be done using MySQL within putty. |
| Week #3 Week of February 3rd |
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. 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 PHPFourth 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 audioPHP 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 January 27th |
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 PHPYou can find Third Group PHP at Third Group PHP TOPIC VIDEOS: Group 2 payroll examplesGroup 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 audioPHP 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 January 20th |
INFORMATION: Introduction to CIS159 - Spring 2025Introduction to CIS159 - Spring 2024 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. There are a lof of examples under CIS122 Internet Developer (under previous semesters). 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 WinSCP Note instead of the host as cisweb.bristol.mass.edu we are now using cisweb.bristolcc.edu. The port is now 220. WinSCP is available as open source software and you can download it for home use. 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: FirstGroupPHP - hello world through nameFirstGroupPHP - 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 audioFirst 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: If you are new to HTML, I want you to build a web page. The page should include at least: list table, CSS and form.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. 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. |