Here's what I got out of our discussion Wednesday in class and the
specifications that we decided on for Homework #6. Let me know if you
understand things differently than I did and we can resolve the
discrepancy in class on Friday.
Additions to the table:
I will add a firstname and lastname field to
each table that will be varchar(50).
An administrative user is one with the active column 2.
I will change each table so that the user kelly is the one
with admin privileges. (done)
User Changes that are allowed:
email address, password (with the usual password conventions
that you
must type it twice to confirm), username (they have to enter
their
password to change this and it can't already exist in the
table).
Admin Changes:
The page will prompt for the first name,
last name and email address.
The admin will type in some data and then the record fitting that
information will be displayed and the admin will be allowed to change
the name fields, the username field, the password field and the
active/inactive field.
If more than one row was found you can either
show all rows found (no paging needed) or return an error.
Admin Add:
The page will show the fields that the admin needs
to fill in for a new user: first name, last name, possible username
(that will have to be checked on submit that it is not already in
the table), and email address.
On submission, you will add a timestamp and set the
active field and make sure all fields have data.
2/10/04
I have the link for the web pages
that the class designed for mage
completed. Check it out and see if you have any ideas to make your page
even better! I'm sure the other students would like to know if you find
anything that doesn't work on their pages, also. Be sure to do this in
a kind manner!
Homework 5 is due Friday, the midterm should be in my office before
class on Wednesday if at all possible. Jordan and Eric are giving
presentations on Wednesday, guest speaker on Friday and customer next
Monday! Busy week! Be sure to read Chapter 6 in your spare time :).
2/6/04
Here's a link for a
press release about an online application. The
interface was written with PHP and we will have a discussion with the
President of AZO Technologies, Marc Dyksterhouse in the next few weeks.
You may also take a look at the
online application that was also written in php.
1/29/04
PP#1 is due Wednesday, February 4th not Monday, February 2nd. You
has a couple extra days!
The midterm will be take home. I will hand it out in class on
Wednesday, February 4th and it is due on Monday, February 9th. We will
have no class on February 6th but I will be available from 2-3:30 pm for
questions that day in my office.
Exercise 5.1 is not required to be handed in. Please think about it
and then check your reasoning with the answers online. Turn in the
solutions to the other 2 problems.
1/6/04
The list of possible topics for presentations 7th week until the end
of the quarter is available.
This list will be added to as items are suggested from you or discovered
by me.
12/19/03
We will be doing an inclass assignment on the first day of class.
Bring your php book from O'Reilly to class.
It won't be graded but it will be a more interesting way to learn php
then listening to me! This is what the assignment will be:
Create a form that has eight text boxes that each ask the user to input
a number. Add each number to an array and then output the original
input data sorted in numerical order. Also output the average, maximum,
minimum and median values. Don't forget to verify that the user entered
something for each text box and that the input values are numbers.
(Hint: Use the is_numeric() function.)
12/1/03
Welcome to CS491 - Special Topics in Database Applications! I know
we will learn a lot this quarter and I look forward to seeing what we
can accomplish together. If you are signed up for the class, come to
my office (208D in the Physics Suite) and introduce yourself!