membership and text file submission

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
glennn3
Forum Commoner
Posts: 63
Joined: Sat Sep 20, 2003 8:43 pm

membership and text file submission

Post 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
Straterra
Forum Regular
Posts: 527
Joined: Mon Nov 24, 2003 8:46 am
Location: Indianapolis, Indiana
Contact:

Post 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.
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post 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.
Post Reply