<?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);