Posted by Chris on 06/18/15 11:54

I have a meetings section I'm developing on our intranet. Using PHP/MySQL.
Meeting info and Meeting docs reside on 2 related tables in the db. Users
may want to upload anywhere from 1 to 10 or more documents to share/use
during a meeting presentation. What would be the most efficient way to
approach this? This is the logic I'm currently considering:

Page 1: Meeting Information input with link to a document upload page (this
page already exists as a link for 'New Meeting')
Page 2: Document upload page -
1. should I pass the mysql_insert_id() from the meeting ID on the
previous page or
2. provide a select box that lists last inserted meeting on top as well
as other meetings?
I'm considering this because a manager may want to upload a doc for
a meeting that they posted in the db earlier, but never got around to
uploading docs.
However, perhaps this should be an entirely different page to
upload docs for already posted meetings?
3. should this page have several upload file inputs? If so, how many is
reasonable?
Page 3: Upload confirmation with a link ("add another doc for this meeting")
that reloads the page as a sticky form if not enough links

Another possibility is to have it all on one page, but I can see that this
could get messy. I'm still new to PHP/MySQL so I have a hard time following
code that is used in only one page, but revealing only the portion
applicable. (i.e. if(submitted){do this} else {do that}. Seems like
sometimes it wants to show everything anyway.

Just fishing for ideas here...

Thanks,
Chris

• Next in forum: Re: PEAR: is it really necessary?
• Prev in forum: Re: Use file() function to read a variable name, not a literal name.
• Thread view: uploading several docs at once

[Reply to this message]