"index.php", "name" => get_lang('MySpace'));
Display :: display_header($nameTools);
api_display_tool_title($nameTools);
// Database Table Definitions
$tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
$tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
$tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
$tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
$tbl_session_rel_user = Database :: get_main_table(TABLE_MAIN_SESSION_USER);
/**
* MAIN PART
*/
if (isset($_POST['export'])) {
$is_western_name_order = api_is_western_name_order(PERSON_NAME_DATA_EXPORT);
} else {
$is_western_name_order = api_is_western_name_order();
}
$sort_by_first_name = api_sort_by_first_name();
$order_clause = $sort_by_first_name ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname';
if (isset($_GET["teacher_id"]) && $_GET["teacher_id"] != 0) {
$teacher_id = $_GET["teacher_id"];
$sql_formateurs = "SELECT user_id,lastname,firstname,email
FROM $tbl_user
WHERE user_id='$teacher_id'".$order_clause;
} else {
$sql_formateurs = "SELECT user_id,lastname,firstname,email
FROM $tbl_user
WHERE status = 1".$order_clause;
}
$result_formateurs = Database::query($sql_formateurs, __FILE__, __LINE__);
if ($is_western_name_order) {
echo '
'.get_lang('FirstName').' | '.get_lang('LastName').' | '.get_lang('Email').' | '.get_lang('AdminCourses').' | '.get_lang('Students').' |
';
} else {
echo ''.get_lang('LastName').' | '.get_lang('FirstName').' | '.get_lang('Email').' | '.get_lang('AdminCourses').' | '.get_lang('Students').' |
';
}
if ($is_western_name_order) {
$header[] = get_lang('FirstName', '');
$header[] = get_lang('LastName', '');
} else {
$header[] = get_lang('LastName', '');
$header[] = get_lang('FirstName', '');
}
$header[] = get_lang('Email', '');
$data = array();
if (Database::num_rows($result_formateurs) > 0) {
$i = 1;
while ($formateurs = Database::fetch_array($result_formateurs)) {
$user_id = $formateurs["user_id"];
$lastname = $formateurs["lastname"];
$firstname = $formateurs["firstname"];
$email = $formateurs["email"];
if ($i % 2 == 0) {
$css_class = "row_odd";
if ($i % 20 == 0 && $i != 0) {
if ($is_western_name_order) {
echo ''.get_lang('FirstName').' | '.get_lang('LastName').' | '.get_lang('Email').' | '.get_lang('AdminCourses').' | '.get_lang('Students').' |
';
} else {
echo ''.get_lang('LastName').' | '.get_lang('FirstName').' | '.get_lang('Email').' | '.get_lang('AdminCourses').' | '.get_lang('Students').' |
';
}
}
} else {
$css_class = "row_even";
}
$i++;
if ($is_western_name_order) {
$data[$user_id]["firstname"] = $firstname;
$data[$user_id]["lastname"] = $lastname;
} else {
$data[$user_id]["lastname"] = $lastname;
$data[$user_id]["firstname"] = $firstname;
}
$data[$user_id]["email"] = $email;
if ($is_western_name_order) {
echo ''.$firstname.' | '.$lastname.' | '.$email.' | .'2rightarrow.gif) | .'2rightarrow.gif) |
';
} else {
echo ''.$lastname.' | '.$firstname.' | '.$email.' | .'2rightarrow.gif) | .'2rightarrow.gif) |
';
}
}
} else {
// No results
echo ''.get_lang("NoResults").' |
';
}
echo '
';
if (isset($_POST['export'])) {
export_csv($header, $data, 'teachers.csv');
}
echo "
";
echo "