POP3 to mysql with php for dboyzhang

This is intended for dboyzhang because I know he did this, which is going to be 90% of what I need. This is my first job, so I hope refencing this job is not a violation.

[url removed, login to view]

I need it to

1. check a pop3 account.

2. Pull the email

3. Look for [TicketID:xxxxxxxx]

4. Look for sender's email.

5. insert the TicketID, sender email, message body, into the database.

6. Delete email.

7. Loop until mailbox is empty.

It's going to run as a cron job, so don't output html.

I'm going to be tweaking this when it's done, so it should be readable ;)

This is the code (adodb) I'm using for database inserts. You don't need to worry about doing the insert, I will do that. Just make it generate the SQL statement.

$UpdateSQL = "UPDATE invoices_inv set status_inv = 'paid', pid_pmt=$paymentid_acc, amt_paid_inv = $amt_req_inv where id_inv = $id_inv";

$connShop->Execute($UpdateSQL) or die($connShop->ErrorMsg());

scratch all the database stuff, I'll do that...
Just give me an array with everything about the email.
ticket id

Skills: PHP

See more: pop3 mysql, php pop3 mysql, mysql pop3, dboyzhang, php pop mysql, what i will do for $5, look for job, https www getafreelancer com, php pop3 insert, php pop3 mysql database, php check pop3 mysql, delete email pop3 php, inser pop3 mail mysql, pop3 insert mysql, php pop3 database, email mysql php pop3, pop3 mysql script, php mysql insert pop mail, php pop3 html, pop3 mysql database, pop emails mysql, pop mysql, php pop3 mail mysql, pull emails php pop3, mysql pop3 insert

About the Employer:
( 3 reviews ) Mobile, United States

Project ID: #245510

Awarded to:


Hi,lets do it.

$45 USD in 1 day
(225 Reviews)