{"id":1007,"date":"2018-06-04T14:00:06","date_gmt":"2018-06-04T07:00:06","guid":{"rendered":"https:\/\/www.yellowweb.id\/blog\/?p=1007"},"modified":"2018-06-04T14:00:06","modified_gmt":"2018-06-04T07:00:06","slug":"counter-visitor-ip-php","status":"publish","type":"post","link":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/","title":{"rendered":"Counter Visitor (IP) PHP"},"content":{"rendered":"

Setelah pada artikel yang sebelumnya, bagaimana caranya kita membuat sebuah counter visitor dengan menggunakan PHP<\/a>, untuk kali ini kita akan membuat counter visitor berdasarkan IP pengunjung, karena fungsi counter yang sebelumnya dibuat, tidak berdasarkan ip artinya halaman web ketika di refresh akan selalu masuk hitungan visitor.
\n<\/p>\n

Buat database dan struktur tabelnya, seperti berikut:<\/p>\n

\"counter-ip.jpg\"<\/a>

counter ip<\/p><\/div>\n

file koneksi.php<\/strong><\/p>\n

<?php\r\n\t$localhost = \"localhost\";\r\n\t$server = \"root\";\r\n\t$pass = \"\";\r\n\t$db = \"db_counter\";\r\n\r\n\t$konek = mysqli_connect($localhost,$server,$pass,$db) or die (mysqli_error($konek));\t\r\n?><\/pre>\n
kemudian lanjutkan dengan membuat file index.php<\/strong><\/p>\n
<!DOCTYPE html>\r\n<html>\r\n<head>\r\n\t<title>Counter Visitor (IP) | Kursus Web YELLOWWEB.ID<\/title>\r\n<\/head>\r\n<body>\r\n\t<?php\r\n\t\tinclude \"koneksi.php\";\r\n\r\n\t\t\/\/ mengetahui IP ADDRESS\r\n\t\t$ip_pengunjung = $_SERVER['REMOTE_ADDR'];\r\n\r\n\t\t$sql = \"SELECT * FROM tbl_pengunjung WHERE ip_visitor='$ip_pengunjung'\";\r\n\t\t$query = mysqli_query($konek,$sql) or die (mysqli_error($konek));\r\n\r\n\t\t$data = mysqli_fetch_array($query);\r\n\r\n\t\t\/\/ cek jika ada ip baru\r\n\t\tif($data == 0){\r\n\t\t\t$sql = \"INSERT INTO tbl_pengunjung(ip_visitor) VALUES('$ip_pengunjung')\";\r\n\t\t\t$query = mysqli_query($konek,$sql) or die (mysqli_error($konek));\r\n\t\t}\r\n\t?>\r\n\r\n\t<table border=\"1\">\r\n\t\t<thead>\r\n\t\t\t<tr>\r\n\t\t\t\t<th>No<\/th>\r\n\t\t\t\t<th>ID<\/th>\r\n\t\t\t\t<th>IP Pengunjung<\/th>\r\n\t\t\t<\/tr>\r\n\t\t<\/thead>\r\n\t\t<tbody>\r\n\r\n\t\t<?php \r\n\t\t\t\/\/ cetak \r\n\t\t\t$sql = \"SELECT * FROM tbl_pengunjung\";\r\n\t\t\t$query = mysqli_query($konek,$sql) or die (mysqli_error($konek));\r\n\r\n\t\t\t$no = 1;\r\n\r\n\t\t\twhile($data = mysqli_fetch_array($query)){?>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td><?php echo $no;?><\/td>\r\n\t\t\t\t\t<td><?php echo $data['id_visitor'];?><\/td>\r\n\t\t\t\t\t<td><?php echo $data['ip_visitor'];?><\/td>\r\n\t\t\t\t<\/tr>\r\n\r\n\t\t\t\t<?php $no++; ?>\r\n\r\n\t\t\t<?php }\r\n\r\n\r\n\t\t?>\r\n\t\t\t\r\n\t\t<\/tbody>\r\n\t<\/table>\r\n\r\n\t\r\n\r\n<\/body>\r\n<\/html><\/pre>\n
Dengan membuat skrip ini kita dapat mengetahui jumlah pengunjung berdasarkan IP tentunya. Semoga tutorial ini dapat melengkapi tutorial yang sebelumnya pernah kita coba.<\/p>\n
Klik untuk DEMO<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
Setelah pada artikel yang sebelumnya, bagaimana caranya kita membuat sebuah counter visitor dengan menggunakan PHP, untuk kali ini kita akan membuat counter visitor berdasarkan IP pengunjung, karena fungsi counter yang sebelumnya dibuat, tidak berdasarkan ip artinya halaman web ketika di refresh akan selalu masuk hitungan visitor.<\/p>\n","protected":false},"author":1,"featured_media":1011,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110],"tags":[440,442,88,222,441],"class_list":["post-1007","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-counter","tag-pengunjung","tag-php","tag-sql","tag-visitor"],"yoast_head":"\nCounter Visitor (IP) PHP - YELLOWWEB.ID<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Counter Visitor (IP) PHP - YELLOWWEB.ID\" \/>\n<meta property=\"og:description\" content=\"Setelah pada artikel yang sebelumnya, bagaimana caranya kita membuat sebuah counter visitor dengan menggunakan PHP, untuk kali ini kita akan membuat counter visitor berdasarkan IP pengunjung, karena fungsi counter yang sebelumnya dibuat, tidak berdasarkan ip artinya halaman web ketika di refresh akan selalu masuk hitungan visitor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/\" \/>\n<meta property=\"og:site_name\" content=\"YELLOWWEB.ID\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-04T07:00:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/06\/counterip-01.jpg?fit=2500%2C1208&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"2500\" \/>\n\t<meta property=\"og:image:height\" content=\"1208\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yellowweb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yellowweb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/\"},\"author\":{\"name\":\"yellowweb\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"headline\":\"Counter Visitor (IP) PHP\",\"datePublished\":\"2018-06-04T07:00:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/\"},\"wordCount\":102,\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/counterip-01.jpg\",\"keywords\":[\"counter\",\"pengunjung\",\"php\",\"sql\",\"visitor\"],\"articleSection\":[\"PHP\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/\",\"name\":\"Counter Visitor (IP) PHP - YELLOWWEB.ID\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/counterip-01.jpg\",\"datePublished\":\"2018-06-04T07:00:06+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/counterip-01.jpg\",\"contentUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/counterip-01.jpg\",\"width\":2500,\"height\":1208,\"caption\":\"Counter Visitor IP\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/counter-visitor-ip-php\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Counter Visitor (IP) PHP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\",\"name\":\"YELLOWWEB.ID\",\"description\":\"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\",\"name\":\"yellowweb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"caption\":\"yellowweb\"},\"sameAs\":[\"https:\\\/\\\/www.yellowweb.id\"],\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/author\\\/yellowweb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Counter Visitor (IP) PHP - YELLOWWEB.ID","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/","og_locale":"en_GB","og_type":"article","og_title":"Counter Visitor (IP) PHP - YELLOWWEB.ID","og_description":"Setelah pada artikel yang sebelumnya, bagaimana caranya kita membuat sebuah counter visitor dengan menggunakan PHP, untuk kali ini kita akan membuat counter visitor berdasarkan IP pengunjung, karena fungsi counter yang sebelumnya dibuat, tidak berdasarkan ip artinya halaman web ketika di refresh akan selalu masuk hitungan visitor.","og_url":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/","og_site_name":"YELLOWWEB.ID","article_published_time":"2018-06-04T07:00:06+00:00","og_image":[{"width":2500,"height":1208,"url":"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/06\/counterip-01.jpg?fit=2500%2C1208&ssl=1","type":"image\/jpeg"}],"author":"yellowweb","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yellowweb","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/#article","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/"},"author":{"name":"yellowweb","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"headline":"Counter Visitor (IP) PHP","datePublished":"2018-06-04T07:00:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/"},"wordCount":102,"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/06\/counterip-01.jpg","keywords":["counter","pengunjung","php","sql","visitor"],"articleSection":["PHP"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/","url":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/","name":"Counter Visitor (IP) PHP - YELLOWWEB.ID","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/#primaryimage"},"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/06\/counterip-01.jpg","datePublished":"2018-06-04T07:00:06+00:00","author":{"@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"breadcrumb":{"@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/#primaryimage","url":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/06\/counterip-01.jpg","contentUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/06\/counterip-01.jpg","width":2500,"height":1208,"caption":"Counter Visitor IP"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yellowweb.id\/blog\/counter-visitor-ip-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yellowweb.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Counter Visitor (IP) PHP"}]},{"@type":"WebSite","@id":"https:\/\/www.yellowweb.id\/blog\/#website","url":"https:\/\/www.yellowweb.id\/blog\/","name":"YELLOWWEB.ID","description":"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yellowweb.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829","name":"yellowweb","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","caption":"yellowweb"},"sameAs":["https:\/\/www.yellowweb.id"],"url":"https:\/\/www.yellowweb.id\/blog\/author\/yellowweb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/1007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/comments?post=1007"}],"version-history":[{"count":2,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/1007\/revisions"}],"predecessor-version":[{"id":1010,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/1007\/revisions\/1010"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media\/1011"}],"wp:attachment":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media?parent=1007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/categories?post=1007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/tags?post=1007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}