| 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! | |
| Notes and assignments #15 Summer 2007 |
Please complete this survey that the Division has requested and email it to me it to
or slide it under my door or give it to Karen Costa in the Division office.
CIS Student Survey Contact me when you are ready for the final and I will send it to you. You can have a week to work on it. The final is your own work, the only person you can talk to about it is me! Required status sheet |
| Notes and assignments #14 Summer 2007 |
Catch up week - please work on the project |
| Notes and assignments #13 Summer 2007 |
This week, we will look at Sessions and problems. On Thursday I am going to have an open lab.
Sessions Assignments: I would like you to do examples illustrating an understand of sessions. |
| Notes and assignments #12 Summer 2007 |
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. |
| Notes and assignments #11 Summer 2007 |
This week we are going to do more with connecting and images and... Working with images Images address on database 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 you to review the design of a relational database - either my notes from a previous course or information you find on line. The basic rules are in the following handout: Third Normal Form 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 |
| Notes and assignments #10 Summer 2007 |
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 and we are continuing with email. Information to check out: Connecting Connecting and updating Email variations 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. |
| Notes and assignments #9 Summer 2007 |
I was experimenting and adding new things when I taught this in the spring and I am still
experimenting so I am hitting several areas. Sorry! I want you to do some research on sending email this week. Assignments: Using PHP, send me a regular email and a HTML email including a link to a website, an image and some other HTML elements. |
| Notes and assignments #8 Summer 2007 |
Keep reading in the text, you really should try to read a chapter a week, so please read
chapter #6. Start looking at my connection examples and experiment with trying to get information from a MySQL database. You will find it helpful to skip ahead and read the chapter about connecting to a database ahead of time. Connecting Assignments: We did the guessing game in class - I will post the code we did in the Smartboard - you need to get a version loaded and working. You can expand it by limiting the guesses, making a better look etc for extra credit. Please write the Rock, Paper, Scissors game using the same structure that we used in the guessing game program. |
| Notes and assignments #7 Summer 2007 |
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. Please look at the first game under the binary games. It is discussed in audio and SmartBoard presentations. 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. |
| Notes and assignments #6 Summer 2007 |
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 a program that show me you know how to do the following: for loop, do loop, while loop, function. I want you to incorporate these into a program. It can be a program that you would use to generate information in a business setting or a game. Since we are not using databases yet, you will have to have the user key in information, process it and then it will be lost... |
| Notes and assignments #5 Summer 2007 |
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. 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 have a factual error in my tea party - called the wrong thing right or the right thing wrong - whatever - sorry! Assignments: Please post a PHP tutorial site that you find useful on the 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. |
| Notes and assignments #4 Summer 2007 |
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 |
| Notes and assignments #3 Summer 2007 |
We are going to start to work with MySQL this week - if you are still having problems with your
password please let me know and contact Carol.
Handout on using WinSCP3 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. 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 Assignments: 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 You need to put all of your tables into these two databases. |
| Notes and assignments #2 Summer 2007 |
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. While you are waiting for your password, I have sent you the login to the class site. Handout on using WinSCP3 We are going to start with PHP since you can use the class site for that. 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. Assignments: First PHP assignment Put this up on the web (use the class site if you do not have your own login.) |
| Notes and assignments #1 Summer 2007 |
I have requested a password and login for you - for now you can get a temporary password if you email me.
My availablity this summer The schedule can also be accessed through my home page. I will keep updating. 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. 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: 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. You can use the class site if you do not have your login - I have sent you the information for that. |