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;
$data['hashtagArray'][$i]['totalMentions'] = 2000 - $i;
$data['hashtagArray'][$i]['totalFollowers'] = 123121;
//header('Content-Type: application/json; charset = UTF-8');
//session_start();
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);
//$requestdata = json_decode($postdata);
$userName = $db->escapeString($requestdata->userName);
$userPass = $db->escapeString($requestdata->userPass);
$data = array();
if (!empty($userName) && !empty($userPass)) {
$query = $db->query("SELECT * FROM tbl_admin WHERE admin_user= '******' AND admin_pass = '******'");
if ($db->hasRows($query) > 0) {
while ($row = $db->fetchAssoc($query)) {
if ($row['admin_status'] == 1) {
$_SESSION['user'] = $row['admin_user'];
$_SESSION['loggedIn'] = true;
$data['adminUser'] = $row['admin_user'];
$data['adminType'] = $row['admin_type'];
$data['adminMail'] = $row['admin_mail'];
$data['adminContactMail'] = $row['admin_contactmail'];
$data['loggedIn'] = true;
/*Super admin*/
if ($row['admin_type'] == "sadmin") {
$data['message'] = "You have successfully connected and too have full access over the data";
} else {
$data['message'] = "You have successfully connected and have read-only access";
}