Filter and Add Pop E-mail into a mySQL Database Table

I need a custom script that will run via a cron job...

Please note that I have a mySQL database, accessible via PHP scripting, that supports multiple users. Each user must enter a username and password to log in. Once logged in, each user then has access to her/his own personal records. This is already set up and in place. Regarding the mySQL database, a simple table called "Messages" has been set up with the following fields: A Primary Key field, a Subject field, a Message field, and a Date field.

Next, I have a single POP e-mail account set up for the multiple users. I need a PHP script that will run regularly (via a cron job). I need the script to check the POP e-mail account regularly and filter/identify messages for each individual user and then add each user's e-mail message(s) directly into the Messages table of the mySQL database.

For example, suppose I have two users set up: Bob100 and Mike200. Bob100 and Mike200 each write an e-mail (from their personal e-mail accounts) and then send the messages to the multiple-user POP e-mail account on my server. On the first line of Bob100's e-mail he includes his user ID within double brackets: [[Bob100]]. On the first line of Mike200's e-mail he includes his user ID within double brackets: [[Mike200]].

Via the cron job, the script checks the multiple-user POP e-mail account and searches the body of each message for user IDs (within double brackets). In the examples above, messages containing [[Bob100]] and [[Mike200]] are found. These usernames are then parsed, and then the mySQL database is searched to see if the users exist. If so, then the Subject and Body of each applicable e-mail message is then parsed and inserted within the Messages table. Again, when logged on, each user will only be able to see her/his own messages.

Evner: MySQL, Perl, PHP

Se mere: write an e mail, simple pop server, scripting job, mysql database server, mail on line, log into, job mail, checks in the mail, e mail mail, write a simple php script, pop, parsed, my mail, mail access, filter, e-mail, e-mail database, e mail], mysql add fields, custom fields user filter, write simple php database, php brackets, mysql inserted, php log found, set mail php server

Om arbejdsgiveren:
( 5 bedømmelser ) Gulf Breeze, United States

Projekt ID: #934239

Tildelt til:


see pm please

$100 USD på 1 dag
(14 bedømmelser)

4 freelancere byder i gennemsnit $145 på dette job


I can deliver the PHP for pop email

$180 USD in 4 dage
(118 bedømmelser)

please see pm

$200 USD in 5 dage
(95 bedømmelser)

Hi, please check your PMB. Thanks!

$100 USD in 2 dage
(30 bedømmelser)