Exemple #1
0
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;
}
Exemple #2
0
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();
}