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 [url removed, login to view] 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, sending mails, sending email, sending bulk emails, send bulk message, mails, email sending job, bulk mark, bulk mail, bulk emails, sending volume email, write smtp server, php connect sql server, add opt, datetime, php server cron job, php connect database, activate gmail, php spam mail, bulk mail php, socket time server, sending bulk email job, sql small database, bulk email php script

About the Employer:
( 4 reviews ) 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 done.We can do this

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