Write PHP script for redirect to MYSQL database entry based on IP address geolocation
€30-250 EUR
Dibayar saat pengiriman
I need a PHP script that takes the last world of an URL (e.g., "France" in [login to view URL]) and:
- identifies the location of the site visitor based on his IP address.
- looks up the keyword at the end of the URL and reads from a MySQL database the target URL for that keyword and country
- Redirects the visitor to the target URL that has been read from the database.
- If the country in question cannot be found in the database, redirect to the "fall-back" country for that keyword).
The database consists of a simple table "redirects" with three fields:
-keyword
-country
-targetURL
All three fields are text; country names will be the standard Internet country codes (i.e., "fr" for France, "de" for Germany, "uk" for United kingdom, "us" for United States). "--" will be the fall-back country in case a country code is not found.
Example of the table:
keyword country targetURL
gadgets -- [login to view URL]
gadgets fr [login to view URL]
gadgets it http://mygadgets/[login to view URL]
gadgets uk [login to view URL]
gadgets us [login to view URL]
Access to a test site with mySQL can be provided for the testing of the script if necessary. I will test it from at least two different countries.
ID Proyek: #6773742
Tentang proyek
Diberikan kepada:
Hello sir, I can write your script with the following features : - Lookup of origin country of request - Lookup of a redirect URL in database based on a keyword in the URL and the visitor's country - Redirect u Lebih banyak
26 freelancer rata-rata menawar €132 untuk pekerjaan ini
Hello! With 99% completion rate, 720 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u Lebih banyak
I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor Lebih banyak
Hello, I am ready to implement a script to redirect user based on IP. Can you please contact me to discuss the requirements of this project in more detail? My background: I am a professional web developer with mo Lebih banyak
----------------------------------------------------------Please Consider on My BID---------------------------------------------------Dear Sir/Madam, We are already read your project description & fully understand this Lebih banyak
Hi, I looked your posting and I am very much interested to work with you ...I am an India based software professional providing a range of IT services and solutions that address the technology needs of your company in Lebih banyak
Hello, can you provide access to test site. I have 3+ years of experience in php,mysql,codeigniter,wordpress,yii. I have expertise in database. And also I am a Oracle certified Associate.
Hello, I'm an experienced web designer and developper. Let me know if I can be of service. Podemos comunicar en castellano caso sea mas confortable.
Hello, I can create a script with described functionality for you. It will take a keyword from the url, resolve the country by IP, if possible, and redirect the user to the url, fetched from your MySQL DB. If intereste Lebih banyak
Hi, I would like to apply for this PHP project. Please contact me if you have any questions. Best wishes, Sasha
Hi I am developer PHP / MySQL / CSS / jQuery / HTML 5, 10 years experience, I have already made ip geolocation system, I would be very happy to do this for you, I am available for the nows do.
Hello sir, i can develop this redirect function for you. Please provide me with full specs and details. Waiting for your reply.I am ready to start. Many greetings from Bulgaria.
Hello Sir I am expert web developer,and I wish you give me this opportunity and I will do the best quality with the lowest price
Hello, I am a developer from IL (United States). I have a lot of experience in PHP and can make this script for you fairly quickly. Do you already have the MySQL database or do you need that created? If you need it Lebih banyak
Hi : ) I'm worked on 2 Redirect-By-GeoIP project before , so i can do it for you . Just want to notice you , you'll need GeoIP API external connection or upload GeoIP Database to your server - And there is many of t Lebih banyak
Hello I can do this I can show you a demo in next 24 hours if you want. .................... Best Regards Bill Lee
Hey, This is a very simple job if it is just as described in project description, We can easily get the IP address of visitor And then using IP we can find Country name Matching country name by code and getting UR Lebih banyak
I am an expert making PHP scripts for anything. Making this script for you will be fast and powerful. I am bronze medallist from the National Olympiad of Informatics of México which gives you very good reasons to hire Lebih banyak
