setOption(CURLOPT_HTTPHEADER, array("X-WSSE: UsernameToken Username=\"$username\", PasswordDigest=\"$digest\", Nonce=\"$nonce\", Created=\"$nonce_ts\"")); $rc->postWebRequest($server.$path.'?method='.$method, $data); return $rc; } $reportDate = date("Y-m-d", strtotime("yesterday")); $method="Report.QueueRanked"; $method="Report.QueueRanked"; $data='{ "reportDescription":{ "reportSuiteID":"INSERT_YOUR_RSID", "dateFrom":"'.$reportDate.'", "dateTo":"'.$reportDate.'", "metrics":[{"id":"pageviews"}], "elements":[{"id":"page","top":"5"}] } }'; $rc=GetAPIData($method, $data); if ($rc->getStatusCode()==200) { $response=$rc->getWebResponse(); $json=json_decode($response); if ($json->status=='queued') { $reportID=$json->reportID; } else { $error=true; echo "not queued - "; } } else { $error=true; echo "something went really wrong\n"; var_dump($rc->getInfo()); echo "\n".$rc->getWebResponse(); } while (!$done && !$error) { sleep(15); $method="Report.GetStatus"; $data='{"reportID":"'.$reportID.'"}'; $rc=GetAPIData($method, $data); if ($rc->getStatusCode()==200) { $response=$rc->getWebResponse(); $json=json_decode($response); if ($json->status=="done") { $done=true; } else if ($json->status=="failed" || strstr($json->status, "error")>0) { $error=true; } } else { $done=true; $error=true; echo "something went really wrong\n"; var_dump($rc->getInfo()); echo "\n".$rc->getWebResponse(); } } if ($error) { echo "report failed:\n"; echo $response; } else { $method="Report.GetReport"; $data='{"reportID":"'.$reportID.'"}'; $rc=GetAPIData($method, $data); if ($rc->getStatusCode()==200) { $response=$rc->getWebResponse(); $json=json_decode($response); //Connect To mySQL $hostname='INSERT_YOUR_HOSTNAME'; $username='INSERT_YOUR_USERNAME'; $password='INSERT_YOUR_PASSWORD'; $dbname='INSERT_YOUR_DBNAME'; mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.'); mysql_select_db($dbname); foreach ($json->report->data as $el) { $query = 'INSERT INTO dashboard (omtr_date, omtr_page, omtr_page_view) VALUES ("'.$reportDate.'", "'.$el->name.'", "'.$el->counts[0].'")'; $result = mysql_query($query); } } else { echo "something went really wrong\n"; var_dump($rc->getInfo()); echo "\n".$rc->getWebResponse(); } } ?>