| 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! | |
| I will be available for help most Tuesdays (I will post if I am not) from 2-4 in K-116. I will also be available on Thursdays from 11-12 in K-101. My work study Marissa will be there as well and covering for me if I have to step out. Please try to come if you are having problems. If no one is comes I will be in my office K-112. | |
| Week #15 Week of May 7th |
Please complete this survey that the Division has requested and email it to me or give it to
me in class or slide it under my door or give it to Karen Costa in the Division office.
CIS Student Survey There will be open lab time in K101 from 9-11 and from 1-2. Lab time will continue in K 116 from 2-4. Please come to get help or give help! Your final is scheduled for 5/16/07 at 10:15 in K101. The final and status sheet are being posted to give you time to work on them. The final and the required status sheet must be sent to me prior to the start of the scheduled or you must come to the final and either take or complete your exam. The final is your own work, the only person you can talk to about it is me! Final exam Required status sheet |
| Week #14 Week of April 30th |
Open lab this week. Your exam will be posted one week before it is due. I will be out on Thursday, but Stephanie will be here to help. |
| Week #13 Week of April 23rd |
This week, we will look at Sessions and problems. On Thursday I am going to have an open lab.
Sessions Please check back! |
| Week #12 Week of April 16th |
This week we will continue talking about relational databases. Check back to see how we
are doing! Assignments: I have put C17Q1PHPS06.php and C17Q1toPHPS06.html on the CIT32 web site. I want you to modify so that when a student enters an id number, it varifies that the student is a valid student. Then the grade is entered in the database record providing the student has not use their three chances. Each time they take the test, the grade is entered. They have three chances to improve their score. The database table I used when I changed the programs is shown on this page: Database table example Project: Everyone needs to do a project that involves PHP and MySQL. I want you to try some interesting things and push what you know. You need to submit a plan to me for approval. |
| Week #11 Week of April 9th |
Advisement starts this week. I will be available for online advisement on Monday from 9-10 and
Wednesday afternoon and evening and then
on campus according to the signup on my door (I keep adding slots as needed, so check back).
You can also email me or IM me for advisement. This week we are going to do more with connecting and images and... Working with images Images address on database Check back as we progress - I am changing things a little so we are going day by day... We are having a group of kids for the service learning project from 9:00 to 11:15ish on Friday, so we will not have class on Friday. There will be seats in the back of the lab so you are welcome to come and work on projects and I will be able to help you. Anyone that would like to get involved in service learning and working with the kids on LOGO and Alice is invited to join us. Next, we are going to move on to putting up an image array. A good source for information on managing images with a Web Database Application: images and database I also want to talk a little about relational databases! Assignments: First: I want you to load some images to the web and then create a database that stores the address and then using a random number access one of your images via the address in the database. Second: Modify this program so that you loop through all of your images and show them. Third: I want you to save the code in this example and modify it so you can use it with your own images. I experimented and this is a zip of what I created - it is basically the code from the onlamp site: example from site listed above |
| Week #10 Week of April 2nd |
The first service learning project is Thursday from 10:00 - 12:00. It involves introducing
kids to LOGO and Alice - let me know if you are interested. I will not be available for help Thursday at 11:00. This looks like an interesting site: Web Standards, PHP, HTML, CSS, JavaScript and other fun stuff! Keep reading in the text. We are now dealing with databases. Information to check out: Connecting Connecting and updating Email variations On Thursday and Friday we will work on these things in class. Assignments: First: I want you to do some research on connecting and querying using the various options and then demonstrate what you learned - site your sources and tell me some knowledge you gained. Second: Write a program to add a record, change a record or delete a record based on user input. Third: I also want to go back to using email and have you create a table that contains a name field and an email field, I then want you to write a email program that addresses the person by name in the body of the email and sends the email to everyone on the list. |
| Week #9 Week of March 26th |
We will start out by getting up the common web site. The next topic will be email with PHP
(please look at examples and presentation). Then we will get back to connect issues
using a MySQL database. Assignments: Load you game and make changes to menugame.html and menuchoice.php (on cit32) so that I can select and view your game. Send me a regular email and a HTML email including a link to a website, an image and some other HTML elements. |
| Week #8 Week of March 19th |
Keep reading in the text, you really should try to read a chapter a week, so please read
chapter #6. We got connected last week - however, I think I am going to back up a little this week and cover a
few things that I am seeing as problems with MySQL queries and spend some time with a little more PHP.
Then we will move on to the connect stuff maybe at the end of this week, maybe next week.
You will find it helpful to skip ahead and read the chapter about connecting to a database ahead of time. Assignments: We are going to create a menu and then you need to upload your game and make the link to your game. Email me and I will give you the username and password for the common site (if you are in class I will tell you there). We did the guessing game in class - I will post the code we did in the Smartboard - everyone needs to get a version loaded and working. Please write the Rock, Paper, Scissors game using the same structure that we used in the guessing game program. |
| Week #7 Week of March 5th |
Note I have added a help lab in K-101 on Thursdays at 11:00. Acutally this week on Thursday (Match 8th), I am going to have all my classes from 9:00 until 2:00 open labs. You can come to K-101 during your class time or any time during that period for help. If you are not completely caught up, you should make a point of coming for at least your class hour! This week we will look at arrays and see what else we have time for. Please read chapter #5 in the PHP/MySQL Programming text book. There are examples, presentations, Smartboard notes and audio. You should also look up register_globals and PHP autoglobals. Your book starts to discuss them. This week, we will take a quick look at connecting from PHP to a MySQL database. We will experiment with these examples and return to look at more after vacation. Connect examples Assignments: Analysis of showbinary.php: I want you to give a detailed analysis of the program showbinary.php. In the process, I want you to look for errors and suggest fixes if you find any. Write a program or programs in PHP illustrating your understanding of arrays. You should demonstrate three different array examples including one that has a two dimension array. I am looking for programs at the same complexity level as my examples. |
| Week #6 Week of February 26th |
The help session this week will be run by Marissa - I have a meeting in Boston. This week we will focus on loops and functions. You should also read chapter #4 in the PHP/MySQL Programming text book. As always, you should look at examples and presentations and if you miss class, I would listen to the audio along with the Smartboard notes from the class. Assignments: Your assignment this week is to write one or more programs that show me you know how to do the following: for loop, do loop, while loop, function. |
| Week #5 Week of February 19th |
This looks like a good site - the specific address I have put up deals with forms.
Form setup Everyone in the class is going to have to do a project due at the end of the semester that will involve MySQL and PHP. For people who are experience in web programming, I think it would be more beneficial to do another major project instead of some of the PHP homework that I am putting up last week and for the next few weeks. If you want to take this option, you need to discuss it with me. Note: The topics that I cover need to be included in the project in some way: if, loop, array etc. However, any assignment that involves MySQL must be done by everyone! You should read chapter #3 in the PHP/MySQL Programming text book. 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 Note - I believe I have a factual error in my expedition - we will check! Assignments: Please post a PHP tutorial site that you find useful on the CIT32 blog or del.icio.us site. I would like you to write a history game for kids (make yours accurate!). It should be something along the lines of what I did for the Boston Tea Party. |
| Week #4 Week of February 12th |
I am going to talk about multiple tables and relational database development
this week. Look up some information on relating multiple tables in SQL. We will return to PHP at the end of the week. Check back! Assignments: Second SQL assignment |
| Week #3 Week of February 5th |
We are really going to take a look at MySQL this week. The information is included in week #2
when I thought we were going to do it then. So... At the end of this week, please finish
all of the things in week #2. Here is an example sheet for use when you are creating databases and tables in putty: Using putty to create a database and table Here is another example sheet for use when you are maintaining and doing queries similiar to the ones I have assigned. Using SQL with MySQL |
| Week #2 Week of January 29th |
I had a few technical difficulities, but the notes and audio are finally up and working - I hope.
Let me know if there is a problem. I will be available in K-116 for help on Tuesday from 2-4 so if
you have questions or need help, please drop by. I will be out on Friday, I am giving a speech at a conference. I think it is useful to come to class anyway and work together on assignments - your choice! Handout on using WinSCP3 Note that WinSCP3 is available as open source software and you can download it for home use. When logging in at school, you should not enter your password and you should not save. If you do not enter the password you are prompted for it but it is not saved. This provides you with security for your site. Change for this week: We have not completed the setup of the databases for MySQL, so we are going to start with working with PHP and then move to MySQL. That means that the information about MySQL will either be started on Thursday or next week. Please look at the beginning PHP examples and the beginning PHP PowerPoints. You should also read chapter #1 and start reading chapter #2 in the PHP/MySQL Programming text book. Change - probably next week before we get to this - maybe Thursday: This week we are going to focus on setting up MySQL on a server and querying and maintaining it. You will be accessing MySQL on the cisweb server. Information about MySQL is available at their web site. MySQL site Information about using it at BCC is on this handout. Using MySQL on the cisweb server If you want a copy to work with at home, a copy is available on the CDs accompanying the text book or at this site. Please look at the presentations under MySQL on using MySQL. Note: You will need your cisweb username and password. If you have not gotten it yet, contact me. You should also get a copy of PuTTY to use with MySQL if you plan to work from home. PuTTY is available in the labs. Two sites that can be used to download PuTTY are: PuTTY PuTTY You should be looking up tutorials on SQL. Two that I think are good are: SQL Tutorial (based on MySQL) A Gentle Introduction to SQL This is especially helpful for someone who has had Oracle because it shows comparisons between the two versions. Assignments: Change - this weeks assignment First PHP assignment Put this up on the web. Change - assignment for next week SQL assignment Note: Make the identification number the primary key. Look at my examples to figure out how the date is stored in MySQL - you need to make some adjustments. Remember: You have two databases that have been assigned to you (there are named this way: first two characters of first name plus first two characters of last name plus 1 or 2). You need to put all of your tables into these two databases. |
| Week #1 Week of January 22nd |
Read chapter #1 in PHP/MySQL Programming. We will start off the semester
with HTML/XHTML. If you have already had CIS44 or have previous experience, this will
be a review. For others I suggest that you chapter #1 carefully and use resources at
the page for CIS44 or other resources on the web to accquaint yourself with HTML.
The students in this class have a variety of backgrounds. Students with experience in
XHTML/HTML and programming for the web, should see me for alternative assignments and projects. Handout on using WinSCP3 Note that WinSCP3 is available as open source software and you can download it for home use. When logging in at school, you should not enter your password and you should not save. If you do not enter the password you are prompted for it but it is not saved. This provides you with security for your site. Assignments: First: If you are new to HTML, I want you to build a web page and upload it to the server. 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 have not used before - this is the time to explore more CSS or forms - experiment! Due in two weeks. Hopefully I will have your server login information soon - if not we will extend the due date. Second: You should also accept my invitation to wikispaces and join (sent to your BCC address - if you don't get it, let me know). My space for this course is at CIT32 Wikispace The directions for this assignment are: Wiki Assignment I will go over how to use the wiki in the first class. If you have questions, please contact me at the web address given in class. Third: I want you to set up a blog using WordPress. You then need to send me the email address you used so I can send you an invitation to contribute to the class blog. wordpress.org As always, check back! |