Ik heb een script van dit forum gebruikt om de bezoekers gegevens te registreren in MySql.
Ik krijg er gegevens in, dus dat werkt.
Alleen hij update geen gegevens omdat ik die functie niet heb meegegeven.
Nou vermoed ik dat ik de if functie moet gaan gebruiken, maar snap niet hoe ik die constructie in elkaar moet zetten.
Wie wil me even helpen?
Dit is de code:
<?php
$dbhost = "localhost";
$dbuser = "database";
$dbpass = "password";
$dbname = "database";
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
//--- set easy vars!
$ipaddr = $_SERVER['REMOTE_ADDR'];
$date = date('d/m/Y');
$time = date('H.i.s');
//--- set languages
$lang['nl'] = "NL";
$lang['us'] = "USA";
$lang['hu'] = "Hungarian";
$lang['de'] = "Germany";
$lang['fr'] = "France";
$lang['be'] = "Belgium";
$lang['au'] = "Australia";
$lang['se'] = "Sweden";
$lang['fi'] = "Finland";
$lang['uk'] = "UK";
//--- get country from hostname!
$hostname = gethostbyaddr($ipaddr);
$hostname_slizes = explode('.', $hostname);
$count_slizes = count($hostname_slizes);
$piece = $count_slizes - 1;
$extention = $hostname_slizes[$piece];
//--- check if country code is defined above
if ($lang[$extention])
$language = $lang[$extention];
else
$language = "Unknown";
//--- set platforms
$agent['windows'] = "Windows";
$agent['mac'] = "Macinotosh";
$agent['linux'] = "Linux";
$agent['unix'] = "Unix";
//-- define user agent
$user_agent = strtolower($_SERVER['HTTP_USER_AGENT']);
foreach($agent as $key => $value)
{
if (preg_match("/" . $key . "/", $user_agent))
$platform = $agent[$key];
}
if (!$platform)
$platform = "Unknown";
//--- echo die sjit!
//echo "<p>Client IP: " . $ipaddr . "<br />";
//echo "Client language: " . $language . "<br />";
//echo "Client platform: " . $platform . "<br />";
//echo "Client time: " . $time . "<br />";
//echo "Client date: " . $date . "</p>";
$insertquery = mysql_query("INSERT INTO `database`.`Statistieken` (`ip` , `Language` , `Platform` , `Time` , `Date`)VALUES ('$ipaddr', '$language', '$platform', '$time', '$date');");
$updatequery = mysql_query("UPDATE INTO `database`.`Statistieken` (`ip` , `Language` , `Platform` , `Time` , `Date`)VALUES ('$ipaddr', '$language', '$platform', '$time', '$date');");
?>
Alvast bedankt voor je hulp.