Archief - PHP: resultaten vergelijken

<?php
$query="select *from uniquetraffic where date like '$date2%' order by time desc";
mysql_db_query("mijn_database", $query);
		
if ($date2){
if ($result)
{
while ($r = mysql_fetch_array($result))
{
$ip = $r["ip"];
$datum = $r["date"];
$time = $r["time"];

echo"<tr>
<td$ip</td>
<td>$datum, $time</td>
		  </tr>
";

}

}

}

?>

<?php
$query="SELECT count(*) as aantal, ip from mijn_tabel where date like '$date2%' group by ip order by aantal desc"; 

$result = mysql_db_query("miijn_database", $query); 

if ($result) 
{ 
while ($r = mysql_fetch_array($result)) 
{ 
$ip = $r["ip"]; 
$aantal = $r["aantal"]; 

echo"<tr>
<td>$ip</a></td>
<td>$aantal</td> 
</tr> 
"; 

} 

} 

?>

<?php 
mysql_connect("localhost", "username", "pass");   // Your MySQL user settings :) 
mysql_select_db("databasename"); //here your database name :D 

$s_aantal = mysql_query("Select Count(id) From bezonline Where ip = '".$_SERVER['REMOTE_ADDR']."'") or die(mysql_error()); 

if (!mysql_result($s_aantal, 0)) 
    mysql_query("Insert Into bezonline (id, ip, tijd) Values ('NULL', '".$_SERVER['REMOTE_ADDR']."', '".time()."')") or die(mysql_error()); 
else { 
    mysql_query("Update bezonline Set tijd = '".time()."' Where ip = '".$_SERVER['REMOTE_ADDR']."'") or die(mysql_error()); 
    mysql_query("Delete From bezonline Where tijd < ".time()." - 60*5") or die(mysql_error()); 
} 
?>

<?php 
require "page.php"; 
mysql_connect("localhost", "", "");    // MySQL settings 
mysql_select_db("test"); //MySQL database 

$s_aantal = mysql_query("Select Count(id) From bezonline"); 
$aantal = mysql_result($s_aantal, 0); 

if ($aantal > 1 || $aantal == 0) 
    echo "Er zijn<b>".$aantal."</b> bezoekers"; 
else 
    echo "Er is <b>één</b> bezoeker!"; 
?>

CREATE TABLE `bezonline` ( 
`id` int(11) NOT NULL auto_increment, 
`ip` varchar(50) NOT NULL default '', 
`tijd` varchar(50) NOT NULL default '', 
PRIMARY KEY  (`id`) 
) TYPE=MyISAM AUTO_INCREMENT=15 ;