benim aradığım temanın menüsünde toplam ziyaretci sayısını görüntülemek
bir script buldum wordpress temasına entegre edilebilirmi ?
index.php <?
// CONFIGURATION
$db_visitors = "visitors";
$db_username = "username";
$db_password = "password";
$db_database = "database";
$db_hostname = "localhost";
// CONNECT TO MYSQL DATABASE
@mysql_connect($db_hostname,$db_username,$db_password);
@mysql_select_db($db_database);
function UpdateVisitors()
{
session_start();
if(!isset($_SESSION['visits']))
{
mysql_query("UPDATE ".$GLOBALS['db_visitors']." SET visits=visits+1");
$_SESSION['visits'] = 1;
}
else
$_SESSION['visits']++;
mysql_query("UPDATE ".$GLOBALS['db_visitors']." SET pageviews=pageviews+1");
}
function ShowVisitors()
{
$result = mysql_query("SELECT * FROM ".$GLOBALS['db_visitors']);
$ar = mysql_fetch_array($result);
$ret[0] = $ar[visits];
$ret[1] = $ar[pageviews];
return $ret;
}
// EXAMPLE: HOW TO USE
UpdateVisitors(); // Update statistics
$stats = ShowVisitors(); // Get statistics from database and store it into array $stats
echo "Visitors:".$stats[0]."<br/>"; // Show $stats[0] array (visitors value)
echo "Pageviews:".$stats[1]."<br/>"; // Show $stats[1] array (pageviews value)
?> dump.sql
CREATE TABLE visitors (
visits int(11) NOT NULL default '0',
pageviews int(11) NOT NULL default '0'
) TYPE=MyISAM;
INSERT INTO visitors VALUES (0, 0);