PDA

View Full Version : Email generation on event and print a record


brettpower
02-28-2007, 08:45 PM
I am nearing completion of a service request tracking system for my companies IT and Maintenance Departments. I need to add the following, but I am not sure how. Any help would be appreciated.

1. I need for an Email to be automatically dispatched when a record/row is updated.

2. I need a way to allow viewers to download a PDF of the row that was updated.

3. A way for people to respond via Email and have the database row/records updated.

davidj
02-28-2007, 09:42 PM
what scripting language are you using?

brettpower
02-28-2007, 09:48 PM
Everything is PHP/mySQL, however, I am always up to learning and incorporating new languages!

davidj
02-28-2007, 10:37 PM
you said the right magic word ... > PHP

ok lets examine your requirements

1. I need for an Email to be automatically dispatched when a record/row is updated.


thats an easy one. Just use the mail() function straight after your update script.

we can cover this together although there is a great tut on the front page which covers this

2. I need a way to allow viewers to download a PDF of the row that was updated.


as you are updating you will know the record id so we could use the same id in a select and generate a link from that record (you would hold the path and pdf name in a db field)

3. A way for people to respond via Email and have the database row/records updated.

just adapt point 1 above to suit your needs