Page 1 of 1

membership and text file submission

Posted: Wed Jan 14, 2004 6:07 pm
by glennn3
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

Posted: Thu Jan 15, 2004 12:31 pm
by Straterra
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.

Posted: Thu Jan 15, 2004 2:03 pm
by kettle_drum
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.