|
Posted by Mike Willbanks on 10/21/05 03:57
Borf,
> I would like to create a client login form for an small advertising
> company.
>
> What I need it to do is this,
> 1. The client logs into the website.
> 2. The client would see his job images.
> 3. he then could aprove it or send a comment back to the designer.
>
> My question is,
>
> 1. Does anyone know of an existing project that can do this?
> 2. If I write it what would be the best way to present the client a
> page that only will show his job.
Unique user id would help... This is primarily for an example but would
work if you didn't want to create super users which I would recommend doing.
===========
| user |
===========
user_id int (PK)
user_username varchar(32)
user_password char(32)
==========
| file |
==========
file_id int (PK)
user_id int (FK) //user that created the file
file_name varchar(50) //basename
file_type varchar(15) //mime type
file_desc text
================
| user_to_file |
================
user_id (FK)
file_id (FK)
Now basically only use user_to_file for viewing/downloading permissions
and the user that created the file in the file table would have full
permissions. This is only a quick layout I would recommend going
further on it and adding more permission structures etc.
The reason the password is stored as char(32) is so you can encrypt it
with your own functions.
--
Mike Willbanks
Zend Certified Engineer
http://www.digitalstruct.com
Navigation:
[Reply to this message]
|