PHP and documents ?

[therob1]

having helped a friend with his website i also decided to help him with a simple intranet - again no problem there.

 

now the question he then asked was , is it possible to a 'system for me' and by that he went into detail as shown below;

 

1 - can i create a database of clients

2 - everytime they ask me to do work on them can i create a "file" for them as a client

3 - can each "file" contain a record / history of events

4 - can each item in the record/history relate to time spent & costs

5 - is it possible to link to a typed document - either in MS word, open office, etc, but to effectively pull through content, and by that i mean having a document and extracting/populating the database information of a client details (such as address) and for each "file" i can call the same document and it will pull through the relevant information stored for that person.

 

there were a few other points mentioned but i was under the impression points 1-4 are fairly straight forward to implement, it is point 5 that i am having most of my problems with. this is mainly as im still a php newbie and havent noticed any modules or any kind linking to documents before, i have also taken the assumption that php may not also be the best language to achive what i want to, but if that is the case im sure someone will be able to advise me otherwise? 

 

i eagerly await replies

 

thanks,

 

R.

 

[Philip]

If I'm understanding what you want correctly, yes.

 

Points 1-4 are easily achievable with a database. Point 5, you could always create a dynamic pdf file that has all the client info in it. If you want to use a .doc thats a bit more tricky - I think there are a few classes/extensions that can deal with .doc....