CIS 401 Management Information Systems

Pet Project Team

Project Manager: Rebekah Smith

Project Programmers:
Jeremy Wheeler
Kevin Gleason
Alicia Strupp
Mike Tice




Assignment 1

Instructor Details


Test Programs:
Common.php Test Program - This is used to test the Common.php file.

View test Code:
Test programs for common.php file - Ths is the php code for the test of the Common.php file
CNB Bug -This file includes the fix for the coursenotebook bug.


Assignment 2

Instructor Details

SourceForge Memo

Project 1
Login Page - This allows the user to login and validates that they are a user and creates a session.
Test Page - This is the test created to ensure that the login functions are working correctly.
Source Code
Login Page - This is the source code for the login page.
Test Page - This is the source code fot the seperate test page.

Project 2
Message Board - This is the program that runs the message board.
Source Code
board.php - This is the source code for the message board.
messagePost.php - This is the source code for actually inserting the message into the MySQL tables.


Assignment 3

Instructor Details


Project Pages

Login Page -- a3.html - This is the login page.
Test Page for functions.php - This is the page that runs the tests for functions.php
Test Page for commonDB.php - This is the page that runs the test for commonDB.php

Source Code
Database_Schema - This is the table stucture and data information.
functions.php - Here are the functions used for this project.
main.php - This is the main program of the project.
commonDB.php - Here are the database commands for this project.
login.php - Here is the login code.
testcommon.php - Here is the test code for testing the commonDB.php file.
testfunc.php - Here is the test code for testing the functions.php file.

 


Assignment 4

Instructor Details


Project Pages

Login Page -- p_a4.html - This is the login page.

Source Code
Database_Entity-relationship Diagram - This is the tables ER.
Create Database - This is the tables creation script.
functions.php - Here are the functions used for this project.
main.php - This is the main program of the project.
commonDB.php - Here are the database commands for this project.
login.php - Here is the login code.
testcommon.php - Here is the test code for testing the commonDB.php file.
testfunc.php - Here is the test code for testing the functions.php file.

 


Assignment 5

Instructor Details

Programming Pair 1 Assignment - Jeff & Alicia
Project Pages

Login Page -- p_a5.html - This is the login page.
Test createSessionView - This page test the create session view php file.
Test Common.php - This file tests the common.php file.
Test Functions.php - This file test
s the functions.php file.
Source Code
Database_Entity-relationship Diagram - This is the tables ER.
Create Database - This is the tables creation script.
functions.php - Here are the functions used for this project.
main.php - This is the main program of the project.
commonDB.php - Here are the database commands for this project.
login.php - Here is the login code.
createSessionView.php - This is the new file for assignment 5, that get specific user info.
testcommon.php - Here is the test code for testing the commonDB.php file.
testfunc.php - Here is the test code for testing the functions.php file.

Programming Pair 2 Assignment - Nick & Jeremy
Project Pages

Pet Adoption Software Homepage - Our homepage on sourceforge. All source code can be found here.




Assignment 6

Instructor Details

Programming Pair 1 Assignment - Jeff & Alicia

Project Pages
Login Page -- p_a6.html - Visitors use [mu, mu] for an administrator and [1, nerds] for a normal user.
Test createSessionView - This page test the create session view php file.
Test Common.php - This file tests the common.php file.
Test Functions.php - This file test
s the functions.php file.
Administrator Page - Allows the administrator to maintain site.
Add User Page
- Allows the administrator to add users.
Delete User Page - Allows the administrator to delete users.
View Log Page - Allows the administrator to view and empy log.
View User Page - Allows administrator to view, delete, and add new users.

Source Code
Database_Entity-relationship Diagram - This is the tables ER.
Create Database - This is the tables creation script.
functions.php - Here are the functions used for this project.
main.php - This is the main program of the project.
commonDB.php - Here are the database commands for this project.
login.php - Here is the login code.
createSessionView.php - This file gets specific user info.
testcommon.php - Here is the test code for testing the commonDB.php file.
testfunc.php - Here is the test code for testing the functions.php file.
adduser.php - This file lets the administrator add a new user.

deleteuser.php - This file shows how the user is deleted.
viewlog.php - Allows the administrator to view and empy log.
viewuser.php - Allows administrator to view, delete, and add new users.

emptylog.php - Allows the administrator to empty the log.

Programming Pair 2 Assignment - Nick & Jeremy
Project Pages

Pet Adoption Software Homepage - Our homepage on sourceforge. All source code can be found here.

 

To Do List:

  • Add more functionality to admin site, espcially on pet details. Maybe we could add radio buttions or list boxes for certian pet categories to make it easier to post descriptions
  • figure out how we are going to include pictures on the site
  • figure out a way to delete descriptions automatically after a certain time period
  • create a more appealing administrator tool
  • when viewing users, enable the delete option, and/or maybe include an edit option (like muserver)
  • organize message board so that poeple can see messages even if they are not users
  • create a search, browse, or sort option that can be used only by registered users
 
   
   


Phase 1

Instructor Details

  • Working on applying previous assignment to our specific goal, a pet adoption site.
  • Working from list of things to do (Listed in assignment 6).
  • Have all functionality implimented.

Progress Report
Presentation
MS Project Layout

Project Pages*
Index page - Allows non-registered visitor to view pets, but allows them no more functionality. Refer to table at right for login information.
Login page
- This page allows all users to sign in and new users to register.
*Normally I list all the pages available for this site. However, for security purposes, most pages check for a valid session number and user type so you need to login to view the rest of the project pages.

Test createSessionView - This page test the create session view php file.
Test Common.php - This file tests the common.php file.
Test Functions.php - This file tests the functions.php file.

 

User Type User Name Password
Normal user mu mu
Administrator admin admin

Source Code*
addpet.php - Allows administrator to add pet, also has the code used for editing pets.
addpic.php
- Allows the administrator to add a picture to the pet description or edit the existing picture.
adduser.php - This file lets the administrator add a new user.
commonDB.php - Here are the database commands for this project.
createSessionView.php - This file gets specific user info.
Create Database
- This is the tables creation script.
Database_Entity-relationship Diagram - This is the tables ER.
delete.php - Confirms the deletion of a specified user from the view user page.
deletep.php - Confirms the deletion of a specified pet from the view pets page.
deletepet.php - Deletes the pet from the database
deleteuser.php - This file shows how the user is deleted.
editpet.php - Allows administrator to edit pet information.
edituser.php - Allows the administrator to edit user information.
emptylog.php - Allows the administrator to empty the log.
functions.php - Here are the functions used for this project.
login.php - Here is the login code.
main.php - This is the main program of the project.
options.php - Used by view pets and view users to sort and search.
p_p1.php - The index page containing pets.
testcommon.php - Here is the test code for testing the commonDB.php file.
testfunc.php - Here is the test code for testing the functions.php file.
viewlog.php - Allows the administrator to view and empy log.
viewpet.php - Allows users and administrators to view and/or edit pets in condensed format.
viewuser.php - Allows administrator to view, delete, and add new users.

Project Pages at Sourceforge
Pet Adoption Software Homepage - Our homepage on sourceforge. All source code can be found here.

*All pictures borrowed from the Santa Cruz SPCA site.


Final Project

Project Pages*
Index page - Allows non-registered users to view pets. Also allows all users to sign in. New users can register here also. This is the home page.
Help Page (General) - This is a help page for general users.
Test createSessionView - This page test the create session view php file.
Test Common.php - This file tests the common.php file.
Test Functions.php - This file tests the functions.php file.

User Type User Name Password
Normal user mu mu
Administrator admin admin

Source Code*
addpet.php - Allows administrator to add pet, also has the code used for editing pets.
addpic.php
- Allows the administrator to add a picture to the pet description or edit the existing picture.
adduser.php - This file lets the administrator add a new user.
commonDB.php - Here are the database commands for this project.
createSessionView.php - This file gets specific user info.
Create Database
- This is the tables creation script.
Database_Entity-relationship Diagram - This is the tables ER.
delete.php - Confirms the deletion of a specified user from the view user page.
deletep.php - Confirms the deletion of a specified pet from the view pets page.
deletepet.php - Deletes the pet from the database
deleteuser.php - This file shows how the user is deleted.
editpet.php - Allows administrator to edit pet information.
edituser.php - Allows the administrator to edit user information.
emptylog.php - Allows the administrator to empty the log.
functions.php - Here are the functions used for this project.
index.php - The home page that non-registered users use and where other users log in.
login.php - Here is the login code.
main.php - This is the main program of the project.
options.php - Used by view pets and view users to sort and search.
testcommon.php - Here is the test code for testing the commonDB.php file.
testfunc.php - Here is the test code for testing the functions.php file.
viewlog.php - Allows the administrator to view and empy log.
viewpet.php - Allows users and administrators to view and/or edit pets in condensed format.
viewuser.php - Allows administrator to view, delete, and add new users.

Project Pages at Sourceforge
Pet Adoption Software Homepage - Our homepage on sourceforge. All source code can be found here.

*All pictures borrowed from the Santa Cruz SPCA site.




 

Page last updated 4-07-02 By Pet Team