function getFavoriteCount() { $sql = "SELECT tweet.text, tweetpopularity.favoriteCount FROM `tweetpopularity` \n\t\t\t\t\tINNER JOIN tweet ON tweetpopularity.tweetId = tweet.tweetId \n\t\t\t\t\twhere favoriteCount != 0 group by favoriteCount limit 10 offset 10"; $twitterDB = new TwitterDB(); $conn = $twitterDB->getDBConnection(); $result = $conn->query($sql); $tweets = array(); if ($result->num_rows > 0) { // output data of each row $i = 0; while ($row = $result->fetch_assoc()) { $tweets[$i]["text"] = $row["text"]; $tweets[$i]["favoriteCount"] = $row["favoriteCount"]; settype($tweets[$i]["favoriteCount"], "integer"); $i++; } } $twitterDB->closeDBConnection($conn); return $tweets; }
<html> <head> <?php include 'TwitterDB.php'; include 'Chart.php'; $twitterDB = new TwitterDB(); //$twitterDB->printArray($_SERVER); $chart = new Chart('PieChart'); $options = array(); if (!empty($_GET) && isset($_GET) && array_key_exists('charts', $_GET) && !empty($_GET['charts'])) { $flag = false; if ($_GET['charts'] == 'retweetcount-vs-text') { $flag = true; $data = $twitterDB->getRetweetCountAndText(); $chart->load($data, 'array'); $options = array('title' => 'How many times a tweet is retweeted limited to 10.', 'is3D' => true, 'width' => 500, 'height' => 400); } else { if ($_GET['charts'] == 'different-days') { $flag = true; $data = $twitterDB->getTweetsOfDifferentDays(); $chart->load($data, 'array'); $options = array('title' => 'Different days tweets analytics', 'is3D' => true, 'width' => 500, 'height' => 400); } else { if ($_GET['charts'] == 'status-source') { $flag = true; $data = $twitterDB->getStatusSource(); $chart->load($data, 'array'); $options = array('title' => 'Different types of sources used to tweet', 'is3D' => true, 'width' => 500, 'height' => 400); } else { if ($_GET['charts'] == 'favorite-count') { $flag = true;