i need some advice on how roughly to create a membership database that also allows members to submit some written material (in rtf format) for editors to view and edit, and for members to access to see the status of their various submissions...
the submissions need to be in rtf per the client; not too awful large (no novels) but maybe several pages...
any suggestions, good people?
tx,
glenn
membership and text file submission
Moderator: General Moderators
-
Straterra
- Forum Regular
- Posts: 527
- Joined: Mon Nov 24, 2003 8:46 am
- Location: Indianapolis, Indiana
- Contact:
Well, what I would do is write an upload script for the text files. From there, I would store the file location, file name, author, date, and any other information you want associated with that file into a database. This will help with speed, as you wouldn't have to get the ENTIRE 3 page long document from the SQL Databse.
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England
Just split your task into sections and code them. Youll first need someway to say if a member is logged in - so youll need a database of usernames/passwords and then check what the user enters and try to match it with whats in the database. Then if they match - say the user is logged in - i.e. give them a cookie or a sesson.
Then make the upload script, make it only accessable is the user is logged in. Upload the file to a directory on the server and post some info to a database about the file/time submitted etc.
If you ever get lost or confused then just continue to split the task down, until your thinking in terms of ifs and else.
Then make the upload script, make it only accessable is the user is logged in. Upload the file to a directory on the server and post some info to a database about the file/time submitted etc.
If you ever get lost or confused then just continue to split the task down, until your thinking in terms of ifs and else.