| 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 | You may request the final after August 17th - it is due one week after I send it. |
| Notes and assignments #14 | See the information on sending an email. Assignments: Write the code to your website that will take an email address and send an email. |
| Notes and assignments #13 | This week we are going to look at some examples of PHP and MySQL. As always, check back! Assignments: Quiz with MySQL |
| Notes and assignments #12 |
This week we will continue looking at programming in PHP, normalization, and databases. Assignments: Write a program that will show the math facts and give a user the opportunity to enter the answer. Then evaluate the answer and return a message. For a B, you can simply return the message right or wrong along with the correct answer if wrong. For an A you should give the user three times to retry before giving the correct answer and moving on. The guessing game that we looked at last week should help with the development of this program. |
| Notes and assignments #11 | We are now dealing with databases (chapters #7 and #8) - if you are reading a
chapter a week, these should be covered - we
will also spend a little time dealing with normaliazation so you should move
on the chapter #9 (this week or next). We will also start looking at some
interesting other things in PHP and MySQL. I am going to go over reloading a form - look at the PowerPoint and examples. Assignments: Write a program where a random number is choosen and the user has to guess the number. There should only be one page that gets reloaded. 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 #10 | 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. This week we are going to finish our menu and load up some games, see note under last week. 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 Assignments: 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 #9 | We will continue looking at PHP and MySQL this week. Keep reading one chapter per week in the textbook. This week we created a common web site. Send me an email if you were not in class and I will give you the address, username and password. Assignments: Program(s) to write:I want you to write a PHP program or programs that will add a record to a table you have created, update a record, and delete a record. You also need to show the table before and after using a program. Class website: Please look at the common website (I made a change to one of the programs that we wrote in class - check it out. Then if you have a game, I would like you to create a sub directory and upload your small "Boston Tea Party" type game into the subdirectory. One program about moons is already there. You will need to modify the menu programs so that your program can be found. We will continue working on this in class on Tuesday. |
| Notes and assignments #8 | Keep reading in the text, you really should try to read a chapter a week, so please read
chapter #6. This week we are going to deal with functions and then we are going to move on
to connecting to the database. You will find it helpful to skip ahead and read the chapter
about connecting to a database ahead of time. Assignments: I have decided that we are going to put up a group website with the games that I assigned in week #5, so that means everyone need to make some kind of a game that kids can play and we will create a menu and upload to a common site next week. So the assignment this week is to finish or clean up a game you have already made OR make a game now! Email me and I will give you the password etc for the common site. The second assignment for this week is to make sure you can connect to the databases on cisweb and experiment with queries. You do not have to pass in this assignment - just let me know you were successful. |
| Notes and assignments #7 | 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 (although I had audio problems last week) to look at. You should also look up register_globals and PHP autoglobals. Your book starts to discuss them. 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 | 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. |
| Notes and assignments #5 | 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! I will be out of town on Friday so there will be no class. The lab is available if you want to work on things. You should also 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 Assignments: Please post a PHP tutorial site that you find useful on the CIT32 blog. 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 | Last session we dealt with multiple tables and relating them. We also
did a brief look at design (we will finish that this week and then start
PHP). I am going to have you continue working on MySQL - there will be a
homework assignment dealing with the the things from the last session. You should also
focus on PHP which is a way to program on the
web and manipulate the data in the database. For the first few sessions,
we will not be connecting to the database. 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 it on the web |
| Notes and assignments #3 |
This week we will continue with SQL, please look at the tutorials
I listed last week and at the PowerPoint presentations on SQL. Assignments: Second SQL assignment |
| Notes and assignments #2 | Be sure you look at the handout from last week about working with 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 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: SQL assignment Note: Make the identification number the primary key. 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. |
| Notes and assignments #1 | There will be 15 sets of notes and assignments - I will try to keep ahead of you so you
can plan vacations and the like. Tell me if I need to post more! 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. You should also take a look at the appendix on HTML in PHP Game Programming The PHP Game Programming is a reference book for use in doing projects. The main textbook is PHP/MySQL Programming. 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 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. Second: You should also accept my invitation to wikispaces and join. 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. Extra Credit: Create your own wiki, invite someone to join, they must make modifications. Send me the address! |