{"id":27906,"date":"2021-05-14T14:55:00","date_gmt":"2021-05-14T11:55:00","guid":{"rendered":"https:\/\/themewp.inform.click\/?p=27906"},"modified":"2021-10-17T04:58:00","modified_gmt":"2021-10-17T01:58:00","slug":"implementering-av-ip-geolokalisering-med-gratis-ip2location-lite-och-php","status":"publish","type":"post","link":"https:\/\/themewp.inform.click\/sv\/implementering-av-ip-geolokalisering-med-gratis-ip2location-lite-och-php\/","title":{"rendered":"Implementering av IP-geolokalisering med gratis IP2Location LITE och PHP"},"content":{"rendered":"

Bes\u00f6k alla webbplatser och du kommer sannolikt att hitta n\u00e5gon form av lokalisering som anv\u00e4nds. Det vanligaste \u00e4r att visa annonser som \u00e4r lokala f\u00f6r dig \u00e4ven om webbplatsen kan vara utl\u00e4ndsk. Med hj\u00e4lp av webbbes\u00f6karens IP-adress kan webbplatsoperat\u00f6ren rikta in sig p\u00e5 relevanta annonser, inneh\u00e5ll eller \u00e4ndra webbplatsens spr\u00e5k baserat p\u00e5 ditt geolokaliseringsland.<\/p>\n

Vi kommer att unders\u00f6ka hur du implementerar denna geolokaliseringsfunktion p\u00e5 din egen webbplats med hj\u00e4lp av PHP. Del 1 handlar om att skapa databasen och tabellen samt importera data. Del 2 visar hur man anv\u00e4nder PHP f\u00f6r att fr\u00e5ga databasen och h\u00e4mta resultaten.<\/p>\n

Del 1: Importera geolokaliseringsdata<\/h3>\n

L\u00e5t oss anta att din webbplats k\u00f6r en Apache-webbserver med PHP som driver backend. Vi antar att du anv\u00e4nder MySQL eftersom PHP vanligtvis fungerar med MySQL.<\/p>\n

Det f\u00f6rsta steget \u00e4r att ladda ner DB11 LITE-databasfilen fr\u00e5n <\/a>https:\/\/lite.ip2location.com\/database\/ip-country-region-city-latitude-longitude-zipcode-timezone<\/a> som \u00e4r gratis efter registrering.<\/p>\n

N\u00e4r du har laddat ner den zippade filen extraherar du IP2LOCATION-LITE-DB11.CSV-datafilen till en mapp som heter \/root\/ip2location_data<\/code>(detta \u00e4r bara ett exempel p\u00e5 mappnamn).<\/p>\n

K\u00f6r f\u00f6ljande i din MySQL f\u00f6r att skapa databasen och tabellen d\u00e4r vi lagrar DB11-data.<\/p>\n

CREATE DATABASE ip2location;\nUSE ip2location;\nCREATE TABLE `ip2location_db11`(\n\u00a0\u00a0\u00a0\u00a0`ip_from` INT(10) UNSIGNED,\n\u00a0\u00a0\u00a0\u00a0`ip_to` INT(10) UNSIGNED,\n\u00a0\u00a0\u00a0\u00a0`country_code` CHAR(2),\n\u00a0\u00a0\u00a0\u00a0`country_name` VARCHAR(64),\n\u00a0\u00a0\u00a0\u00a0`region_name` VARCHAR(128),\n\u00a0\u00a0\u00a0\u00a0`city_name` VARCHAR(128),\n\u00a0\u00a0\u00a0\u00a0`latitude` DOUBLE,\n\u00a0\u00a0\u00a0\u00a0`longitude` DOUBLE,\n\u00a0\u00a0\u00a0\u00a0`zip_code` VARCHAR(30),\n\u00a0\u00a0\u00a0\u00a0`time_zone` VARCHAR(8),\n\u00a0\u00a0\u00a0\u00a0INDEX `idx_ip_to` (`ip_to`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;<\/code><\/pre>\n
K\u00f6r nu f\u00f6ljande i MySQL f\u00f6r att importera data.<\/p>\n
LOAD DATA LOCAL\n\u00a0\u00a0\u00a0\u00a0INFILE '\/root\/ip2location_data\/IP2LOCATION-LITE-DB11.CSV'\nINTO TABLE\n\u00a0\u00a0\u00a0\u00a0`ip2location_db11`\nFIELDS TERMINATED BY ','\nENCLOSED BY '\"'\nLINES TERMINATED BY 'rn'\nIGNORE 0 LINES;<\/code><\/pre>\n
Del 2: Fr\u00e5ga geolokaliseringsdata p\u00e5 din PHP-webbsida<\/h3>\n
Vi skapar nu PHP-webbsidan f\u00f6r att fr\u00e5ga databasen och mata ut geolokaliseringsdata f\u00f6r sidbes\u00f6karen.<\/p>\n
Skapa en sida som heter test.php<\/code>och klistra in f\u00f6ljande kod i den.<\/p>\n
<?php\n$dbname = 'ip2location'; \/\/ database name\n$dbhost = 'localhost'; \/\/ database server name\n$dbuser = 'root'; \/\/ database user login\n$dbpass = '12345'; \/\/ database user password\n?>\n<!DOCTYPE html>\n<head>\n\u00a0\u00a0\u00a0\u00a0<title>Test page<\/title>\n<\/head>\n<body>\n<?php\ntry {\n\u00a0\u00a0\u00a0\u00a0$pdo = new PDO('mysql:host='. $dbhost. ';dbname='. $dbname. ';charset=utf8', $dbuser, $dbpass);\n\u00a0\u00a0\u00a0\u00a0$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n\u00a0\u00a0\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0$ip = $_SERVER['REMOTE_ADDR']; \/\/ web visitor's IP address\n\u00a0\u00a0\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0$st = $pdo->prepare('select * from `ip2location_db11` where inet_aton(:ip) <= ip_to limit 1');\n\u00a0\u00a0\u00a0\u00a0$st->bindParam(':ip', $ip, PDO::PARAM_STR);\n\u00a0\u00a0\u00a0\u00a0$st->execute();\n\u00a0\u00a0\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0$data = $st->fetchAll(PDO::FETCH_ASSOC);\n\u00a0\u00a0\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0if ($st->rowCount() > 0) {\n\u00a0\u00a0\u00a0\u00a0\u00a0echo 'country_code: '. $data[0]['country_code']. \"<br \/>n\";\n\u00a0\u00a0\u00a0\u00a0\u00a0echo 'country_name: '. $data[0]['country_name']. \"<br \/>n\";\n\u00a0\u00a0\u00a0\u00a0\u00a0echo 'region_name: '. $data[0]['region_name']. \"<br \/>n\";\n\u00a0\u00a0\u00a0\u00a0\u00a0echo 'city_name: '. $data[0]['city_name']. \"<br \/>n\";\n\u00a0\u00a0\u00a0\u00a0\u00a0echo 'latitude: '. $data[0]['latitude']. \"<br \/>n\";\n\u00a0\u00a0\u00a0\u00a0\u00a0echo 'longitude: '. $data[0]['longitude']. \"<br \/>n\";\n\u00a0\u00a0\u00a0\u00a0\u00a0echo 'zip_code: '. $data[0]['zip_code']. \"<br \/>n\";\n\u00a0\u00a0\u00a0\u00a0\u00a0echo 'time_zone: '. $data[0]['time_zone']. \"<br \/>n\";\n\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0else {\n\u00a0\u00a0\u00a0\u00a0\u00a0echo 'No data found.<br \/>'. \"n\";\n\u00a0\u00a0\u00a0\u00a0}\n}\ncatch(PDOException $e) {\n\u00a0\u00a0\u00a0\u00a0echo 'An error has occurred.<br \/>'. \"n\";\n}\n?>\n<\/body>\n<\/html><\/code><\/pre>\n
\u00d6ppna nu den sidan i din webbl\u00e4sare. Du b\u00f6r se all geolokaliseringsdata f\u00f6r din egen IP-adress. N\u00e4r du kan se alla geolokaliseringsf\u00e4lt som returneras av IP2Location DB11 LITE-data kan du anv\u00e4nda dem i m\u00e5nga scenarier. Du kan filtrera trafik, blockera eller omdirigera anv\u00e4ndare baserat p\u00e5 deras platser.<\/p>\n
Om du har fler fr\u00e5gor om implementeringen kan du hitta fler handledning i IP2Location Blog<\/a>.<\/p>\n
Inspelningsk\u00e4lla:  artisansweb.net<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Bes\u00f6k alla webbplatser och du kommer sannolikt att hitta n\u00e5gon form av lokalisering som anv\u00e4nds. Det vanligaste \u00e4r att visa annonser som \u00e4r lokala f\u00f6r dig …<\/p>\n","protected":false},"author":1,"featured_media":20619,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[279],"tags":[850],"class_list":["post-27906","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php-10","tag-affiai-sv"],"_links":{"self":[{"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/posts\/27906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/comments?post=27906"}],"version-history":[{"count":0,"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/posts\/27906\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/media\/20619"}],"wp:attachment":[{"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/media?parent=27906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/categories?post=27906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/themewp.inform.click\/sv\/wp-json\/wp\/v2\/tags?post=27906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}