prepare("SELECT id, userrole, username, user_groups FROM app_users WHERE BINARY username = ?"); $querygr->bind_param("s", $username); $querygr->execute(); $querygrres = $querygr->get_result()->fetch_assoc(); $userrole = $querygrres['userrole']; if ($userrole != 'superadmin') { $usergroupsall = $querygrres['user_groups']; $usergroupsarr = explode("|", $usergroupsall); array_shift($usergroupsarr); array_pop($usergroupsarr); // Get the list of groups whose users have access to the current audio conference $querycont = $mysqli->prepare("SELECT id, audio_conf_extension, limit_to_groups FROM conferences_audio WHERE audio_conf_extension = ?"); $querycont->bind_param("s", $aconfExtension); $querycont->execute(); $querytcagr = $querycont->get_result()->fetch_assoc(); $querytcagrlst = $querytcagr['limit_to_groups']; $querytcagrarr = explode("|", $querytcagrlst); array_shift($querytcagrarr); array_pop($querytcagrarr); $chck = 0; foreach ($usergroupsarr as $key => $arrval) { if (in_array($arrval, $querytcagrarr)) { $chck++; } } if ($chck > 0) { $messagetosend = 'success'; } else { $messagetosend = 'failure'; } } else { $messagetosend = 'success'; } $response = array('result' => $messagetosend); echo json_encode($response); } else { header("Location: ../login.php"); } ?>