Automate Email Verifier API for Database list of emails

Closed

Description

I am using an email address verification service that has an API interface to check emails

via "[url removed, login to view][secret_key]&email=[email]"

I want to run a PHP script once a month to verify the email addresses of all the members of my website.

Details of how I want the script to run are attached.

Simply, I expect to call a PHP script via CRON job.

The script will:

1. Send me an email to identify email verification has started,

2. Verify each email address in a specified table and store the response in a table (using the API call above).

3. When complete, generate a CSV list of entries where last month's response is different from this month's response (SQL query and export)

4. Perform some simple SQL queries to get summary counts of the results.

5. Send me an email to indicate the verification is complete and include the summary counts and CSV list.

The attached document included more details and identifies some points where I want to log some performance stats and debugging info in a DB table.

Skills: MySQL, PHP

See more: sql query to get list of database, debugging service, verify email, list of emails, email verifier, email i, email api, database performance , csv api, automate email, api interface using c, php script store email mysql, log api, send email using http, php script mysql export, job cron api, sql call api, month api, mysql export table sql, check table mysql script, script automate, query email, export mysql script, email address verification, query performance

Project ID: #4443894

Awarded to:

markokovacevic

Hi, I'm interested. Check your PM. Regards, Marko

$71 USD in 4 days
(9 Reviews)
4.6

7 freelancers are bidding on average $104 for this job

DrTech76

Hi! No problems programming this. Sending you some questions. Kind Regards

$88 USD in 1 day
(246 Reviews)
6.5
mantislin

Hi sir, please check pm.

$94 USD in 2 days
(123 Reviews)
6.4
linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below https://www.freelancer.com/projects/ More

$154 USD in 5 days
(74 Reviews)
5.9
solution4you

Hi ! I will be happy to develop this order system for you. I have a great experience as developer with PHP and MySQL. Also have a greate experience with many API. Thx !

$105 USD in 3 days
(98 Reviews)
5.8
lafor

Can be done; shouldn't take longer than a couple of days.

$105 USD in 3 days
(46 Reviews)
5.7
stdhtelkom

Hi, Ready to start. All the best, Steve.

$110 USD in 2 days
(15 Reviews)
5.6
rubarita

This job is a piece of cake for me. Could you please visit my profile to see the reviews?

$105 USD in 3 days
(7 Reviews)
3.3
BillyJo

I can do this project and start asap, please see my private message, Thanks!

$88 USD in 4 days
(0 Reviews)
2.7