Bulk sending of personalized e-mails from a database

Here's what happens:

I have script that generates thousands of personalised e-mails and temporarily stores them in a database. Every e-mail is different. Note: this is not spam, I'm sending opt-in personalised newsletters.

- Table: email_queue

- Fields: recipient (email varchar), subject, html_body, date_sent (datetime), status

The script should get the contents from the email_queue and send the e-mail one by one.


- Should use a smtp socket

- Should be able to send fast, possibly connect to the smtp once and send 1.000 emails at a time

- The e-mails must have the right headers, so they are not considered spam

- Mark a message as 'sent' (date_sent) when it's done

- Write the right status (1=delivered, 2=email does not exist, 3=mailbox full, etc)

- Must use MySQL and PHP only

I will add a cron job to activate the script and send relatively small amounts every ten minutes, so Hotmail / Gmail servers don't consider it spam because of the volume delivered from the same server.

Taidot: PHP, SQL

Näytä lisää:, mark job, mark fields, bulk e mail, sending mails, sending email, sending bulk emails, send bulk message, send bulk emails small job, n m e, mails, mail sending job, m&e, email sending job, e-mails, bulk mark, Bulk Mail, bulk emails, sending volume email, send bulk email php mysql, write smtp server, php connect sql server, add opt, datetime, php server cron job

Tietoa työnantajasta:
( 4 arvostelua ) IJsselstein, Netherlands

Projektin tunnus: #489011

Myönnetty käyttäjälle:


I can complete it today. you can use any smtp server (Gmail too if you like) for sending purpose.

50 $ USD 1 päivässä
(24 arvostelua)

11 freelanceria on tarjonnut keskimäärin 108 $ tähän työhön


We can help in your project, please check PMB to see our related experience.

250 $ USD 4 päivässä
(245 arvostelua)

HI, Please see PMB for details. Thanks

180 $ USD 3 päivässä
(45 arvostelua)

Hi, Please See PM.

40 $ USD 1 päivässä
(9 arvostelua)

with existing php email classes and functions and libraries, I will be able to this for you. I have been working on php projects for the last 3 years. I have worked on projects that deal with email sending from databas Lisää

200 $ USD 3 päivässä
(1 arvostelu)

I am a self-employed PHP developer with 3 years experience in PHP, MySQL, Htaccess, Javacript, Ajax, Smarty,HTML and CSS. I am confident I could do this for and would work round the clock to ensure it is done to deadli Lisää

100 $ USD 2 päivässä
(0 arvostelua)

If you are allowing me to do that with asp using SQL .... so i will do it in an hour .. cause i already have developed such application in ASP ... pm me if your mood change .. Thanks

50 $ USD 0 päivässä
(1 arvostelu)

Hi, I can do this. Let me know if you want me to do it. DC

75 $ USD 2 päivässä
(1 arvostelu)

I have written similar scripts many times and probably have most of the code already written. 3 days completion time is padded out a little to allow time to test. I can have this done quickly and am ready to start. i d Lisää

100 $ USD 3 päivässä
(0 arvostelua)

Hourly man hour=$8

40 $ USD 1 päivässä
(0 arvostelua)

Dear sir, We have an experienced programmers to get this job [url removed, login to view] can do this

100 $ USD 7 päivässä
(0 arvostelua)