[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($_GET[‘course’])){
if (is_numeric($_GET[‘course’])){
$course = $_GET[‘course’];

$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_main.main_id=”.$course;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo ‘

‘.$row[‘main_name’].’

‘;
echo “

“;
while($row = $result->fetch_assoc()) {

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

“;
}
}
echo “

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

“;
}
}
} else if (isset($_GET[‘faculty’])){

$faculty = 1;

if (is_numeric($_GET[‘faculty’])){
$faculty = $_GET[‘faculty’];

}

$sql = “SELECT learning_faculties.faculty_name, learning_faculties.faculty_url FROM learning_faculties WHERE learning_faculties.faculty_id=”.$faculty;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo ‘

‘.$row[‘faculty_name’].’

Web Site: ‘.$row[‘faculty_url’].’‘;
}
}

$sql = “SELECT learning_main.main_id, learning_main.main_name FROM learning_main WHERE learning_main.main_active = 1 AND learning_main.main_faculty=”.$faculty.” ORDER BY learning_main.main_name”;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo ‘

  • ‘.$row[‘main_name’].’

    • ‘;
    }
    }
    echo ”

    “;
    } else {
    echo ‘

    Courses

    ‘;
    $sql = “SELECT * FROM learning_degrees”;
    $degrees = $conn->query($sql);
    echo ”

    “; echo “”;
    $sql = “SELECT learning_faculties.faculty_id, learning_faculties.faculty_name FROM learning_faculties ORDER BY learning_faculties.faculty_name”;
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {

    echo ”

    “;
    while($row = $result->fetch_assoc()) {
    echo “

    “;
    }
    echo “

    Faculties / Institutes Number of courses
    “.$row[‘faculty_name’].” “;
    foreach ($degrees as $degree){
    $sql = “SELECT * FROM learning_main WHERE learning_main.main_faculty=”.$row[‘faculty_id’].” AND learning_main.main_active = 1 AND learning_main.main_degree=”.$degree[“degree_id”];
    $courses = $conn->query($sql);
    echo $degree[“degree_name”];
    echo “: “;
    echo $courses->num_rows;
    echo “
    “;
    }
    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: Відділ академічної мобільності