Project Opinions

[lanjoky]

Ok here are the specs on a project that I find interesting and really want to start:

**************************************************
Title: Doc Search (For lack of a better one at this point)

Propose: To allow users (mainly myself) to upload files such as .pdf's .doc's .txt's into a mysql database. Users of the system can then do an extensive search which will search through all the files (possibly using categories to limit the search... as well as other possible limiters) and will bring back the resulting documents with the specific sections that match as well as the full documents ....

Setup: php 4.3.2 MySQL 4.0.12

Database Input: .pdf .doc .txt .htm .html .asp .php files (other web formats)

Search input: category date (other limiters) and keywords to search for.

Search output: section of document result was found as well as a link to the entire document

**************************************************

What I would like from all of you all are answers to a few introductory questions that I have:

1. is the project possible (ie. Can I (through php) access the content of the above file types to be able to search for the search criteria)?

2. What concerns would you all have if trying to tackle the same project?

3. What things should I keep in mind as I go?

4. Any other Comments you may have!

Thanks in advance for all comments

[dv6cougar]

well how I would tackle this one personally, and I'm not 100% sure that this is possible with the files in the database but you can do this:

1. Create your database layout.

2. Devise a keywords section fo the database, where it will search for hte keywords upon a search query

3. when you make your script to insert the values, you can upload the files to the computer using a form (<input type=file>) and then enter that url into the database for searching it.


You could also enter the entire text portion in the database and just search this field, however, that's alot for it to have to search through. I would proabbly go with a keywords section, as you cannot input (or i dont' think you can) a pdf document file into mysql.

Text it is possible however.

Again, i would use keywords.

good luck :)

[lanjoky]

Thanks for the reply dv6cougar .... will take all that into consideration when I start this project ... Anyone else have any input for me?