Simple MySQL/PHP app

We are a small college newspaper seeking a simple web-based application (PHP/MySQL) to keep track of our advertisers. FEATURES There are two types of users, supervisors and salesmen. A salesman should be able to: -Add advertisers to the database -View/edit/delete his own advertisers, including their name/contact info, and timestamped notes regarding them A supervisor should be able to: -Add/view/edit/delete any advertiser in the database DATABASE SCHEMA Advertisers table - include ID #, salesman ID #, company name, contact name, address, e-mail, phone number, fax Notes table - include ID #, advertiser ID #, date/timestamp, and note text AESTHETICS The design of the interface should be fairly simple. ADDENDUM After some consideration, I've decided that it doesn't make sense for this system to have its own username/password system. Instead, it will share the session management system with an existing application. This should be less work for the coder. I swear, this isn't as complicated as the following may make it seem. Here's how it works. When the user logs in, he's assigned a session ID, which is passed in the URL on all page requests, e.g. http://webserver/app/[login to view URL] Each page of the application calls authentication functions to (assuming the sessionid is valid) determine the userid associated with the sessionid, and then determine what type of user it is in order to find out what functionality should be available. For example, when the user accesses the list of advertisers, he should see only his own advertisers if he's a salesman, but he should see all of them if he's a supervisor. So you'd have something like: $sessionid = $HTTP_GET_VARS['sessionid']; $userid = get_userid_from_sessionid($sessionid); if ($userid == -1) //invalid sessionid { //print error and exit } if (user_type($userid)=="ad_supervisor") { //list all advertisers } else if (user_type($userid)=="ad_salesman") { //list only the salesman's advertisers }

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Monday Jan 10, 2005 10:50:47 AM:

Dear bidders,

I just wanted to inform you that I decided to change the description of this project a bit. I've decided that, rather than implementing a whole new session management system, that it should interface with an existing one. (Please take another look at the bid for details.) I believe that this should actually be less work for the coder. But nonetheless, please send me a message back and advise me as to whether you are still willing to do this project for the amount you originally bid.

Thanks

Martin

## Platform

Linux

Engineering MySQL PHP Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3507747

About the project