• 1
• 2
• 3
• 4
• 5
• 6
• 7

CREATE TABLE IF NOT EXISTS `google_top_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_uri` varchar(60) NOT NULL,
  `page_title` varchar(60) NOT NULL,
  `total_views` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22

<?php
########## Google Settings.. Client ID, Client Secret #############
$google_client_id 				= '12345678901112.apps.googleusercontent.com';
$google_client_secret 			= 'XYZ_1234_abcdXYZ';
$google_redirect_url 			= 'http://yoursite.com/update_pages.php';
$page_url_prefix				= 'http://www.sanwebe.com';

########## Google analytics Settings.. #############
$google_analytics_profile_id 	= 'ga:123456'; //Analytics site Profile ID
$google_analytics_dimensions 	= 'ga:landingPagePath,ga:pageTitle'; //no change needed (optional)
$google_analytics_metrics 		= 'ga:pageviews'; //no change needed (optional)
$google_analytics_sort_by 		= '-ga:pageviews'; //no change needed (optional)
$google_analytics_max_results 	= '20'; //no change needed (optional)

########## MySql details #############
$db_username 					= "db_user_name"; //Database Username
$db_password 					= "xxxxxx"; //Database Password
$hostname 						= "localhost"; //Mysql Hostname
$db_name 						= 'xxxxxx'; //Database Name
###################################################################

$mysqli = new mysqli($hostname,$db_username,$db_password,$db_name);

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• 51
• 52
• 53
• 54
• 55
• 56
• 57
• 58
• 59
• 60
• 61
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85

<?php
//start session
session_start();

//include configuration file
include_once("config.php");

//include google api files
require_once 'src/Google_Client.php';
require_once 'src/contrib/Google_AnalyticsService.php';

$gClient = new Google_Client();
$gClient->setApplicationName('Login to saaraan.com');
$gClient->setClientId($google_client_id);
$gClient->setClientSecret($google_client_secret);
$gClient->setRedirectUri($google_redirect_url);
$gClient->setScopes(array('https://www.googleapis.com/auth/analytics.readonly'));
$gClient->setUseObjects(true);


//check for session variable
if (isset($_SESSION["token"])) { 

	//set start date to previous month
	$start_date = date("Y-m-d", strtotime("-1 month") ); 
	
	//end date as today
	$end_date = date("Y-m-d");
	
	try{
		//set access token
		$gClient->setAccessToken($_SESSION["token"]); 
		
		//create analytics services object
		$analyticsService = new Google_AnalyticsService($gClient); 
		
		//analytics parameters (check configuration file)
		$params = array('dimensions' => $google_analytics_dimensions,'sort' => $google_analytics_sort_by,'filters' => 'ga:medium==organic','max-results' => $google_analytics_max_results);
		
		//get results from google analytics
		$results = $analyticsService->data_ga->get($google_analytics_profile_id,$start_date,$end_date, $google_analytics_metrics, $params);
	}
	catch(Exception $e){ //do we have an error?
		echo $e->getMessage(); //display error
	}
	
	$pages = array();
	$rows = $results->rows;
	
	if($rows)
	{
		echo '<ul>';
		foreach($rows as $row)
		{
			//prepare values for db insert
			$pages[] = '("'.$row[0].'","'.$row[1].'",'.$row[2].')';
			
			//output top page link
			echo '<li><a href="'.$page_url_prefix.$row[0].'">'.$row[1].'</a></li>';
		}
		echo '</ul>';
		
		//empty table
		$mysqli->query("TRUNCATE TABLE google_top_pages");
		
		//insert all new top pages in the table
		if($mysqli->query("INSERT INTO google_top_pages (page_uri, page_title, total_views) VALUES ".implode(',', $pages).""))
		{
			echo '<br />Records updated...';
		}else{
			echo $mysqli->error;
		}
	}
	
}else{
	//authenticate user
	if (isset($_GET['code'])) {		
		$gClient->authenticate();
		$token = $gClient->getAccessToken();
		$_SESSION["token"] = $token;
		header('Location: ' . filter_var($google_redirect_url, FILTER_SANITIZE_URL));
	}else{
		$gClient->authenticate();
	}
}

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18

<?php
//include configuration file
include_once("config.php");

//get all records from db table
$results = $mysqli->query("SELECT page_uri, page_title, total_views FROM google_top_pages ORDER BY total_views ASC");

//list all top pages on screen
echo '<ul class="page_result">';
while($row = mysqli_fetch_array($results))
{
   echo '<li><a href="'.$page_url_prefix.$row['page_uri'].'">'.$row['page_title'].'</a></li>';
}
echo '</ul>';

//link to update page for admin
echo '<div class="update-button"><a href="update_pages.php">Update top pages list!</a></div>';
?>