/home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Teacher
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Teacher/reference.php (21534B)
ImmoValet | Reference
prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?');
//$stmt->bind_param('s', $user_n);
//$stmt->execute();
//$result = $stmt->get_result();
//$count =$result->num_rows;
//$row = $result->fetch_assoc();
$stmt = $mysqli->prepare('SELECT * FROM Client_Profile WHERE Client_ID = ? AND Broker_ID = ? AND Master_ID = ? AND Manager_ID = ?');
$stmt->bind_param('ssss', $Client_Nam,$Broker_ID,$Master_ID,$Manager_ID);
$stmt->execute();
$result = $stmt->get_result();
$count =$result->num_rows;
$row = $result->fetch_assoc();
//$query = "SELECT * FROM Client_Profile Where Client_ID ='".$Client_Nam."' AND Broker_ID ='".$Broker_ID."' AND Master_ID ='".$Master_ID."' AND Manager_ID ='".$Manager_ID."'";
//$result = $mysqli->query($query);
//$row = $result->fetch_assoc();
$Titel = $row["Titel"];
$First_Name = $row["First_Name"];
$Last_Name = $row["Last_Name"];
$Email = $row["Email"];
$Address = $row["Address"];
$Home_Phone = $row["Home_Phone"];
$Cell_Phone = $row["Cell_Phone"];
}
?>
if (isset($_GET['error'])) {
$mesg= $_GET['error'];
echo "
Notification! ".$mesg."
";
}
?>
|
|
|
|
|
|
|
|
|
|
prepare('SELECT * FROM Reference_File WHERE Broker_Sender_ID = ?');
$stmt->bind_param('s', $user_n);
$stmt->execute();
$results = $stmt->get_result();
//$row = $result->fetch_assoc();
$count =$result->num_rows;
//$querys = "SELECT * FROM Reference_File Where Broker_Sender_ID ='".$user_n."'";
//$results = $mysqli->query($querys);
while($rowz = $results->fetch_assoc())
{
$Reference_ID = $rowz["Reference_ID"];
$Client_ID = $rowz["Client_ID"];
$query = "SELECT * FROM Client_Profile Where Client_ID ='".$Client_ID."' AND Deleted_Status ='0'";
$resultd = $mysqli->query($query);
$Managers = $resultd->fetch_assoc();
/////////////////////////////////////
$Category_ID = $rowz["Category_Receiver_ID"];
$query = "SELECT * from Categories WHERE Category_ID='".$Category_ID."'";
$result = $mysqli->query($query);
$Category_ID = $result->fetch_assoc();
?>
|
|
|
|
|
|
|
|
|
"> |
|
|
|
|
|
|
|
|
|
|