Global query
| From: | le_pit_est_un at nomade dot fr | Date: | Wed, 04 Apr 2001 02:05:57 +0000 |
| Subject: | Global query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8201@lists.php.net to get a copy of this message | ||
I am starting a new project, I dont have a lot of experience and before
running in the wall, I would appreciate to receive your comments :
I have 50 texts (presently in Word format) (one text per month for the past 4
years)
Each text is around 50KB (in .asc format)
These texts have more or less the same shape :
They consist of 10 or 12 chapters which have always the same title (Editorial,
Policy, Programming....,Conclusion)
This could be a template of my texts :
1. Editorial
blablabla.....
2. Policy
blablabla...
3. Programming
blablabla....
...
12. Conclucion
blablabla...
What I want to do :
People shall be able to search online these documents
Search may be done by keywords, date and category may be specified
e.g. : Search words china and sun,in chapter policy only, written after
March 1999.
The list of matching documents shall be display and people can view the
chapters.
To do that, I expect to build the following database :
-----------------------------------------------------------------------
Date of the document |chapter | text
-----------------------------------------------------------------------
1999-02-25 |editorial | blablablabla...........
| |...............................
| |............blbalbal
-----------------------------------------------------------------------
1999-02-25 |policy | blablablabla...........
| |...............................
| |............blbalbal
------------------------------------------------------------------------
What are my concerns :
Is a database done for this kind of thing ?
What is it better :
- to have the text of each chapter in the database (as above)
- to have one file for each chapter and only the adress of the file in the db
To display correctly the text, line breakdown should be kept. Is it possible to
keep them in the database ?
Thanks for your comments.
Pierre