Project Detail

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

Look up text in a MySQL table & include it in webform is project number 305370
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: dleony

Budget: $30-250

Created: 08/25/2008 at 7:06 EDT

Bid Count: 22

Average Bid:
$ 65

09/01/2008 at 7:06 EDT

Project Creator: mpt
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (12 reviews)

Bid On This Project
 

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:
http://www.abc.com/?parameter1=value1
An existing php script on the webpage index.php 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.

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

200

3 days

08-25-2008 10:58 EDT

Can do all... Thanks

help

 

200

3 days

08-25-2008 07:39 EDT

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 expertise and experience in ecommerce site development, flash and animation. Our team can work on HTML,DHTML, JAVA SCRIPT, FLASH , ASP,ASP.NET,PHP,MY SQL, SQL Server, MS SQL. Our Bid includes development , deployment and testing. We are ready to start and send daily reports. we communicate through mail,messenger,phone and skype.We will a deliver a professional looking design(s) with proposed functionality to match your concept.

help

 

70

3 days

08-25-2008 18:55 EDT

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

help

 

45

1 day

08-25-2008 09:54 EDT

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

help

 

120

3 days

08-25-2008 23:11 EDT

Ready to work! Thanks!

help

 

50

3 days

08-25-2008 11:10 EDT

Please check PMB. Thank you.

help

 

100

3 days

08-26-2008 02:41 EDT

Please check PMB

help

 

30

1 day

08-25-2008 07:50 EDT

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 they seem simple, especially if you (eventually) provide information regarding the database structure. I'll send you some details over how I would approach these tasks by PM.

help

 

50

1 day

08-25-2008 20:36 EDT

Hi, please check PMB!

help

 

50

3 days

08-25-2008 09:38 EDT

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

help

 

80

4 days

08-25-2008 10:03 EDT

Hello, please check PM.

help

 

30

1 day

08-25-2008 09:59 EDT

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

help

 

35

2 days

08-25-2008 10:40 EDT

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 are using MySql database as your datastore. Allow me to bid successfully on your project

help

 

30

2 days

08-26-2008 12:14 EDT

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 simple to do.

help

 

50

2 days

08-25-2008 09:32 EDT

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

help

 

30

1 day

08-25-2008 08:55 EDT

(No Feedback Yet)

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 it? Well, that's PHP, if i explain it to you, then there is no point for you to choose me. Thank you, BC

help

 

30

1 day

08-25-2008 09:33 EDT

(No Feedback Yet)

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

help

 

30

2 days

08-25-2008 11:08 EDT

(No Feedback Yet)

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 saw 2) will alter the query to read the extra value and send that along 3 a+b) will create the db table and before/after the mail is sent will create the new record in that new table 4) after writing the tracking record, read the latest inserted ID from the tracking table and send that along with the email (requires tracking record insertion before email is sent, see above) 5)

help

 

50

3 days

08-26-2008 00:55 EDT

(No Feedback Yet)

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

help

 

75

5 days

08-26-2008 03:00 EDT

(No Feedback Yet)

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.

help

 

30

1 day

08-26-2008 05:41 EDT

(No Feedback Yet)

Please check PM

help

 

35

0 days

08-26-2008 13:12 EDT

(No Feedback Yet)

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). Please check PM.

help


    Bid on this Project