Forum Moderators: open

Message Too Old, No Replies

how to add record to mysql via email

         

sixeleven

12:22 pm on Aug 3, 2008 (gmt 0)

10+ Year Member



i want to add record to mysql ,by sending email,like blogger system.
i mean for example when someone send me an email ,his/her email information ,add to mysql.

i dont know what should i search on google ,to find this kind of script? or how should i write it by myself

LifeinAsia

4:16 pm on Aug 4, 2008 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



No idea how to do it with MySQL. But in general, if the e-mail is in a standardized format, theoretically you should be able to do it. What I would do:
1) Have a dedicated e-mail account htat is used for nothing else besides getting e-mail input.
2) Create an automated job to check the mailbox for new messages.
3) When a new message comes in, parse through the message and enter into the DB. You probably need PHP or some other scripting language to do this- not sure if any databases could do this directly.

sixeleven

3:10 pm on Aug 8, 2008 (gmt 0)

10+ Year Member



tanx :)