How to make unique views of articles by IP address?

Question

PHP

Here is the query
///Function to view news, video and photo
function views($table, $title){
db_connect();
$query = sprintf(" SELECT views FROM $table WHERE $table.title_url = '%s' ",
mysql_real_escape_string($title));
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$views = $row['views']+1;
mysql_query(" UPDATE $table SET views='$views' WHERE $table.title_url = '$title' ");
}
I want the views to not be read each time the user clicks.
At least views were not read when updating the page of a particular article.

Answer 1

Find out the user's IP:

if (!empty($_SERVER['HTTP_CLIENT_IP'])){
    $ip = $_SERVER['HTTP_CLIENT_IP'];
}
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])){
    $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
}
else{
    $ip = $_SERVER['REMOTE_ADDR'];
}

Suppose that a person decided to refresh the page, but the IP is already in your database, therefore, it remains only to check for compliance and, in case of a match, do not count the view.

$query = mysql_query("SELECT `ip` from `table` where `ip` = '$ip'");
mysql_fetch_array($query);
if(isset($query['ip'])){
    // Если ip есть, то не засчитываем
}else{
    // Иначе засчитываем посещение и делаем sql запрос для увеличение счетчика
}

You probably understood that for IP addresses you need to create a separate table in the database and write them there when the user visits the page for the first time, and then after refreshing the page you will already know that this person visited the page.
You may have a question about determining the IP address, saying why there are already three different options for obtaining ip. So $_SERVER['HTTP_CLIENT_IP'] and $_SERVER['HTTP_X_FORWARDED_FOR']) contain the user's real ip address, that is, if he comes to you using a proxy server, then you will get not the proxy ip, but the ip of his computer. But in case there is no ip address in these two variables, then we will use $_SERVER['REMOTE_ADDR'].
There is another implementation option with binding to kukki. Read and try. The principle is the same.
I think that's enough information for you to now go and do a unique IP lookup. So keep it up :). In general, read about how best to make unique views, because doing only by ip address is not correct.

Answer 2

In cookies, write down the id of the articles that a specific user has viewed, and not just from one ip, since several people can come from one ip. If the cookie contains the id of the current article, then do not add the counter. Since the user will look at a lot of articles, the value in the cookie should be written as an id array. view = (2, 16, 27, ...)

Answer 3

As I understand it, you need to create a separate table that will store a list of IP addresses.