Look up text in a MySQL table & include it in webform
This project was awarded to dleony for $50 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
This is a small project through which I seek to find an easy way to track visitors of a website. In the future it might lead to similar projects of larger scale.
Below I will explain all the details so that you can easily judge whether you can/want to do this, and so that you can start working on it immediately after your bid has been accepted. Before you place a bid please read the instructions and only ask specific questions.
Visitors of the website arrive with a parameter in the URL:
[url removed, login to view]
An existing php script on the webpage [url removed, login to view] takes value1 from the URL and looks up a custom greeting message text1 (for the entry value1) in a MySQL table greeting_table1. It includes text1 in the webpage (where I put the placeholder <?php echo $text1;?>). The visitor of the website sees the regular webpage content including the greeting message text1 for his value1. Later, after looking at the webpage, some visitors of the website fill out a simple sendform with their name etc. and send it to me by clicking "send".
Request 1 (main task, this one is sufficient):
I want the email which I receive from the sendform to include text1 from greeting_table1, so that I know which greeting message the customer had seen.
Request 2 (optional):
The script from Request 1 should not only look up text1 in greeting_table1 but also a second variable text2 from the same database line, and include text2 along with text1 in the email which I receive from sendform.
Request 3a (optional):
When the visitor arrives with the parameter1=value1 in the URL, I want the php script to insert value1 into a separate MySQL table tracking_table1 (along with a time/date stamp), so that I can later see how many visitors arrived with which value.
Request 3b (optional):
Not only value1 should be inserted into the MySQL table but also the complete referrer so that I can track where the customer came from.
Request 3c (optional):
If a visitor arrives with multiple parameters in the URL (instead of just parameter1), I want all parameter/value pairs (such as parameter2=value3) to be save in the MySQL table. This is the same as Request 2a, except that the solution supports multiple parameters.
Request 4 (very optional):
When parameter1 and value1 are inserted into tracking_table1 (from request 2a), a simple ID (counter) is added to that entry. Later when the visitor send the information in the webform, not only text1 from greeting_table1 is included in the email to me (request 1), but also his ID value from tracking_table1.
Request 1 has priority and I am looking for a solution which can be realized with a low budget at this point. 2, 3 and especially 4 are optional and not required, please explain which of these options are included in your offer. The project must be finished within 3 days.
Important: If you are seriously interested in this project please describe briefly how you want to realize it. This allows me to understand how serious your offer is. I am not interested in bids with just a short comment like "This is easy. Let's do it." Because then I have no way to understand if you can realize it as described.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online