home *** CD-ROM | disk | FTP | other *** search
/ Internet Magazine 2004 New Year / INTERNET112.ISO / pc / projects / log_analyser / stats.php < prev    next >
Encoding:
PHP Script  |  2003-10-23  |  928 b   |  42 lines
  1.  
  2. <html>
  3. <head>
  4.     <title>Referrers</title>
  5.     <link rel="stylesheet" href="stats.css" type="text/css" />
  6. </head>
  7.     <body>
  8.         <div align="center">
  9.  
  10. <table>
  11. <thead><tr><td>Time</td><td>Visitor</td><td>Pages</td><td>Entry Page</td><td>Referrer</td></tr></THEAD>
  12.  
  13. <?php
  14.  
  15. include($DOCUMENT_ROOT.'/connect.php');
  16.  
  17. $result = mysql_query("
  18.                select date_format(ts, '%m-%d %H:%i') v, 
  19.                       host, views, ref, page 
  20.                from   visits
  21.                order  by ts desc 
  22.           ");
  23.  
  24.     while ($res = mysql_fetch_array($result)) { 
  25.           echo "<tr>";
  26.           echo "<td>{$res['v']}</td>";
  27.           echo "<td>{$res['host']}</td>";
  28.           echo "<td>{$res['views']}</td>";
  29.           echo "<td>{$res['page']}</td>";
  30.           echo "<td><A HREF=\"{$res['ref']}\">{$res['ref']}</a></td>";
  31.         echo "</tr>";
  32.     };
  33.     print "</table>\n";    
  34.  
  35. ?>
  36.  
  37.         </div>
  38.     </body>
  39. </html>
  40.  
  41.  
  42.