PHP Classes

File: Test

Recommend this page to a friend!
  Classes of César Bruschi   Real Counter   Test   Download  
File: Test
Role: Example script
Content type: text/plain
Description: Example and foc
Class: Real Counter
Keep track of visitors to site pages in MySQL
Author: By
Last change:
Date: 14 years ago
Size: 2,315 bytes
 

Contents

Class file image Download
<?php
/*
 * Simple example in debugger mode
--
-- Table structure for table `counter_visitors`
--

CREATE TABLE IF NOT EXISTS `counter_visitors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agent` varchar(512) NOT NULL,
  `ip` char(15) NOT NULL,
  `page` varchar(512) NOT NULL,
  `last_impression` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `counter_visitors`
--

INSERT INTO `counter_visitors` (`id`, `agent`, `ip`, `page`, `last_impression`) VALUES
(7, 'Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100214 Ubuntu/9.10 (karmic) Firefox/3.5.8', '::1', '', '2010-03-08 22:26:50'),
(6, 'Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100214 Ubuntu/9.10 (karmic) Firefox/3.5.8', '::1', '', '2010-03-08 22:26:50'),
(8, 'Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100214 Ubuntu/9.10 (karmic) Firefox/3.5.8', '::1', '/Counter/test.php', '2010-03-08 22:26:50'),
(9, 'Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100214 Ubuntu/9.10 (karmic) Firefox/3.5.8', '::1', '/Counter/test.php', '2010-03-08 22:26:50'),
(10, 'Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100214 Ubuntu/9.10 (karmic) Firefox/3.5.8', '::1', '/Counter/test.php', '2010-03-08 22:30:33');

-- --------------------------------------------------------

--
-- Table structure for table `counter_visits`
--

CREATE TABLE IF NOT EXISTS `counter_visits` (
  `id` int(10) NOT NULL,
  `page` varchar(256) NOT NULL,
  `visit` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `counter_visits`
--

INSERT INTO `counter_visits` (`id`, `page`, `visit`) VALUES
(0, '/Counter/test.php', 16);
 */
ini_set("display_errors","On");
$link = mysql_connect('localhost', 'root', 'pass');
if (!
$link) {
    die(
'Not connected : ' . mysql_error());
}

// make foo the current db
$db_selected = mysql_select_db('development', $link);
if (!
$db_selected) {
    die (
'Can\'t use development: ' . mysql_error());
}


 include(
"Class.Counter.php");
 
$counter = new counter(true);
 echo
"The current page has been shown ".$counter->getPageVisits()." times<br />";
 echo
"Actually, ".$counter->getPageVisitors()." different people has seen it!<br />";
 
?>