Can i get text from email and put it in a database?

Discussion in 'PHP' started by TheSyndicate, Jan 7, 2006.

0
  1. #1
    I i have auktions that i manually put in my database Name of the person and auktions number and some other stuff. Its always the same email with the same content. Can i use a script that take out the info and put in a database for me automatic? This is not ebay so any of this that connect to ebay will work. This have to be from the email.

    If some one can do it or know how can you please give me a price as well?
     
    TheSyndicate, Jan 7, 2006 IP
  2. Foxy

    Foxy Chief Natural Foodie

    Messages:
    1,614
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I'm not sure what database you are referring to - I assume that it is one on your computer where you are taking info from an email generated by a form and manually transferring the info.

    If you have filemaker then you can bring the emails directly into FM and then parse the info with a script into the contact db.
     
    Foxy, Jan 7, 2006 IP
  3. TMan

    TMan Peon

    Messages:
    126
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Is the database a mysql database? And you want to copy/paste the e-mail to a script in you browser, which than puts it in the database?

    If that's the case, send me a PM with details and I'll state my price :)
     
    TMan, Jan 7, 2006 IP
  4. TheSyndicate

    TheSyndicate Prominent Member

    Messages:
    5,410
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    365
    #4
    i want some of the information i get in the email to go direct in to a database, that is msql.

    For example

    Name : Andre

    Auktions number : 111111111111

    Amount : 10 $
     
    TheSyndicate, Jan 7, 2006 IP
  5. cytech

    cytech Guest

    Messages:
    62
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yes you can do this, its not very easy though ;)

    You need to create a PHP script that will read POP3 email and then search the email for selected variables. Once grabbing the chosen variables it can store it into a MySQL db.
     
    cytech, Jan 7, 2006 IP
  6. TMan

    TMan Peon

    Messages:
    126
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #6
    If he wants the script to check the pop3 mailbox it's a lot more difficult, but still doable, than if he just wants to copy/paste every e-mail into a web form which does the work for him.

    Yellowberry, please PM me a description of the situation if you will.
     
    TMan, Jan 8, 2006 IP
  7. TheSyndicate

    TheSyndicate Prominent Member

    Messages:
    5,410
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    365
    #7
    Does any one know how much it will cost to do it ? Estimate? :confused:
     
    TheSyndicate, Jan 8, 2006 IP
  8. TMan

    TMan Peon

    Messages:
    126
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Dude, I've asked you twice to PM me.

    Anyway, if you want to have a script which shows a texterea in your browser in which you'll have to copy/paste the e-mail, which than puts the data in the DB, I'll do it for $ 50. That is, if the e-mail is always structured exactly the same of course, and is as you posted above.

    Just PM me.
     
    TMan, Jan 8, 2006 IP
  9. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #9
    T0PS3O, Jan 8, 2006 IP
  10. SiCK

    SiCK Peon

    Messages:
    452
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #10
    SiCK, Jan 10, 2006 IP