<?php
require_once 'db/config.php';
$con = new config(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$db = new Database($con);
$db->openConnection();
$postdata = file_get_contents("php://input");
$jsonHandle = new jsonHandler();
$requestData = $jsonHandle->decode($postdata);
$data = array();
$page = $db->escapeString($requestData->page);
$innerPage = $db->escapeString($requestData->innerPage);
if ($page == "dashboard") {
$query = $db->query("SELECT * FROM tbl_hashtag");
/*Overview Page*/
if ($innerPage == "overview") {
/*Check whether it contains tha hashtag data or not*/
if ($db->hasRows($query)) {
$data['hashtagArray'] = array();
$i = 0;
while ($row = $db->fetchAssoc($query)) {
$hashtagName = $row['hashtagName'];
/*Total Tweet Count*/
$totTweetsQuery = $db->query("SELECT COUNT(DISTINCT tweet_id) FROM tweet_tags WHERE tag = '{$hashtagName}'");
$totalTweets = $db->fetchArray($totTweetsQuery);
$data['hashtagArray'][$i]['hashtagName'] = $hashtagName;
$data['hashtagArray'][$i]['tweets'] = array();
//$tweetQuery = "SELECT * FROM tweet_tags LEFT JOIN"
$data['hashtagArray'][$i]['totalTweets'] = $totalTweets[0];
$data['hashtagArray'][$i]['totalImpressions'] = $i + 2000;
$data['hashtagArray'][$i]['profileVisits'] = 3000;
<?php
require_once '../db/config.php';
$con = new config(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$db = new Database($con);
$db->openConnection();
$postdata = file_get_contents("php://input");
$jsonHandle = new jsonHandler();
$requestdata = $jsonHandle->decode($postdata);
