Bezoekers script

[Daan]

De webserver draait inmiddels op php 7,

 

Wou me oude Bezoekers script gebruiken deze wil niet in php 7 draaien, werkt wel op php 5.6

 

Iemand ervaring hiermee ?

 

<?php

  try {
  $connection = mysql_connect('localhost', 'xxxxx', 'xxxxx');
  $db = mysql_select_db('xxxx', $connection);
  $ip = $_SERVER['REMOTE_ADDR'];

  mysql_query("INSERT IGNORE INTO `unique` (`day`, `ip`) VALUES (CURDATE(), '$ip')");
  mysql_query("INSERT INTO `online` (`ip`, `timestamp`) VALUES ('$ip', CURRENT_TIMESTAMP) ON DUPLICATE KEY UPDATE timestamp=CURRENT_TIMESTAMP");
  mysql_query("DELETE FROM `online` WHERE timestamp < NOW() - INTERVAL 5 MINUTE");
  function getFormattedResult($sql) {
  $result = mysql_query($sql);
  $row = mysql_fetch_array($result);
   return number_format($row[0], 0, '', '.');
  }
  $total = getFormattedResult("SELECT COUNT(*) FROM `unique`");
  $today = getFormattedResult("SELECT COUNT(*) FROM `unique` WHERE day = CURDATE()");
  $yesterday = getFormattedResult("SELECT COUNT(*) FROM `unique` WHERE day = DATE_ADD(CURDATE(), INTERVAL -1 DAY)");
  $online = getFormattedResult("SELECT COUNT(*) FROM `online`");

  echo "Totaal $total keer bekeken, $online bezoeker(s), $today vandaag, $yesterday gisteren";
  mysql_close($connection);
} catch (Exception $e) {}
?>
 

 

 

3 november 2018 aangepast door Daan

[Michel]

Plaats code a.u.b. In code tags op het forum. Dan blijft het leesbaar.

 

Wat zelf de log als je het script draait?

[badmeester]

<?php

try {
  $hostname = 'localhost';
  $username = 'xxxxx';
  $password = 'xxxxx';
  $database ='xxxxx';
  $port = '3306';
  
  $db = new \mysqli($hostname, $username, $password, $database, $port);
  
  $ip = $_SERVER['REMOTE_ADDR'];

  $db->query("INSERT IGNORE INTO `unique` (`day`, `ip`) VALUES (CURDATE(), '$ip')");
  $db->query("INSERT INTO `online` (`ip`, `timestamp`) VALUES ('$ip', CURRENT_TIMESTAMP) ON DUPLICATE KEY UPDATE timestamp=CURRENT_TIMESTAMP");
  $db->query("DELETE FROM `online` WHERE timestamp < NOW() - INTERVAL 5 MINUTE");
  
  function getFormattedResult($sql) {
	global $db;
  	$result = $db->query($sql);
  	
  	if ($result) {
	  	$row = $result->fetch_array();
	  	return number_format($row[0], 0, '', '.');
  	} else {
	  	echo $db->error . '<br />';
	  	return '';
  	}
  }
  
  $total = getFormattedResult("SELECT COUNT(*) FROM `unique`");
  $today = getFormattedResult("SELECT COUNT(*) FROM `unique` WHERE day = CURDATE()");
  $yesterday = getFormattedResult("SELECT COUNT(*) FROM `unique` WHERE day = DATE_ADD(CURDATE(), INTERVAL -1 DAY)");
  $online = getFormattedResult("SELECT COUNT(*) FROM `online`");

  echo "Totaal $total keer bekeken, $online bezoeker(s), $today vandaag, $yesterday gisteren";

} catch (Exception $e) {}

?>

MySQL vervangen door MySQLi

[Daan]

@Badmeester

 

Het script werkt nu op 7.2 😀 

 

Heel erg bedankt voor het helpen.