PHP Script to Filter and redirect IP addresses by Country, State and City

Cerrado Publicado hace 6 años Pagado a la entrega
Cerrado Pagado a la entrega

Hello,

I have purchased the latest Country+State+City IP database from IP2location and I would like to have a PHP script that works with MYSQL.

Here is how the servers I own work.

1) One dedicated server on CENTOS to host PHP files. (operating system already installed and working properly)

2) One dedicated server Database only to host MYSQL database (operating system already installed and working properly)

You will be able to access the database by uploading MYPHPADMIN to the server where PHP files are hosted to connect to the Database on the remote database server. You can connect to the database from the IP of that specific server only. Don't forget to disable the MYPHPDMIN file when you do not actively work on the script so hackers cannot use it.

For your information, your IP filtering PHP script will receive around 100,000+ hits/visitors daily.

Below are the features needed for the PHP script.

1) I need your script to redirect every IP address (visitor) based on its location IF a redirection URL is defined on your script for that specific location (It can be a STATE or City).

i.e. I have set up a custom redirect URL for Paris in your script. Then all IPS detected from Paris must be redirected by your script to that customer URL. Otherwise the script should not take any action.

2) I also need your script to report the stats of the traffic by country, state and city. The top 20 states and cities of every country should be reported.

3) You should schedule a CRON so the stats/logged IPs are DELETED every 7 days automatically to avoid a HUGE database and server overload within 1 month.

4) You should provide ADMIN control panel so I can see the stats (list of top countries, top states per country and top cities per country and per state).

I should be able to specify/enter the redirect URLS for COUNTRIES, STATES and/or Cities.

Your script should be efficient and work fast, I don't want it to use additional resources because of bad code.

Please let me know if you have any questions.

Thanks

Note: Please do not bid if you are not sure that you can provide 100% of the features listed on this project. I don't want to lose time with beginners or those that plan to provide partial work only. You should provide updates about the progress every 3 days to keep me updated if there is any progress or not by text chat message. I will not annoy you with phone calls.

MySQL PHP

Nº del proyecto: #14035453

Sobre el proyecto

53 propuestas Proyecto remoto Activo hace 6 años

53 freelancers están ofertando un promedio de $555 por este trabajo

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Más

$526 USD en 10 días
(253 comentarios)
8.8
webbookstudio

Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so Más

$530 USD en 11 días
(276 comentarios)
8.5
khantek

Hi, I am very much interested to do the job. I have 10 years of work experience in web design and website development with PHP/MYSQL. I have gone through your bid request in detail. The requirement is quite clear. Más

$750 USD en 10 días
(421 comentarios)
7.7
Shopify

Hello, It's a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work on customization part if we can proceed towards more discussion. I have gone through your project de Más

$515 USD en 10 días
(26 comentarios)
6.9
prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore Más

$515 USD en 10 días
(54 comentarios)
7.1
samitalways4u

Hello Sir, I Read Your Project Details and I want to say You That Its a Good project and in that Case We need to discuss About this Job. I got your idea and I can Do it. I have done Big level Project Before You can Che Más

$550 USD en 12 días
(111 comentarios)
7.4
tofeeqsl

Hi I am an experienced web developer and have vast experience on linux and apache as well as mysql I will setup php/mysq/apache on your website, it will quickly get ip and then route to location based url Thanks T Más

$666 USD en 10 días
(45 comentarios)
6.6
arityinfoway

Hello, Hope You are doing well. ARITY INFOWAY is complete web based solutions company. We able to provide web solutions from scratch to hosting . We always go through every point of your projects scope and prov Más

$584 USD en 10 días
(133 comentarios)
6.9
ShiaFirst

Hi, its pretty simple for me but I have few questions to ask, knock me for further discussion, PLEASE DON'T AWARD PROJECT BEFORE DISCUSSION. Thank You!

$400 USD en 10 días
(122 comentarios)
7.0
zoqraja

Hi, I can redirect customers based on the IP and record all the data and create charts and tables for analysis. The requirements are very clear and i'm upto the task.

$555 USD en 5 días
(71 comentarios)
6.6
Websitemaestro

Hello, I can definitely help you with your requirements. I am a full time developer working "8 hours a day" 40 hours per week. And ready to start this project from now. Looking forward to work with you. Waitin Más

$277 USD en 10 días
(75 comentarios)
6.4
coder786sl

Hi there, I have done IP/location based work in many online investment websites. And I will update you on everyday progress and also guarantees you that you will get everything get done you wrote in the project desc Más

$300 USD en 11 días
(39 comentarios)
6.2
Webln

Hello! my name is Viktor. We are IT Company «Webin». We provide website design and web and app development services for organizations, public and government institutions, company or private web-pages. We got acquainte Más

$451 USD en 11 días
(22 comentarios)
5.7
deepaulakh

Hi, I am Deep, a fully professional and an experienced web developer and Web designer. I provide Best work at affordable rates. I am proficient in following : PHP, Wordpress, Jommla, Magento, WooCommerce, Jquer Más

$555 USD en 10 días
(59 comentarios)
5.6
RubyOnRail

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further Más

$611 USD en 15 días
(16 comentarios)
5.9
bdphpguru

Dear Sir, Able to start right now. I have more than 2+ years experience in web and deskop application development using C#.Net , mysql,php. Twillio sms gateway api,paypal api several api like twitter, bitcoin. Más

$333 USD en 7 días
(94 comentarios)
5.3
ausprofreelancer

Hello I can help you with your project to develop the geo-aware scripting for redirecting visitors based on their IP geo-location. I do have over 16 years extensive experience with both PHP and MySQL and have deve Más

$750 USD en 14 días
(13 comentarios)
5.5
einfachsns

Einfach Hub is an India based web and app development company. Expertise, Skill and Proficiency are the tools we use to style the work of your investment in shortest period of time. We have experienced developers in Más

$666 USD en 20 días
(22 comentarios)
5.0
codemaster7

Hi, I've checked out all the features need by you and I can get it done writing it from scratch. I suggest to split this into sides: 1. The API that will provide info about the IP(so you can use it on multiple pl Más

$555 USD en 15 días
(38 comentarios)
5.2
DevoirTechsoft

We have done big and complex projects with quality and most of our business comes with repeat hires because of that, so looking forward to build a long term working relationship with you. Let’s have a chat session!!! W Más

$555 USD en 10 días
(20 comentarios)
4.3