Ask questions via twitter! Message any question to @answers on twitter. We'll publish the question and send you a reply each time there's a new answer.
Next Question

Answered Question

 
M$1.00  Funded By Mahalo ? |  April 17, 2009 01:33 PM

How to forward gmail message to MySQL database?

I want to forward my incoming message from gmail to MySQL db in the hosting server. Is there any way using python? I found a link using python and MySQLdb module(http://danfolkes.com/index.php/2009/01/22/python-grab-email-from-gmail-and-insert-into-mysql-database/), but this doesn't work.
Interesting Question?  Yes (0)   No (0)   
RSS
 
 

Best Answer  Decided by Votes

 
April 17, 2009 02:23 PM
I'd personally use a PHP script running as a Cron script on your server, set to run every 5 minutes or however often is needed.

There is an IMAP extension for PHP that will allow you to grab email from your inbox (reference: http://uk2.php.net/manual/en/ref.imap.php), and then you can use standard MySQL connections (http://uk2.php.net/mysql) to insert the gathered information into your database

There is a tutorial on PHP and IMAP available here: http://www.tutorialized.com/view/tutorial/IMAP-Mail-Reading-With-PHP3/649 and I'm sure you'll be able to find loads more by Googling around.


Helpful Answer?  (0)   (0)    Tip warlrus for this answer
Permalink | Report
Voted as best: thekid, jellylala, lesliec, masontx
   Reply  
 
 

Answer this Question

How tips and payments work

This question has already been resolved. You may add an answer to it but you will not be eligible to win best answer or any associated tips.

Ask a Question


140 characters left
Top of Page
Buy Mahalo Dollars with Credit Card or PayPal

Top Members

This Week All Time
  • cfinke
    cfinke
    2nd Degree Black Belt
    26761 Points
    M$29.75 Earned
  • bunnyphuph...
    bunnyphuph...
    2nd Degree Black Belt
    20771 Points
    M$756.54 Earned
  • thisjustme
    thisjustme
    Green Belt
    1145 Points
    M$76.05 Earned
   See All
 

Most Popular Tags

mahalo(1764)
music(493)
iphone(481)
google(382)
online(346)
food(336)
beer(284)
money(281)
movies(277)
apple(257)
aotd(235)
health(227)
free(224)
video(221)
dog(211)
   See All
 

Categories

Welcome New Members


 
 
Mahalo Dollars are the currency of Mahalo Answers.

Each Mahalo Dollar costs $1.

Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More

 
 

Please log in to use this function.