Suggestion Required: php application architecture

Question

My web application(http://www.tyro.in) lets users share their Documents like Ms word and pdf openly. Users can search and download the documents uploaded by other users. Currently app use the following technique

When user uploads any file:

It extracts text from document and stores in database. It stores file name as title of that DB record.

When user search for a file:

It matches the query with the stored data present in the Database and shows the results for download

current implemented technique in graphically given at http://www.tyro.in/Tyro.png

Any one suggest me the advancement of my current method

score 1 · Answer 1 · answered Dec 30 '10 at 14:56

1

Try this:

http://dev.mysql.com/doc/refman/5.1/en/fulltext-search.html

But I never had time to try.

answered Dec 30 '10 at 14:56

Philipp Spiess

3,263
4
26
34

1

this answer might interest you then http://stackoverflow.com/questions/3338889/3339034#3339034 – Yanick Rochon Dec 30 '10 at 15:08

score 0 · Answer 2 · answered Dec 30 '10 at 15:01

0

I'd recommend a short preview of file upon search, to avoid unnecessary downloads - will gain both users and your bandwidth.

regards, /t

answered Dec 30 '10 at 15:01

Teson

6,644
8
46
69

score 0 · Accepted Answer · answered Jan 17 '11 at 02:18

suggestions for searching info:

use full text search in the name and description fields
categorize the documents (by file type, user, info, size)
add info about popular searchs and most downloaded documents
let users rank documents so they can be easily found
let users share documents (via email, social networks)

if i have more ideas, i'll let you know

Suggestion Required: php application architecture

3 Answers3