Write PHP script for redirect to MYSQL database entry based on IP address geolocation
€30-250 EUR
ชำระเงินเมื่อจัดส่ง
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.
หมายเลขโปรเจค: #6773742
เกี่ยวกับโปรเจกต์
freelancer 26 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ €132
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 เพิ่มเติม
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 เพิ่มเติม
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 เพิ่มเติม
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 เพิ่มเติม
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.
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 เพิ่มเติม
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 เพิ่มเติม
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 เพิ่มเติม