1

Learning Page

[insert_php]

$conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
$conn->set_charset(“utf8”);
mysql_set_charset(‘utf8’);

if (isset($_POST[‘faculty_name’])) { if ($_POST[‘faculty_name’] == ‘any’) { unset($_POST[‘faculty_name’]);} }
if (isset($_POST[‘language_name’])) { if ($_POST[‘language_name’] == ‘any’) { unset($_POST[‘language_name’]);} }
if (isset($_POST[‘degree_name’])) { if ($_POST[‘degree_name’] == ‘any’) { unset($_POST[‘degree_name’]);} }
if (isset($_POST[‘main_semester’])) { if ($_POST[‘main_semester’] == ‘any’) { unset($_POST[‘main_semester’]);} }

echo ‘

‘;
echo ‘

‘;

echo ‘

‘;

echo ‘

‘;

echo ‘

Choose faculty:
Choose degree:
Choose semester:
Choose language:

‘;

echo ‘

‘;

$sql = “SELECT learning_main.main_name, learning_faculties.faculty_name, learning_faculties.faculty_url, learning_language.language_name, learning_degrees.degree_name, learning_main.main_credits, learning_main.main_semester, learning_main.main_description, learning_main.main_teachers
FROM learning_main
LEFT JOIN learning_faculties
ON learning_main.main_faculty=learning_faculties.faculty_id
LEFT JOIN learning_language
ON learning_main.main_language=learning_language.language_id
LEFT JOIN learning_degrees
ON learning_main.main_degree=learning_degrees.degree_id
WHERE learning_main.main_active=1 AND learning_faculties.faculty_name=”;
if (isset($_POST[‘faculty_name’])) {$sql.=”‘”.$_POST[‘faculty_name’].”‘”;} else {$sql.=”learning_faculties.faculty_name”;}
$sql.=” AND learning_language.language_name=”;
if (isset($_POST[‘language_name’])) {$sql.=”‘”.$_POST[‘language_name’].”‘”;} else {$sql.=”learning_language.language_name”;}
$sql.=” AND learning_degrees.degree_name=”;
if (isset($_POST[‘degree_name’])) {$sql.=”‘”.$_POST[‘degree_name’].”‘”;} else {$sql.=”learning_degrees.degree_name”;}
$sql.=” AND learning_main.main_semester=”;
if (isset($_POST[‘main_semester’])) {$sql.=”‘”.$_POST[‘main_semester’].”‘”;} else {$sql.=”learning_main.main_semester”;}

$result = $conn->query($sql);

if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo “

“;
foreach ($row as $key => $value){
if ($value != “”) {echo “

“;}
}
echo “

“.key_translate($key).” “.value_translate($key, $value).”

“;
echo “

“;
}
}

$conn->close();

function key_translate($key1) {
$key2 = “”;
if($key1 ==”main_name”) $key2 = “Descipline”;
if ($key1 ==”faculty_name”) $key2 = “Faculty”;
if ($key1 ==”faculty_url”) $key2 = “Faculty URL”;
if ($key1 ==”language_name”) $key2 = “Language”;
if ($key1 ==”degree_name”) $key2 = “Degree”;
if ($key1 ==”main_credits”) $key2 = “Credits”;
if ($key1 ==”main_semester”) $key2 = “Semester”;
if ($key1 ==”main_description”) $key2 = “Description”;
if ($key1 ==”main_teachers”) $key2 = “Teachers”;
if ($key2 == “”) return $key1;
return $key2;
}

function value_translate($key1, $value1) {
if ($key1 ==”faculty_url”){
$value1 = ““.$value1.”“;
}
if ($key1 ==”main_name”){
$value1 = ““.$value1.”“;
}
return $value1;
}

[/insert_php]
Author: Відділ академічної мобільності