We are implementing email newsletter signups on several sites.
These sites will send signup information to a script (you write for us) via form posts.
The script you write will pick parameter values off of the url and write to a mySQL database.
We are gathering more than just the email address. There are 4 tables with roughly 30 fields in total: Recipients, Subscriptions, Orders, InterestGroups. Only 3 fields are required. The main table is "Recipients". The other tables are 1:n with "Recipients".
A Database schema is attached. Parameter names are in the column named 'params'.
The second script is related to processing "Double Opt Ins". Double Opt in means that a person has to do 2 steps in order to subscribe. In addition to giving their email on the site, they must click on a link in an email that is sent to them in order to verify that address. The script for this will process those clicks and update the db to reflect the "double opt in" status of the recipient.
If I find a qualified programmer. I will start the project within 10 hours from now. I will supply necessary logins to a development php/mysql box. I need the project to be completed within 20 hours of the start.
I will need excellent communication from the programmer to discuss the project. I communicate via IM MS, AOL, Yahoo, Skype.
We are looking for a full time php/mySQL programmer and will be posting within the next month. Projects like these will help us identify top prospects.