{"id":1711,"date":"2017-03-15T02:14:24","date_gmt":"2017-03-15T00:14:24","guid":{"rendered":"http:\/\/mobility.univ.kiev.ua\/?page_id=1711"},"modified":"2020-04-13T01:42:32","modified_gmt":"2020-04-12T23:42:32","slug":"courses","status":"publish","type":"page","link":"http:\/\/mobility.knu.ua\/?page_id=1711&lang=en","title":{"rendered":""},"content":{"rendered":"[insert_php]\n$conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);<\/p>\n

if ($conn->connect_error) {
\ndie(“Connection failed: ” . $conn->connect_error);
\n}
\n$conn->set_charset(“utf8”);
\nmysql_set_charset(‘utf8’);<\/p>\n

if (isset($_GET[‘course’])){
\nif (is_numeric($_GET[‘course’])){
\n$course = $_GET[‘course’];<\/p>\n

$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
\nFROM learning_main
\nLEFT JOIN learning_faculties
\nON learning_main.main_faculty=learning_faculties.faculty_id
\nLEFT JOIN learning_language
\nON learning_main.main_language=learning_language.language_id
\nLEFT JOIN learning_degrees
\nON learning_main.main_degree=learning_degrees.degree_id
\nWHERE learning_main.main_active = 1 AND learning_main.main_id=”.$course;
\n$result = $conn->query($sql);
\nif ($result->num_rows > 0) {
\necho ‘<\/p>\n

‘.$row[‘main_name’].’<\/h1>\n

‘;
\necho “<\/p>\n\n“;
\nwhile($row = $result->fetch_assoc()) {<\/p>\n

foreach ($row as $key => $value){ if ($value != “”) {echo “”;}
\n echo “<\/p>\n

\n
“.key_translate($key).”<\/td>\n“.value_translate($key, $value).”<\/td>\n<\/tr>\n

“;
\n}
\n}
\necho “<\/tbody>\n<\/table>\n

“;
\n}
\n}
\n} else if (isset($_GET[‘faculty’])){<\/p>\n

$faculty = 1;<\/p>\n

if (is_numeric($_GET[‘faculty’])){
\n$faculty = $_GET[‘faculty’];<\/p>\n

}<\/p>\n

$sql = “SELECT learning_faculties.faculty_name, learning_faculties.faculty_url FROM learning_faculties WHERE learning_faculties.faculty_id=”.$faculty;
\n$result = $conn->query($sql);
\nif ($result->num_rows > 0) {
\nwhile($row = $result->fetch_assoc()) {
\necho ‘<\/p>\n

‘.$row[‘faculty_name’].’<\/h1>\n

Web Site: ‘.$row[‘faculty_url’].’<\/a>‘;
\n}
\n}<\/p>\n

$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”;
\n$result = $conn->query($sql);
\nif ($result->num_rows > 0) {
\n\twhile($row = $result->fetch_assoc()) {
\n\t\techo ‘<\/p>\n

  • ‘.$row[‘main_name’].’<\/a><\/li>\n

    ‘;
    \n}
    \n}
    \necho ”<\/p>\n

    “;
    \n} else {
    \necho ‘<\/p>\n

    Courses<\/h1>\n

    ‘;
    \n$sql = “SELECT * FROM learning_degrees”;
    \n$degrees = $conn->query($sql);
    \necho ”<\/p>\n

    “; echo “”;
    \n$sql = “SELECT learning_faculties.faculty_id, learning_faculties.faculty_name FROM learning_faculties ORDER BY learning_faculties.faculty_name”;
    \n$result = $conn->query($sql);
    \nif ($result->num_rows > 0) {<\/p>\n

    \techo ”<\/p>\n\n\n\n\n
    Faculties \/ Institutes<\/strong><\/td>\nNumber of courses<\/strong><\/td>\n<\/tr>\n

    “;
    \nwhile($row = $result->fetch_assoc()) {
    \necho “<\/p>\n

    “.$row[‘faculty_name’].”<\/a><\/td>\n“;
    \nforeach ($degrees as $degree){
    \n$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”];
    \n$courses = $conn->query($sql);
    \necho $degree[“degree_name”];
    \necho “: “;
    \necho $courses->num_rows;
    \necho “
    “;
    \n}
    \necho “<\/td>\n<\/tr>\n

    “;
    \n}
    \necho “<\/tbody>\n<\/table>\n

    “;
    \n}
    \n}
    \n$conn->close();<\/p>\n

    function key_translate($key1) {
    \n$key2 = “”;
    \nif($key1 ==”main_name”) $key2 = “Descipline”;
    \nif ($key1 ==”faculty_name”) $key2 = “Faculty”;
    \nif ($key1 ==”faculty_url”) $key2 = “Faculty URL”;
    \nif ($key1 ==”language_name”) $key2 = “Language”;
    \nif ($key1 ==”degree_name”) $key2 = “Degree”;
    \nif ($key1 ==”main_credits”) $key2 = “Credits”;
    \nif ($key1 ==”main_semester”) $key2 = “Semester”;
    \nif ($key1 ==”main_description”) $key2 = “Description”;
    \nif ($key1 ==”main_teachers”) $key2 = “Teachers”;
    \nif ($key2 == “”) return $key1;
    \nreturn $key2;
    \n}<\/p>\n

    function value_translate($key1, $value1) {
    \nif ($key1 ==”faculty_url”){
    \n$value1 = ““.$value1.”<\/a>“;
    \n}
    \nif ($key1 ==”main_name”){
    \n$value1 = ““.$value1.”<\/b>“;
    \n}
    \nreturn $value1;
    \n}<\/p>\n[\/insert_php]\n","protected":false},"excerpt":{"rendered":"

    [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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1711","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/mobility.knu.ua\/index.php?rest_route=\/wp\/v2\/pages\/1711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/mobility.knu.ua\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/mobility.knu.ua\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/mobility.knu.ua\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/mobility.knu.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1711"}],"version-history":[{"count":0,"href":"http:\/\/mobility.knu.ua\/index.php?rest_route=\/wp\/v2\/pages\/1711\/revisions"}],"wp:attachment":[{"href":"http:\/\/mobility.knu.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}