FM / Teacher

/home/techb158/workloadmatch.com/workloadmatch.com/Teacher/

/home/techb158/workloadmatch.com/workloadmatch.com/Teacher

Name	Size	Mode	Actions
Inc/	-	0755	rm
accounting - Backup.php	20803	0644	edit dl rm
accounting.php	21931	0644	edit dl rm
addclient.php	12317	0644	edit dl rm
changestatus.php	893	0644	edit dl rm
checkAvailability.php	875	0644	edit dl rm
dashboard.php	10802	0644	edit dl rm
error_log	10045	0644	edit dl rm
followup.php	21362	0644	edit dl rm
footer.php	15810	0644	edit dl rm
getlang.php	294	0644	edit dl rm
index2.php	20114	0644	edit dl rm
main-header-inc.php	1052	0644	edit dl rm
main-header.php	6588	0644	edit dl rm
profile.php	17750	0644	edit dl rm
reference - Copy.php	24726	0644	edit dl rm
reference.php	21534	0644	edit dl rm
reference_list.php	5696	0644	edit dl rm
reference_reports.php	9707	0644	edit dl rm
reports.php	21223	0644	edit dl rm
secretarial.php	21525	0644	edit dl rm
selectbrokers.php	4122	0644	edit dl rm
selectTransactionType.php	571	0644	edit dl rm
Transaction_Type.php	1344	0644	edit dl rm
updateclient.php	14089	0644	edit dl rm
updatereference.php	32134	0644	edit dl rm
Update_Reference_Follow_Up.php	7384	0644	edit dl rm
users.php	4919	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/workloadmatch.com/Teacher/selectbrokers.php (4122B)

<?php
include_once '../includes/db_connect.php';
include_once '../includes/functions.php';

sec_session_start();
  
   
   $Client_ID=$_POST['subId'];     // selected course id here 
   
   if(isset($Client_ID) && $Client_ID!=""){
	   
	
	$user_n=$_SESSION['user_id'];

$stmt = $mysqli->prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?');  
		$stmt->bind_param('s', $user_n);  
		$stmt->execute();  
		$result = $stmt->get_result(); 
		$row = $result->fetch_assoc();
		$count =$result->num_rows;	
		
		
		if($count > 0)
		{	
		$querys = "SELECT * FROM Broker_Profile Where Broker_ID='".$user_n."'";	
		$results = $mysqli->query($querys);	
		$rows = $results->fetch_assoc();
		$Admin_ID = $rows['Admin_ID'];
		$Master_ID = $rows['Master_ID'];
		$Broker_ID = $rows['Broker_ID'];
		$Manager_ID = $rows['Manager_ID'];
		$Manager_ID_Profile = $rows['Manager_ID'];
		$Category_ID = $rows['Category_ID'];
		$Show_Other = $rows['Show_Other'];
		
	if($Category_ID != $Client_ID)
	{
		$query = "SELECT BF.Manager_ID,BF.Company_Name FROM Manager_Profile BF JOIN Link_Manager_To_Manager MG ON BF.Admin_ID=MG.Admin_ID AND BF.Master_ID=MG.Master_ID AND BF.Manager_ID=MG.Manager_B_ID where MG.Manager_A_ID='".$Manager_ID."' AND MG.Action=1";	
		$result = $mysqli->query($query);		
		$_ResultSet = array();
    while ($row = $result->fetch_assoc()) {
       $_ResultSet[] = $row;
    }
	
	
	$queryns = "SELECT MG.Manager_ID,MG.Company_Name,UA.Access_Category_ID, UA.Category_ID,CA.Category_Type,UA.Manager_ID,UA.Broker_ID,UA.User_Access_Category_ID from Categories CA JOIN User_Access_Categories UA ON CA.Category_ID=UA.User_Access_Category_ID JOIN Manager_Profile MG ON UA.Manager_ID=MG.Manager_ID Where UA.Admin_ID ='".$Admin_ID."' AND UA.Master_ID ='".$Master_ID."' AND UA.Manager_ID ='".$Manager_ID."' AND UA.Broker_ID='".$Broker_ID."' AND UA.Category_ID !='0' AND UA.User_Access_Category_ID !='0' Group By UA.Access_Category_ID";
		$resultsr = $mysqli->query($queryns);		
		//$_ResultSet = array();
    while ($rowsr = $resultsr->fetch_assoc()) {
       $_ResultSet[] = $rowsr;
    }

echo json_encode($_ResultSet);
		
	/* 
	$query = "SELECT BF.Broker_ID,BF.First_Name,BF.Last_Name FROM Broker_Profile BF JOIN Manager_Group_Name MG ON BF.Admin_ID=MG.Admin_ID AND BF.Master_ID=MG.Master_ID AND BF.Manager_ID=MG.Manager_ID AND BF.Manager_Group_ID=MG.Manager_Group_ID
	where BF.Category_ID='".$Client_ID."'";	
		$result = $mysqli->query($query);		
		$_ResultSet = array();
    while ($row = $result->fetch_assoc()) {
       $_ResultSet[] = $row;
    }
       echo json_encode($_ResultSet);
	   */
	
	}else{
		
	//$query = "SELECT BF.Broker_ID,BF.First_Name,BF.Last_Name,BF.Show_Other FROM Broker_Profile BF JOIN Manager_Group_Name MG ON BF.Admin_ID=MG.Admin_ID AND BF.Master_ID=MG.Master_ID AND BF.Manager_ID=MG.Manager_ID AND BF.Manager_Group_ID=MG.Manager_Group_ID where BF.Category_ID='".$Client_ID."' AND BF.Show_Other='1'";

if($Show_Other == 1)
{	
	//$query = "SELECT Manager_ID,First_Name,Last_Name FROM Broker_Profile where Admin_ID='".$Admin_ID."' AND Master_ID='".$Master_ID."' AND Manager_ID='".$Manager_ID."' AND Broker_ID !='".$Broker_ID."' AND Category_ID='".$Category_ID."' AND Show_Other='".$Show_Other."'";	
	
	$query = "SELECT Manager_ID,Company_Name FROM Manager_Profile where Admin_ID='".$Admin_ID."' AND Master_ID='".$Master_ID."' AND Manager_ID='".$Manager_ID."'";	
	
	//$query = "SELECT Manager_ID,First_Name,Last_Name FROM Broker_Profile where Admin_ID='".$Admin_ID."' AND Master_ID='".$Master_ID."' AND Manager_ID='".$Manager_ID."' AND Broker_ID !='".$Broker_ID."' AND Category_ID='".$Category_ID."'";	
	//$query = "SELECT Broker_ID,First_Name,Last_Name FROM Broker_Profile where Admin_ID='".$Admin_ID."' AND Master_ID='".$Master_ID."' AND Manager_ID='".$Manager_ID."' AND Broker_ID !='".$Broker_ID."' AND Category_ID='".$Category_ID."'";	
				
		$result = $mysqli->query($query);		
		$_ResultSet = array();	
		
    while ($row = $result->fetch_assoc()) {
       $_ResultSet[] = $row;
    }
       echo json_encode($_ResultSet);
	   
}
	}
		}
	}else
	{
		echo "Choose User";
	}		
   
   
  
?>

prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?'); $stmt->bind_param('s', $user_n); $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_assoc(); $count =$result->num_rows; if($count > 0) { $querys = "SELECT * FROM Broker_Profile Where Broker_ID='".$user_n."'"; $results = $mysqli->query($querys); $rows = $results->fetch_assoc(); $Admin_ID = $rows['Admin_ID']; $Master_ID = $rows['Master_ID']; $Broker_ID = $rows['Broker_ID']; $Manager_ID = $rows['Manager_ID']; $Manager_ID_Profile = $rows['Manager_ID']; $Category_ID = $rows['Category_ID']; $Show_Other = $rows['Show_Other']; if($Category_ID != $Client_ID) { $query = "SELECT BF.Manager_ID,BF.Company_Name FROM Manager_Profile BF JOIN Link_Manager_To_Manager MG ON BF.Admin_ID=MG.Admin_ID AND BF.Master_ID=MG.Master_ID AND BF.Manager_ID=MG.Manager_B_ID where MG.Manager_A_ID='".$Manager_ID."' AND MG.Action=1"; $result = $mysqli->query($query); $_ResultSet = array(); while ($row = $result->fetch_assoc()) { $_ResultSet[] = $row; } $queryns = "SELECT MG.Manager_ID,MG.Company_Name,UA.Access_Category_ID, UA.Category_ID,CA.Category_Type,UA.Manager_ID,UA.Broker_ID,UA.User_Access_Category_ID from Categories CA JOIN User_Access_Categories UA ON CA.Category_ID=UA.User_Access_Category_ID JOIN Manager_Profile MG ON UA.Manager_ID=MG.Manager_ID Where UA.Admin_ID ='".$Admin_ID."' AND UA.Master_ID ='".$Master_ID."' AND UA.Manager_ID ='".$Manager_ID."' AND UA.Broker_ID='".$Broker_ID."' AND UA.Category_ID !='0' AND UA.User_Access_Category_ID !='0' Group By UA.Access_Category_ID"; $resultsr = $mysqli->query($queryns); //$_ResultSet = array(); while ($rowsr = $resultsr->fetch_assoc()) { $_ResultSet[] = $rowsr; } echo json_encode($_ResultSet); /* $query = "SELECT BF.Broker_ID,BF.First_Name,BF.Last_Name FROM Broker_Profile BF JOIN Manager_Group_Name MG ON BF.Admin_ID=MG.Admin_ID AND BF.Master_ID=MG.Master_ID AND BF.Manager_ID=MG.Manager_ID AND BF.Manager_Group_ID=MG.Manager_Group_ID where BF.Category_ID='".$Client_ID."'"; $result = $mysqli->query($query); $_ResultSet = array(); while ($row = $result->fetch_assoc()) { $_ResultSet[] = $row; } echo json_encode($_ResultSet); */ }else{ //$query = "SELECT BF.Broker_ID,BF.First_Name,BF.Last_Name,BF.Show_Other FROM Broker_Profile BF JOIN Manager_Group_Name MG ON BF.Admin_ID=MG.Admin_ID AND BF.Master_ID=MG.Master_ID AND BF.Manager_ID=MG.Manager_ID AND BF.Manager_Group_ID=MG.Manager_Group_ID where BF.Category_ID='".$Client_ID."' AND BF.Show_Other='1'"; if($Show_Other == 1) { //$query = "SELECT Manager_ID,First_Name,Last_Name FROM Broker_Profile where Admin_ID='".$Admin_ID."' AND Master_ID='".$Master_ID."' AND Manager_ID='".$Manager_ID."' AND Broker_ID !='".$Broker_ID."' AND Category_ID='".$Category_ID."' AND Show_Other='".$Show_Other."'"; $query = "SELECT Manager_ID,Company_Name FROM Manager_Profile where Admin_ID='".$Admin_ID."' AND Master_ID='".$Master_ID."' AND Manager_ID='".$Manager_ID."'"; //$query = "SELECT Manager_ID,First_Name,Last_Name FROM Broker_Profile where Admin_ID='".$Admin_ID."' AND Master_ID='".$Master_ID."' AND Manager_ID='".$Manager_ID."' AND Broker_ID !='".$Broker_ID."' AND Category_ID='".$Category_ID."'"; //$query = "SELECT Broker_ID,First_Name,Last_Name FROM Broker_Profile where Admin_ID='".$Admin_ID."' AND Master_ID='".$Master_ID."' AND Manager_ID='".$Manager_ID."' AND Broker_ID !='".$Broker_ID."' AND Category_ID='".$Category_ID."'"; $result = $mysqli->query($query); $_ResultSet = array(); while ($row = $result->fetch_assoc()) { $_ResultSet[] = $row; } echo json_encode($_ResultSet); } } } }else { echo "Choose User"; } ?>