/*plantilla de la pagina*/

<?php

$con_error='Could not connect';

$mysql_host='localhost';
$mysql_user='root';
$mysql_pass='';
$mysql_db='new_database';

/*

/*connect to server / database*/
$mysqlcon=mysqli_connect($mysql_host, $mysql_user, $mysql_pass) or die($con_error);

/*select database*/
mysqli_select_db($mysqlcon, $mysql_db) or die($con_error);

?>



    /*codigo que aumenta el contador por ip y guarda la ip*/

<?php
    $user_ip=$_SERVER['REMOTE_ADDR'];
    mysqli_query($mysqlcon, "INSERT INTO hit_ip VALUES ($user_ip)");


    function add_ip () {
        global $mysqlcon;
        global $user_ip;

        $query="SELECT ip FROM hit_ip WHERE ip='$user_ip'";
        $query_run=mysqli_query($mysqlcon, $query);
        if (mysqli_num_rows($query_run)==NULL) {
            $ip_query="INSERT INTO hit_ip VALUES ($user_ip)";
            $result_ip=mysqli_query($mysqlcon, $ip_query);
            if ($result_ip) {
                $query_count="UPDATE hit_counter SET value=value+1 WHERE hits='hits'";
                $result_query=mysqli_query($mysqlcon, $query_count);
            }
        }
    }


    add_ip();

?>