CODEWITHSUNDEEP
mysqlapache
Todd Vance
Todd Vance

Reputation: 4711

Can I update a MySQL table via Email?

So I have a small area of my site that I update a lot. It sure would be nice if I could make it pull from MySQL table and just email that change in.

Anyone done something like this?

I'm using a hosted server running apache.

CLARIFY: I have a php page that currently gets people's high scores and displays them on the page. I have been watching the site and every now and then commenting on the scores (by changing the markup of the page).
I just thought that it would be great if I could setup a way to email the comments to my website and have the contents put into my db.

Then on my php side of things, I'll just put whatever is in TABLE-COMMENTS in the comments div.

Upvotes: 0

Views: 243

Answers (1)

Brian Glaz
Brian Glaz

Reputation: 15686

Yes, it is possible. You would need a server side script that can parse the emails from that address's inbox. Then you could set up a cron job to check the email box every hour or so.

Of course you should take extra precaution in validating the sender / specific format of these emails, so not just anyone can update your database. (I believe this is what @Marc B was commenting about)

Upvotes: 1

Related Questions