Beginner PHP Tutorial 123 - 126 - Creating a Database Hit Counter Part 1- 4

 

<?php require 'connect.inc.php'; $user_ip = $_SERVER['REMOTE_ADDR']; function ip_exists($ip) { global $user_ip; $query ="SELECT `ip` FROM `hits_ip` WHERE `ip`='$user_ip' "; $query_run = mysql_query($query); $mysql_num_rows = mysql_num_rows($query_run); if ($mysql_num_rows ==0) { return false; } else if ($mysql_num_rows >=1) { return true; } } function ip_add($ip) { $query = "INSERT INTO 'hits_ip' VALUES ('$ip') "; @$query_run = mysql_query($query); } function update_count() { $query =" SELECT `count` FROM `hits_count` "; if (@$query_run = mysql_query($query)) { $count = mysql_result($query_run,0,'count'); $count_inc = $count +1; $query_update ="UPDATE `hits_count` SET `count` = '$count_inc' " ; @$query_update_run = mysql_query($query_update); } } if (ip_exists($user_ip)) { update_count(); ip_add($user_ip); } ?> <h1> My page </h1>

Beginner PHP Tutorial 123 - 126 - Creating a Database Hit Counter Part 1- 4 2015-09-28T15:23:00+07:00 Rating: 4.5 Diposkan Oleh: http://pdunoteit.blogspot.com/