LAMP Programmer Guru Needed (Steady Work Opp for Right Person)

Closed Posted Jul 28, 2009 Paid on delivery
Closed Paid on delivery

Dear LAMP Programming Guru, I’ll state upfront that this a fairly straightforward project because the right person (someone who oozes positivity, crunches on code for breakfast??"and lunch and dinner, and likes to connect to chat over the details to make sure of them before pushing forward) will be given more and more work over time until this becomes a full-time gig filled with all the variety of projects we’ve got. That way you won’t have to keep going searching for other jobs to pay the bills. --> See full description BELOW....

## Deliverables

Dear LAMP Programming Guru, I'm a Project Manager for a business training company that delivers in-person workshops, so this project is focused on processing email confirmations into our database. ***What’s in it for you?*** Good question! :-) I’ll state upfront that this a fairly straightforward project because the right person (someone who oozes positivity, crunches on code for breakfast??"and lunch and dinner, and likes to connect to chat over the details to make sure of them before pushing forward) will be given more and more work over time until this becomes a full-time gig filled with all the variety of projects we’ve got. That way you won’t have to keep going searching for other jobs to pay the bills. Sound good? Great! So let’s first focus on this project at hand to update our main database with the incoming workshop confirmations. ***The Flow*** * We send out workshop confirmation request emails to everyone marked as Registered for a given workshop. * Each registrant receiving one of those emails can click a link in it to confirm his/her attendance. * That link points to a PHP script on our website that takes some information about the registrant as query parameters. * The script will log that registrant’s info to a MySQL database sitting on the site server. It will also send a notification email to us. * A separate PHP script, running on a Windows server elsewhere, will periodically poll that MySQL database to see if any new workshop confirmations have come in. * All new confirmations will be marked, by the same PHP script, in an MS Access 97 database (our main company database) on the Windows server. * The confirmations stored on the MySQL side will need to be marked as well to indicate that they’ve been processed. That’s it in a nutshell. Pretty simple, right? And to make it even simpler, I’ve actually already written most of the PHP script that processes the link click from the email, but right now it only sends the info as a notification email for one of our staff members to manually process in. This is a working system as is. ***Your Mission Is to…*** * Create the MySQL database table to log the confirmations and write into it. * Add to the existing PHP script to write the registrant’s confirmation details into it. * Write the Windows-based PHP script to poll the MySQL database for new confirmations and write them into our MS Access 97 database, which has a single status field to change in the Attendance table. * Schedule the PHP polling script to run using Windows Task Scheduler in the Control Panel. ***Timeline*** This project may only take a handful to several hours, though there’s no definitive date by which it has to be done. But it’ll be great, and look good for you, if we can get it done within 3 days total, including validation. ***Communication Guidelines*** * You must have a reliable internet connection so we can stay connected and be willing to give me a phone # where I can contact you if your Internet goes down. * You must have excellent spoken and written English. (the vast majority of it will be writing, in emails, Skype, etc.) * Willing to text chat on Skype as the main form of contact. ***Other Notes*** * For this project, you will NOT be given access to any of our servers for testing, for security reasons. So you will need to run everything on your own systems and demonstrate that it all works before I will test them on our servers. But that just involves a standard Windows box and a simple shared host for the Web-based PHP script and MySQL server. I will give you a version of our database with test data. * Please only bid if you are a specialist in PHP, MySQL, writing complex SQL queries, and ideally adept at Linux admin too, since that’s something we’ll require in the future. Describing and demoing examples of your work would be appreciated. * Please bid the discounted hourly rate you would as if you were going to work full-time with me??"because that’s the end goal here a bit down the road. Make sure to state that that hourly rate is, so that I know how many hours you are estimating for this project. * Bidders in the Philippines are preferred, but not required. * If you’ve got a whole team of programmers, so much the better. I’d appreciate working with a team to separate task load over time, but your bid will have to be very competitive with the individuals. * Legal mishmash: 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). ***Required Questions to Answer In Your Bid*** * What have you used in the past to do MySQL database connection pooling with PHP? Describe one or two of the projects in which you used it and what specific performance difference it made. * What’s the easiest way to emulate the “synchronize?? keyword in Java that, when prepended to a function (“method,?? as functions are called in Java) only allows a single thread to gain access to that function at a time? * Does PHP have anything to match the “finally?? block in the try/catch/finally block sequence in Java? This block is meant to execute a certain piece of code regardless of whether an exception was thrown or not. * What clarification questions do you have for me on the project itself? Intelligent questions here will show me that you care and are thinking in the right direction. Thank you for your time and energy. I very much appreciate both, and I look forward to receiving your bid!

## Platform

The confirmations processing script + MySQL are on Linux. And the other stuff is on Windows.

Engineering Microsoft Access MySQL PHP Project Management Software Architecture Software Testing

Project ID: #2816016

About the project

2 proposals Remote project Active Aug 19, 2009

2 freelancers are bidding on average $96 for this job

behendrawan

See private message.

$127.5 USD in 14 days
(24 Reviews)
4.3
ronitoberoy87

See private message.

$63.75 USD in 14 days
(5 Reviews)
2.6