Quick StartMost PopularNew StuffPeopleTagsAbout Us

Parsing email to MySQL

Rate this:
By pauen (Contact - View My Woyano)
Published Wed 21 Feb 2007, 1379 Views, 2 Comments

I'm looking for an easy way to parse an email message to dump the data into a MySQL database.

Background: I receive email messages from FedEx when a package is shipped or delivered. I have been entering the tracking numbers manually into a web-based application. If I could parse out the date, invoice number, and tracking number, then upload to the db, it would save me a ton of time every day.

Any thoughts?


This Item
Category: Knowledge, Questions, General
Tags: MySQL, email
Share it
Link to this item:
Bookmark this item: RSS Feed

People who liked this item

    2 Comments

  1.  
    JV ~ 15 months ago
    1 vote thumbs up thumbs down
    I found two useful links on this subject:

    MIME E-mail message parser
    http://www.phpclasses.org/browse/package/3169.html

    Parsing Mail with PHP
    http://www.derickrethans.nl/parsing_mail_with_php.php

    Hope it helps!
    [ reply ]
    1.  
      pauen ~ 15 months ago
      0 votes thumbs up thumbs down
      Thanks JV ... This should keep me busy.
      [ reply ]
    2.  
      AdGuy
      22 votes thumbs up thumbs down
      This is my two cents...

         
      Hey you know AdGuy always gets the last word! ;)

    Please Login to Add Your Comment   ..or..  

    Replying to comment by