J’ai un problème, je dois exclure la gamme IP de la firebase database mysql visiteurs de la comptabilité, et j’ai ce code qui fonctionne bien:
<?php // time $temps = 60*24*3600; // send setcookie ("ip", "Visitor", time() + $temps); // receive $cookie_value = "Visitor"; setcookie("ip", $cookie_value, time()+3600, "/cookies/", "exemple.com", 1, 1); ob_start(); date_default_timezone_set('Europe/Paris'); $date=date("Ymd H:i:s"); $servername = "host"; $username = "user"; $password = "password"; $dbname = "database"; $cookie=$_COOKIE['ip']; $ip=$_SERVER['REMOTE_ADDR']; $port=$_SERVER['REMOTE_PORT']; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $sql = "INSERT INTO database ( date, ip, port, cookie) VALUES ('$date', '$ip', '$port' , '$cookie')"; if (mysqli_query($conn, $sql)) { echo "New record created successfully"; } else { echo "Error: " . $sql . "
" . mysqli_error($conn); } mysqli_close($conn); ob_end_clean(); ?>
Comment exclure l’écriture de plage IP?
Toute aide sera vraiment appréciée.
Je vous remercie.