| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Course/ |
Upload File : |
<?
// Course/courseInstructorInfo.phpinc
$Instructor = array();
if ( isset($v_currentPath[1]) ) {
$query = "
SELECT user.userId,
userFirstName,
userLastName
FROM `user`
INNER JOIN `useruserpermission` ON useruserpermission.userId = user.userId
WHERE CONCAT(userFirstName,userLastName) = '".$v_currentPath[1]."'
";
$userResult = query_do($query);
$userResultCount = $_SESSION['qry']['count'];
if ($userResultCount != 1) {
$query = "
SELECT user.userId,
userNickname,
userLastName
FROM `user`
INNER JOIN `useruserpermission` ON useruserpermission.userId = user.userId
WHERE CONCAT(userNickname,userLastName) = '".$v_currentPath[1]."'
";
$userResult = query_do($query);
$userResultCount = $_SESSION['qry']['count'];
if ($userResultCount != 1) {
$userRow = '';
$f_error = 'error_message_goes_here.<span class="pv_fl"> '.basename(__FILE__).':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
include('common/pageFooter.phpinc');
} else {
// Instructor is userNickname userLastName
mysqli_data_seek($userResult, 0);
$userRow = mysqli_fetch_assoc($userResult);
$Instructor['Id'] = $userRow['userId'];
$Instructor['Name'] = $userRow['userNickname'].' '.$userRow['userLastName'];
$Instructor['Firstname'] = $userRow['userNickname'];
$Instructor['Lastname'] = $userRow['userLastName'];
}
} else {
// Instructor is userFirstName userLastName
mysqli_data_seek($userResult, 0);
$userRow = mysqli_fetch_assoc($userResult);
$Instructor['Id'] = $userRow['userId'];
$Instructor['Name'] = stripslashes($userRow['userFirstName'].' '.$userRow['userLastName']);
$Instructor['Firstname'] = $userRow['userFirstName'];
$Instructor['Lastname'] = $userRow['userLastName'];
}
} else {
$Instructor['Id'] = '';
$Instructor['Name'] = 'UNKNOWN';
$Instructor['Firstname'] = '';
$Instructor['Lastname'] = '';
}
$Instructor['Path'] = str_replace(' ','',$Instructor['Name']);
printVar('$Instructor',$Instructor);
?>