Find Jobs
Hire Freelancers

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

$30-250 USD

Selesai
Disiarkan lebih dari 15 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran
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: [login to view URL] An existing php script on the webpage [login to view URL] 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.
ID Projek: 305370

Tentang projek

20 cadangan
Projek jarak jauh
Aktif 16 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hi, please check PMB!
$50 USD dalam 1 hari
5.0 (7 ulasan)
4.5
4.5
20 pekerja bebas membida secara purata $65 USD untuk pekerjaan ini
Avatar Pengguna
Can do all... Thanks
$200 USD dalam 3 hari
4.9 (520 ulasan)
9.2
9.2
Avatar Pengguna
I'll be sending you a PM in just a moment.
$70 USD dalam 3 hari
4.8 (67 ulasan)
6.3
6.3
Avatar Pengguna
Ready to work! Thanks!
$120 USD dalam 3 hari
4.8 (106 ulasan)
6.6
6.6
Avatar Pengguna
I can help you and realize all 4 points. Thank you.
$45 USD dalam 1 hari
4.9 (22 ulasan)
4.6
4.6
Avatar Pengguna
Hi, I can do all of the request quickly for reasonable price. Best regards, -Ersan
$30 USD dalam 1 hari
4.9 (6 ulasan)
3.2
3.2
Avatar Pengguna
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.
$30 USD dalam 1 hari
5.0 (4 ulasan)
2.5
2.5
Avatar Pengguna
Please check PMB. Thank you.
$50 USD dalam 3 hari
5.0 (1 ulasan)
2.3
2.3
Avatar Pengguna
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
$35 USD dalam 2 hari
5.0 (1 ulasan)
1.3
1.3
Avatar Pengguna
Please check PMB
$100 USD dalam 3 hari
5.0 (1 ulasan)
1.4
1.4
Avatar Pengguna
I am an experienced PHP+MySQL coder... Try with me!
$50 USD dalam 2 hari
5.0 (2 ulasan)
1.0
1.0
Avatar Pengguna
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.
$30 USD dalam 2 hari
5.0 (1 ulasan)
1.0
1.0
Avatar Pengguna
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
$30 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I would be happy to put together this simple project. I am sending a PM with details of my bid.
$30 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
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)
$30 USD dalam 2 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I have sent you more information on the Message Board. Flavia
$50 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
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.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Please check PM
$30 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
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.
$35 USD dalam 0 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera GERMANY
Lindlar, Germany
5.0
15
Kaedah pembayaran disahkan
Ahli sejak Sep 21, 2006

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.