MySQL ODBC Connector - email to db

Author

email to db

Mark

2006-02-25, 9:44 am

------ =_NextPart_000_0005_
01C639F9.1A397190
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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
------ =_NextPart_000_0005_
01C639F9.1A397190--

Logan, David

2006-02-25, 9:44 am

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=20
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: david.logan@hp.com
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ****** =20
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia=20
i n v e n t =20
---------------------------------------------------------------

-----Original Message-----
From: Mark & #91;mailto:neretlis@
westnet.com.au]=20
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/mysql? unsub...sie.nctu.edu.tw

CodeHeads

2006-02-25, 9:44 am

--=- nVGLuHl5ji2LG6uxtiX4

Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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 D=
B 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.
>=20
> Mark

Wouldn't be easier using a PHP form, then send it to a database??

--=20
Best regards,
~WILL~
Key: http://code-heads.com/keys/ch1.asc=20
Key: http://code-heads.com/keys/ch2.asc=20
Linux Commands: http://code-heads.com/commands=20
Linux Registered User: 406084 (http://counter.li.org/)

--=- nVGLuHl5ji2LG6uxtiX4

Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.1 (GNU/Linux)

iD8DBQBD// Rofw3TK8jhZrsRAmdkAK
CNdTFFdPAO4x8gqPG9YY
lN3sfGrgCgszJ6
e4mm2Ti+2M4kwbXTbHre
NLA=
=6NZU
-----END PGP SIGNATURE-----

--=- nVGLuHl5ji2LG6uxtiX4
--

sheeri kritzer

2006-02-28, 8:28 pm

Mark,

Databases are not e-mail handlers, so the basic answer is no.=20
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 <neretlis@westnet.com.au> wrote:
> Can anyone tell me if it is possible to send an email from outlook to a D=
B 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/mysql? unsub...sie.nctu.edu.tw

Daniel da Veiga

2006-02-28, 8:28 pm

On 2/24/06, Mark <neretlis@westnet.com.au> wrote:
> Can anyone tell me if it is possible to send an email from outlook to a D=
B 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/mysql? unsub...sie.nctu.edu.tw

Sponsored Links