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

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.

Kemahiran: PHP

Lihat lagi: 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

Tentang Majikan:
( 15 ulasan ) Lindlar, Germany

ID Projek: #305370

Dianugerahkan kepada:


Hi, please check PMB!

$50 USD dalam sehari
(5 Ulasan)

22 pekerja bebas membida secara purata $65 untuk pekerjaan ini


Can do all... Thanks

$200 USD dalam 3 hari
(479 Ulasan)

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 Lagi

$200 USD dalam 3 hari
(211 Ulasan)

Ready to work! Thanks!

$120 USD dalam 3 hari
(84 Ulasan)

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

$70 USD dalam 3 hari
(34 Ulasan)

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

$45 USD dalam sehari
(22 Ulasan)

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

$50 USD dalam 3 hari
(4 Ulasan)

Hello, please check PM.

$80 USD dalam 4 hari
(5 Ulasan)

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

$30 USD dalam sehari
(6 Ulasan)

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 Lagi

$30 USD dalam sehari
(4 Ulasan)

Please check PMB. Thank you.

$50 USD dalam 3 hari
(1 Ulasan)

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 Lagi

$35 USD dalam 2 hari
(1 Ulasan)

Please check PMB

$100 USD dalam 3 hari
(1 Ulasan)

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 Lagi

$30 USD dalam 2 hari
(1 Ulasan)

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

$50 USD dalam 2 hari
(2 Ulasan)

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 Lagi

$30 USD dalam sehari
(0 Ulasan)

Please check PM

$30 USD dalam sehari
(0 Ulasan)

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 Lagi

$30 USD dalam 2 hari
(0 Ulasan)

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 dalam 5 hari
(0 Ulasan)

I have sent you more information on the Message Board. Flavia

$50 USD dalam 3 hari
(0 Ulasan)

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

$30 USD dalam sehari
(0 Ulasan)