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

[Yellowberry.org]

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?

[Foxy]

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.

[TMan]

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 :)

[Yellowberry.org]

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 $

[cytech]

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.

[TMan]

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.

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.

[Yellowberry.org]

Does any one know how much it will cost to do it ? Estimate? :confused:

[TMan]

Does any one know how much it will cost to do it ? Estimate? :confused:

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.

[T0PS3O]

I need the same and it's far from easy. See here: http://forums.digitalpoint.com/showthread.php?t=46259

[SiCK]

It's pretty simple to do with the imap/pop3 extensions in PHP ... I would guess 20 lines of code?

http://www.php.net/manual/en/ref.imap.php