We currently have a php page that lets users sign up for our site. The site itself is not live yet, so all that exists is this php page that is hooked up to insert new emails into our database. We are looking for a coder who can integrate a confirmation emailing system for us. The system should support the following functions: 1. Sends an email each time a new user signs up. 2. Creates email from a template file and replaces certain values in that file (for example, inserts the user's name in the greeting). 3. Properly sets the "from" information for all emails that get sent out. If interested, please explain how you would implement this and what specific technologies you intend to use. We currently use PHP, MySql, and Java. We are open to all suggestions.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
* * *This broadcast message was sent to all bidders on Monday Oct 15, 2007 4:45:55 PM:
Hi,
Here are the updated specs for this project.
We want to be able to handle a large load of users. There are two ways we are thinking to do this project:
1. When user signs up, write his name and email to mysql database; have a background process loop every 15 seconds and email names that have not been emailed yet; the email that gets sent needs to be generated from a template for which fields such as "FIRST_NAME" can be substituted with the signed up user's name. The database should be updated prior to sending the email (update signups set state = 'EMAILING' where email = ?) and after successfully sending the email (update signups set state = 'EMAILED' where email = ?).
2. An alternative is to have php write directly to a file instead of mysql. The emailing could be done from php or from a background process that occassionally checks the file and emails new addresses in the file. This process would also be responsible for updating the database with these names.
We are open to suggestions. It is up to you to decide how you want to implement this project. Please let us know your plan if you have not done so already.
Notes:
A. The emailing system should properly set both the "to" and "from" addresses. We will tell you which "from" address to use.
B. The system should be set up to ensure that emails are always sent exactly once to users. So even crashes and timing issues should not cause missed/duplicated emails.
C. Would be extra great if you can (a) record the time, IP address, and browser settings of signups in the database and (b) implement a good way to check for "bounced" emails and update the database accordingly. This way we can keep a more informative record of emails, IPs, and browsers.
Please respond with any questions/comments and updated bids if necessary.
Thanks, Andy
## Platform
linux