Announcements

Announcements appear on this page during the course.

11/23: Since several students asked for it, I added and updated comments for both formverifier.php and formlib.php. In addition, I updated formtest2.php.

11/01: Since some people had trouble with A8: Query and Report, I have extended the due date to Friday at the time specified in WebCT.

10/25: Last class, someone asked whether using mysql_insert_id() was safer that using mysql_query() with a "SELECT MAX(id)" type of query. The answer is that mysql_insert_id() is safer. If you use a SELECT query and someone else inserts a row in the milliseconds between your INSERT and the SELECT, you could get a wrong value. However, the value of mysql_insert_id() is affected only by statements issued within the current client connection. It is not affected by statements issued by other clients. For more information, see mysql_insert_id() from the MySQL manual.

10/24: Since some people had trouble with A7: Collecting User Input, I have extended the due date to Friday at the time specified in WebCT.

10/22: Some of you noticed that Quiz 7 contained question on some material not covered. I apologize for the error. The quiz questions are now corrected and I gave anyone who already took the quiz full credit for those questions.

10/15: John Witkowski found an easier way to make sure your database is compatible with MySQL 4.0. Rather than deleting the extra info manually, you can ask phpMyAdmin to supply a database dump compatible with older style MySQL versions. On the Export tab under SQL export compatibility, select MYSQL 40. Note that this option only appears if you have a newer MySQL version installed. Thus, you only see the option SQL export compatibility if you need to use it.

10/10: I extended the due date for both A4: Project Database Design and A5: Load Data and Index Tables to Friday 10/14/05 to allow you to fixup your dbname.sql files.

10/04: If you know a lot about computer hardware and like to work on them, you should consider taking the CIS-160AA: A+ Certification Exam Preparation course. This 2 unit online course starts in mid-semester with an orientation meeting on October 20th from 7:00 PM to 9:00 PM.

9/14: For Mac OS X users, Ed Braunhut found an installer kit named WebServerX Kit. If you try it, please let me know how it works.

9/06: If you are concerned about high gas prices or a potential bus strike, you should consider attending one of the Transportation Alternates meetings. In the meeting they will discuss online carpool matching, vanpooling, bicycle rack and locker subsidies, park and ride lot facilities, bicycle and pedestrian hazard reporting, electric bicycle and neighborhood electric vehicle subsidies. Meeting times are shown below.

Tuesday, September 6              Aptos Campus
2:00-2:45 p.m.
Room 833

Thursday, September 8             Aptos Campus
 8:30-9:25 a.m.
 Room 804A

Thursday, September 8         Watsonville Center
1:30-2:15 p.m.
 Room 4340

8/31: WebCT accounts should be available about 2 working days after you enroll in the course. If you have trouble logging in to WebCT after enrolling, please email or call me for help. Your initial WebCT password should be STUDENT. If STUDENT does not work, and you had a WebCT account over the summer or last semester, you should try to login with your old password. If all else fails, I can reset your password.

8/26: If you are interested in Data Mining, you should enroll in CABT190DM: Data Mining Essentials. This short class will be held on September 29-30 (Thur-Fri). Data mining provides a useful set of skills for analysis of large databases like those found in many corporations. Since this analysis often leads to increased profits, having skills in this area makes you more employable.

Home | WebCT | Announcements | Course info | Expectations | Schedule
Project | Help | FAQ's | HowTo's | Links

Last Updated: November 23 2005 @16:30:22