Document Library

[Dave White]

Hi All,

I need to create a simple document library - basic features to include
the users being able to select a category / sub-category and view a
list of files / descriptions that match the selection and then to be
able to download the files as necessary.

There would also need to be a simple admin function to allow the admin
to upload new files / descriptions. A seach function would be nice
but not essential.

I would like to do this with PHP / MySQL, but as a relative newbie I
need some help. I have tried to find some scripts on the net that
would be a starting point, but haven't been able to find any. Can
anyone point me in the right direction? I'm sure this is something
some one some where has done before!

Thanks in advance

Dave

[mikere]

Re: Document Library

Dave White <david.white@it a-group.co.nz> wrote in message
news:fd2de197.0 403081532.21956 1ba@posting.goo gle.com...[color=blue]
> Hi All,
>
> I need to create a simple document library - basic features to include
> the users being able to select a category / sub-category and view a
> list of files / descriptions that match the selection and then to be
> able to download the files as necessary.
>
> There would also need to be a simple admin function to allow the admin
> to upload new files / descriptions. A seach function would be nice
> but not essential.
>
> I would like to do this with PHP / MySQL, but as a relative newbie I
> need some help. I have tried to find some scripts on the net that
> would be a starting point, but haven't been able to find any. Can
> anyone point me in the right direction? I'm sure this is something
> some one some where has done before!
>
> Thanks in advance
>
> Dave[/color]

Ok, what you need to do here (at least from the sounds of it) are to create
a few elements to your site:

1. A file upload system. This is covered quite well in Chapter 18 of the
PHP manual.
2. A login system. I suggest using a combination of Sessions (XCV: Session
handling, also in the php manual), as well as a mysql database for storing
encrypted username/password combinations.
3. A database that stores the file names, uploaders ip address, username of
uploader, date of upload, and description of upload in mysql. You will
probably have to create a key word search for this with a dynamically
generated query.

I heartily suggest reading the relevent sections of the manual, and then
asking specific questions as you work through each section. The mysql
manual is also indespensible in the same fashoin. If it just sounds like
I'm giving you a long winded RTFM response, you would be correct, however,
I'm doing it with the best of intentions. I've pointed out the relevent
sections to focus on and by working through it a step at a time, you'll have
something you truly understnad when you are done. By the way, my first PHP
project was similar to this one (although I had experience in a number of
other languages and sql to begin with). Good luck and post any specific
questions as you get to thom :)

[Dave White]

Re: Document Library

> Ok, what you need to do here (at least from the sounds of it) are to create[color=blue]
> a few elements to your site:
>
> 1. A file upload system. This is covered quite well in Chapter 18 of the
> PHP manual.
> 2. A login system. I suggest using a combination of Sessions (XCV: Session
> handling, also in the php manual), as well as a mysql database for storing
> encrypted username/password combinations.
> 3. A database that stores the file names, uploaders ip address, username of
> uploader, date of upload, and description of upload in mysql. You will
> probably have to create a key word search for this with a dynamically
> generated query.
>
> I heartily suggest reading the relevent sections of the manual, and then
> asking specific questions as you work through each section. The mysql
> manual is also indespensible in the same fashoin. If it just sounds like
> I'm giving you a long winded RTFM response, you would be correct, however,
> I'm doing it with the best of intentions. I've pointed out the relevent
> sections to focus on and by working through it a step at a time, you'll have
> something you truly understnad when you are done. By the way, my first PHP
> project was similar to this one (although I had experience in a number of
> other languages and sql to begin with). Good luck and post any specific
> questions as you get to thom :)[/color]

Thanks for the advice. I have the user login system done and it works
well - it uses sessions as you suggest. I am reasonably confident
that I can get the upload system working. As you say there is lots of
coverage on how to do this on the various PHP sistes / books. The bit
that worries me is the database and the download section - Guess I'll
have to hit the books and experiment.

Thanks again

Dave.