Results 1 to 5 of 5

Thread: Database File Manager

  1. #1
    Junior Registered
    Join Date
    Oct 2003
    Posts
    3

    Database File Manager

    Hi everyone,

    This is my first post, and I'm hoping somebody out there will be able to help me. I'm setting up an intranet site for a small charity in the UK, and am having some difficulty deciding how to organise one element of the information.

    We have a digital archive containing thousands of articles, stored as PDFs. I'm trying to find a fast and efficient way of linking them all together to be browsed and searched within the database.

    What I'd like to be able to do is have either individual tables, or one large table containing links to each of the PDFs. Also contained in this table would be the article title, published date, source (newspaper title, etc.), filing reference (following a previously established numerical system), and a brief freetext summary of the article itself. It would be good to be able to sort by date, reference, source and title, but what I'd really like to be able to do is set up a way to click a link will filter the results via either source or filing reference.

    It's also important that the file itself is accessible - but probably not embedded within the database (it's easier for the indexing system I'm using to point to the directories).

    This will be hosted in-house, on a machine running Server 2003, IIS, MySql and Frontpage. PHP is also installed, though I suspect ASP may be a better solution.

    Anybody got any ideas? We can pay a small amount for a script, but we are a charity and therefore not massively wealthy.

    Any help would be greatly appreciated.

    Rapain.

  2. #2
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,048
    One large table containing links is the best way.

    ASP will be better if you must use a windows server.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

  3. #3
    Junior Registered
    Join Date
    Oct 2003
    Posts
    3
    I thought it must be. But the big question is... how do I go about either creating such a script, or are there systems out there which will automatically perform this sort of function?

    Rapain

  4. #4
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,048
    There actually are some scripts like that for php/mysql type situations.

    With a windows server and asp though, I can't think of one off hand. So you'll probably need to make it from scratch.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

  5. #5
    Junior Registered
    Join Date
    Oct 2003
    Posts
    3
    Which is unfortunately beyond my expertise.

    There is a free script called Accuflow which seems to do exactly what I want, but it won't run with MySql, only Sql 7.0 (which we can't afford) or MSDB (which doesn't seem to run with MySql installed at the same time).

    Rapain

Similar Threads

  1. Non-CPanel Database
    By iKwak in forum Web Hosting & Servers
    Replies: 1
    Last Post: 02-16-2004, 02:12 PM
  2. File Name VS Directory Name
    By Yasodaran in forum Search Engine Optimization
    Replies: 7
    Last Post: 02-14-2004, 04:43 PM
  3. Database Driven Websites
    By star in forum Website Programming & Databases
    Replies: 6
    Last Post: 10-21-2003, 03:51 PM
  4. Setting up a download file
    By Kevin in forum HTML, CSS, Layout, and Design
    Replies: 2
    Last Post: 08-12-2003, 10:44 PM
  5. database for articles
    By The Literary Thug in forum Website Programming & Databases
    Replies: 2
    Last Post: 07-28-2003, 01:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •