Look up text in a MySQL table & include it in webform

Closed

Description

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.

Current situation:

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.

Skills: PHP

See more: www seek com, www seek c, www seek, working for seek, value options, text easy, table customer, seek one, seek it, seek information, seek i, seek com a, seek. com, seek com, seek and see, seek a, priority one, one seek, offer up, Mysql questions, mysql customer database, look php id, it seek, i seek com, i seek

Project ID: #305370

Awarded to:

dleony

Hi, please check PMB!

$50 USD in 1 day
(5 Reviews)
4.0

22 freelancers are bidding on average $65 for this job

lightcresent

Can do all... Thanks

$200 USD in 3 days
(479 Reviews)
9.0
VALUEONWEB

VALUEONWEB is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. We have experti More

$200 USD in 3 days
(211 Reviews)
7.9
khanhhuyna

Ready to work! Thanks!

$120 USD in 3 days
(84 Reviews)
6.6
keithn

I'll be sending you a PM in just a moment.

$70 USD in 3 days
(34 Reviews)
5.5
zhukaster

I can help you and realize all 4 points. Thank you.

$45 USD in 1 day
(22 Reviews)
4.6
hammerWSB

Hello, i'm ready to start. Read my PM on how i'll do the tasks, my price is for all tasks.

$50 USD in 3 days
(4 Reviews)
4.2
showboytridin

Hello, please check PM.

$80 USD in 4 days
(5 Reviews)
3.9
ErsanJSano

Hi, I can do all of the request quickly for reasonable price. Best regards, -Ersan

$30 USD in 1 day
(6 Reviews)
3.2
AndrewRadev

Thank you for the detailed explanation :). This bid is for tasks #1 and #2 since you mentioned being on a budget. However, if you'd like, I could do all the tasks for an extra $15 and a day more (just in case). Overall More

$30 USD in 1 day
(4 Reviews)
2.5
VisionsUnleashed

Please check PMB. Thank you.

$50 USD in 3 days
(1 Review)
2.3
yousafasad

Dear Buyer I have done numerous projects in Php for clients on Elance and Odesk. I can get you the Request #1 completed before the day is over and the remaining request within an additional day. I am presuming you a More

$35 USD in 2 days
(1 Review)
1.5
fekke

Please check PMB

$100 USD in 3 days
(1 Review)
1.4
crisalin

I am an experienced PHP+MySQL coder... Try with me!

$50 USD in 2 days
(2 Reviews)
1.0
jaxdevil

Simple to do. I can do it this evening if you pick me before then, if not I can do it tomorrow evening. Will not take long, all of the things you listed, not just the non-optional things, everything you put on there is More

$30 USD in 2 days
(1 Review)
1.0
mpekv

Please check PM

$30 USD in 1 day
(0 Reviews)
0.0
Sukhmandeep2006

Hi, I understand the project and it is not very difficult to do it. I will do Request1(pretty sure about what you are asking for), Request2a (need a little bit more explanation), Request 3a, 3c & 4 (can do it too). Ple More

$35 USD in 0 days
(0 Reviews)
0.0
thrca

I would be excited to work on and complete all of your requested options. Please feel free to contact me if you would like some examples of my work.

$75 USD in 5 days
(0 Reviews)
0.0
littleendian

I will do all mentioned requests for 30 USD in one, maximum two days, since I am working on getting some good ratings :) 1) will be done with an extra hidden field in the form containing the greeting-text the user s More

$30 USD in 2 days
(0 Reviews)
0.0
SWTectonics

I would be happy to put together this simple project. I am sending a PM with details of my bid.

$30 USD in 1 day
(0 Reviews)
0.0
ctln88

Hello, All your 4 request can be done. But for my bid of $30 i include only Requests 1 2 and 3a. The time for doing it is 1 day, maximum 2 days. Other 3 requests can take about 2 additional days (all). How will I do More

$30 USD in 1 day
(0 Reviews)
0.0