function db_foreign_courses_for_an_exchange($idtv, $as_array = FALSE) { global $link; mysqli_set_charset($link, "utf8"); $stmnt = $link->stmt_init(); $stmnt->prepare('SELECT ID, CODE, NAME, CREDITS, GRADE, COURSE_TYPE FROM STUDENT_FOREIGN_SUBJECTS WHERE STUDENT_FOREIGN_SUBJECTS.ID_EXCHANGE=?'); $stmnt->bind_param('i', $idtv); $stmnt->execute(); $cs = $stmnt->get_result(); if ($as_array) { $csdata = array(); } else { $csdata = ""; } if ($cs != NULL) { while ($rw = $cs->fetch_row()) { if ($as_array) { $csdata[] = array($rw[0], $rw[1], $rw[2], $rw[3], $rw[4], array($rw[5], course_type($rw[5]))); } else { if (strlen($rw[4]) > 0) { $grd = ', grade: ' . $rw[4] . ' '; } else { $grd = ' '; } $csdata = $csdata . $rw[2] . ' (' . $rw[1] . '), ' . $rw[3] . ' credits' . $grd . course_type($rw[5]) . "<br />\n"; } } } $stmnt->close(); return $csdata; }
function print_foreign_courses($idex, $max) { global $link; $stm = $link->stmt_init(); $stm->prepare('SELECT NAME, CODE, CREDITS, GRADE, COURSE_TYPE FROM STUDENT_FOREIGN_SUBJECTS WHERE ID_EXCHANGE=?'); $stm->bind_param('i', $idex); $stm->execute(); $st = $stm->get_result(); $cnt = 0; while ($rw = $st->fetch_row()) { print ',"' . ddq($rw[0]) . '","' . ddq($rw[1]) . '",' . $rw[2] . ',"' . ddq($rw[3]) . '","' . course_type($rw[4]) . '"'; $cnt++; } while ($cnt++ < $max) { print ',"","","","",""'; } $stm->close(); }