data_dynatrace.php - This PHP script retrieves data from a …

/details/data_dynatrace.php

http://showslow.googlecode.com/ · PHP · 137 lines · 117 code · 20 blank · 0 comment · 22 complexity · 5f075fc0f19777b5b09f4d6cb3350cfe MD5 · raw file


<?php 
require_once(dirname(dirname(__FILE__)).'/global.php');

if (!array_key_exists('url', $_GET) || filter_var($_GET['url'], FILTER_VALIDATE_URL) === false) {
	header('HTTP/1.0 400 Bad Request');

	?><html>
<head>
<title>Bad Request: no valid url specified</title>
</head>
<body>
<h1>Bad Request: no valid url specified</h1>
<p>You must pass valid URL as 'url' parameter</p>
</body></html>
<?php 
	exit;
}

$query = sprintf("SELECT id FROM urls WHERE urls.url = '%s'", mysql_real_escape_string($_GET['url']));
$result = mysql_query($query);

if (!$result) {
	error_log(mysql_error());
}

$row = mysql_fetch_assoc($result);
$urlid = $row['id'];
mysql_free_result($result);

if (array_key_exists('subset', $_REQUEST)) {
	if ($_REQUEST['subset'] == 'graph')
	{
		$query = sprintf("SELECT UNIX_TIMESTAMP(d.timestamp) as time, rank
			FROM dynatrace d WHERE d.url_id = %d AND d.timestamp > DATE_SUB(now(),INTERVAL 3 MONTH)
			ORDER BY d.timestamp DESC",
			mysql_real_escape_string($urlid)
		);
	}
	else if ($_REQUEST['subset'] == 'table')
	{
		$query = sprintf("SELECT UNIX_TIMESTAMP(d.timestamp) as time,
				pagesize, reqnumber, rank, timetoimpression
			FROM dynatrace d WHERE d.url_id = %d AND d.timestamp > DATE_SUB(now(),INTERVAL 3 MONTH)
			ORDER BY d.timestamp DESC",
			mysql_real_escape_string($urlid)
		);
	}
} else {
	$query = sprintf("SELECT UNIX_TIMESTAMP(d.timestamp) as time,
			rank, cache, net, server, js,
			timetoimpression, timetoonload, timetofullload,
			reqnumber, xhrnumber,
			pagesize, cachablesize, noncachablesize,
			timeonnetwork, timeinjs, timeinrendering
		FROM dynatrace d WHERE d.url_id = %d AND d.timestamp > DATE_SUB(now(),INTERVAL 3 MONTH)
		ORDER BY d.timestamp DESC",
		mysql_real_escape_string($urlid)
	);
}

$result = mysql_query($query);

if (!$result) {
        error_log(mysql_error());
}

$data = array();

header('Content-type: text/plain');
if (array_key_exists('ver', $_GET)) {
	header('Expires: '.date('r', time() + 315569260));
	header('Cache-control: max-age=315569260');
}

$rows = array();
while ($row = mysql_fetch_assoc($result)) {
	$rows[] = $row;
}

mysql_free_result($result);

if (array_key_exists('smooth', $_REQUEST)) {
	require_once(dirname(__FILE__).'/smooth.php');
	smooth($rows, array('rank'));
}

if (!array_key_exists('subset', $_REQUEST))
{
	header('Content-disposition: attachment;filename=dynatrace.csv');

	echo '# Measurement time';
	echo ', Overall Page Rank (Percentage)';
	echo ', Caching Rank (Percentage)';
	echo ', Network Rank (Percentage)';
	echo ', Server-Side Rank (Percentage)';
	echo ', JavaScript Rank (Percentage)';
	echo ', Time to First Impression (ms)';
	echo ', Time to onLoad (ms)';
	echo ', Time to Full Page Load (ms)';
	echo ', Number of Requests';
	echo ', Number of XHR Requests';
	echo ', Total Page Size (bytes)';
	echo ', Total Cachable Size (bytes)';
	echo ', Total Non-Cachable Size (bytes)';
	echo ', Total Time on Network (ms)';
	echo ', Total Time in JavaScript (ms)';
	echo ', Total Time in Rendering (ms)';
	echo "\n";
}

foreach ($rows as $row) {

        echo date('c', $row['time']).',';

	if (array_key_exists('subset', $_REQUEST)) {
		if ($_REQUEST['subset'] == 'graph')
		{
			echo $row['rank'];
		}
		else if ($_REQUEST['subset'] == 'table')
		{
			echo	$row['pagesize'].','.
				$row['reqnumber'].','.
				$row['rank'].','.
				$row['timetoimpression'];
		}
	} else {
		echo $row['rank'].','.$row['cache'].','.$row['net'].','.$row['server'].','.$row['js'].','.
		$row['timetoimpression'].','.$row['timetoonload'].','.$row['timetofullload'].','.
		$row['reqnumber'].','.$row['xhrnumber'].','.
		$row['pagesize'].','.$row['cachablesize'].','.$row['noncachablesize'].','.
		$row['timeonnetwork'].','.$row['timeinjs'].','.$row['timeinrendering'];
	}

	echo "\n";
}

Summary ✨

This PHP script retrieves data from a database and outputs it as plain text, either as an attachment or as a CSV file. The output includes various metrics such as page rank, caching, network, server, JavaScript, and rendering times for a specified URL over the past three months. It can be filtered by subset (graph or table) and optionally sets expiration headers for caching.

Alerts (16)

'$_GET[' Unbounded request input detected; limit size (e.g., check Content-Length or use max input vars) to prevent memory exhaustion
4 19
'mysql_real_escape_string(' Outdated escaping; use PDO or MySQLi prepared statements for stronger SQL injection protection
19 36 45 57
Complexity hotspot; lines 30 to 31 (total complexity: 3)
30 31
'$_REQUEST[' Unbounded request input detected; limit size (e.g., check Content-Length or use max input vars) to prevent memory exhaustion
31 39 116 120
Complexity hotspot; line 39 (total complexity: 3)
39
Complexity hotspot; lines 115 to 116 (total complexity: 3)
115 116
Complexity hotspot; line 120 (total complexity: 3)
120