Re: email to db
On 2/24/06, Mark <[EMAIL PROTECTED]> wrote: > Can anyone tell me if it is possible to send an email from outlook to a DB so > it updates a record. I have a php tipping script hosted with a mysql DB but > would like users to email their tips instead of loggin on the site. > > Mark > Well, no, DBs are not email handlers, unless you tell your MTA for example to handle the email and update the DB. I mean, you can do it, if you have access to your server and/or someone really likes you at your provider... :) Keep in mind that login and forms are secure compared to an email, how would it check its from one of your users? How could you be sure the content would be just text? Users screw things up, what if he sends you a whole book in the email, or an atachment? You would need a whole system to do that with no riscs... If you have dedicated hosting, you can do it, else, I doubt any ISP would allow it... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: email to db
Mark, Databases are not e-mail handlers, so the basic answer is no. However, it's possible to have the e-mail handlers update a database record -- I've seen it done with exim (but don't ask me how!) -Sheeri On 2/24/06, Mark <[EMAIL PROTECTED]> wrote: > Can anyone tell me if it is possible to send an email from outlook to a DB so > it updates a record. I have a php tipping script hosted with a mysql DB but > would like users to email their tips instead of loggin on the site. > > Mark > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: email to db
On Sat, 2006-02-25 at 10:49 +0800, Mark wrote: > Can anyone tell me if it is possible to send an email from outlook to a DB so > it updates a record. I have a php tipping script hosted with a mysql DB but > would like users to email their tips instead of loggin on the site. > > Mark Wouldn't be easier using a PHP form, then send it to a database?? -- Best regards, ~WILL~ Key: http://code-heads.com/keys/ch1.asc Key: http://code-heads.com/keys/ch2.asc Linux Commands: http://code-heads.com/commands Linux Registered User: 406084 (http://counter.li.org/) signature.asc Description: This is a digitally signed message part
RE: email to db
Hi Mark, You will need to setup a processing script on your mailer that will do that for you. Your ISP maybe able to set this up for you. Most mailers use the aliases file for that. A quick google found this as an example, yes it is talking to Oracle but the principles are exactly the same. http://philip.greenspun.com/doc/email-handler Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Mark [mailto:[EMAIL PROTECTED] Sent: Saturday, 25 February 2006 1:19 PM To: mysql@lists.mysql.com Subject: email to db Can anyone tell me if it is possible to send an email from outlook to a DB so it updates a record. I have a php tipping script hosted with a mysql DB but would like users to email their tips instead of loggin on the site. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
email to db
Can anyone tell me if it is possible to send an email from outlook to a DB so it updates a record. I have a php tipping script hosted with a mysql DB but would like users to email their tips instead of loggin on the site. Mark
