In Progress

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());

Skills: PHP

See more: pop3 mysql, php pop3 mysql, mysql pop3, dboyzhang, php pop mysql, 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 pop3 html, pop3 mysql database, pop emails mysql, pop mysql, php pop3 mail mysql, pull emails php pop3, mysql pop3 insert, php pop3 senders, php pop3 naar mysql, violation, update mysql

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

Project ID: #245510

Awarded to:

dboyzhang

Hi,lets do it.

$45 USD in 1 day
(225 Reviews)
6.9