Global query

From: 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 don’t 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

« previous php.db (#8201) next »