示例#1
0
$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('w', 'o', 'r', 'l'));
}
if (!array_key_exists('subset', $_REQUEST) || !$_REQUEST['subset'] == 'graph') {
    header('Content-disposition: attachment;filename=pagespeed.csv');
}
echo '# Measurements gathered for ' . $url . "\n";
foreach ($rows as $row) {
    echo date('c', $row['time']) . ',' . $row['w'] . ',' . $row['o'] . ',' . $row['l'] . ',' . $row['r'];
    if (array_key_exists('subset', $_REQUEST) && $_REQUEST['subset'] == 'graph') {
        echo "\n";
    } else {
        echo ',' . $row['t'] . ',' . $row['v'] . ',' . $row['pBadReqs'] . ',' . $row['pBrowserCache'] . ',' . $row['pCacheValid'] . ',' . $row['pCharsetEarly'] . ',' . $row['pCombineCSS'] . ',' . $row['pCombineJS'] . ',' . $row['pCssImport'] . ',' . $row['pCssInHead'] . ',' . $row['pCssJsOrder'] . ',' . $row['pCssSelect'] . ',' . $row['pDeferJS'] . ',' . $row['pDocWrite'] . ',' . $row['pDupeRsrc'] . ',' . $row['pGzip'] . ',' . $row['pImgDims'] . ',' . $row['pMinDns'] . ',' . $row['pMinifyCSS'] . ',' . $row['pMinifyHTML'] . ',' . $row['pMinifyJS'] . ',' . $row['pMinRedirect'] . ',' . $row['pMinReqSize'] . ',' . $row['pNoCookie'] . ',' . $row['pOptImgs'] . ',' . $row['pParallelDl'] . ',' . $row['pPreferAsync'] . ',' . $row['pRemoveQuery'] . ',' . $row['pScaleImgs'] . ',' . $row['pSprite'] . ',' . $row['pUnusedCSS'] . ',' . $row['pVaryAE'] . ',' . "\n";
    }
}
示例#2
0
    $format = 'json';
}
$formats = array('csv' => array('content-type' => 'text/csv', 'extension' => 'csv'), 'json' => array('content-type' => 'application/json', 'extension' => 'json'));
header('Content-type: ' . $formats[$format]['content-type']);
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', $_GET)) {
    require_once dirname(__FILE__) . '/smooth.php';
    smooth($rows, $to_smooth);
}
header('Content-disposition: ' . (array_key_exists('download', $_GET) ? 'attachment' : 'inline') . ';filename=' . $provider_name . '_' . date('M-d-Y_G-i-s', $lastupdate) . '.' . $formats[$format]['extension']);
if ($format == 'csv') {
    echo '# Measurement time';
    for ($i = 0; $i < count($result_metrics); $i++) {
        $metric = $result_metrics[$i];
        $units = $metric_types[$metric[2]]['legend'];
        echo ', [' . $metric[1] . '] ' . $metric[0] . ($units !== '' ? ' (' . $units . ')' : '');
    }
    echo "\n";
    foreach ($rows as $row) {
        echo date('c', $row['timestamp']);
        for ($i = 0; $i < count($result_metrics); $i++) {
            $metric = $result_metrics[$i];
            echo ',' . $row[$metric[1]];
示例#3
0
    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)';
示例#4
0
$result = mysql_query($query);
if (!$result) {
    error_log(mysql_error());
}
$row = mysql_fetch_assoc($result);
$urlid = $row['id'];
mysql_free_result($result);
$query = sprintf("SELECT UNIX_TIMESTAMP(timestamp) AS t, value\n\tFROM metric WHERE url_id = %d AND metric_id = %d AND timestamp > DATE_SUB(now(), INTERVAL 3 MONTH)\n\tORDER BY timestamp DESC", mysql_real_escape_string($urlid), mysql_real_escape_string($metrics[$_GET['metric']]['id']));
$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');
}
echo '# Timestamp, ' . $metrics[$_GET['metric']]['title'] . ' for ' . $_GET['url'] . "\n";
$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('value'));
}
foreach ($rows as $row) {
    echo date('c', $row['t']) . ',' . $row['value'] . "\n";
}
示例#5
0
 public function fields()
 {
     $columns = $this->columns();
     if ($columns) {
         $fields = array();
         $this->_bundleFields = array();
         foreach ($columns as $i) {
             if (strpos($i->data, ' ') === false) {
                 $fields[] = $i->data . ' as ' . smooth($i->data);
             } else {
                 $fields[] = $i->data;
             }
             if (isset($i->bundle)) {
                 $this->_bundleFields[] = $i;
             }
             if (isset($i->refer)) {
                 if (strpos($i->refer, ' ') === false) {
                     $fields[] = $i->refer . ' as ' . smooth($i->refer);
                 } else {
                     $fields[] = $i->refer;
                 }
             }
         }
         return $fields;
     } else {
         return array('*');
     }
 }