public function getUserSessionData($id) { global $db; global $dbhost; global $dbpassword; global $dbuser; try { $adminemail = $admin = $_SESSION['admin_login']; $getDbName = "select `admindatabase` from `admin_database_info` WHERE `email` = '" . $adminemail . "' AND `is_active`=1"; $daName = $db->get_col($getDbName); $dbUser = new ezSQL_mysql($dbuser, $dbpassword, $daName[0], $dbhost); $query = 'SELECT `uniqueCode` FROM `user_info` WHERE id=' . $id; $result = $dbUser->get_col($query); $getSession = "SELECT * FROM `user_session_details` WHERE `grcid` ='" . $result[0] . "'"; $sessionList = $dbUser->get_results($getSession, ARRAY_A); return $sessionList; } catch (Exception $e) { $msg = $e->getMessage(); return FALSE; } }