PHP basis_db::db_db_last_error Beispiele

Beispiel #1

Datei: studenten_liste_export.php Projekt: andikoller/FHC-3.0-FHBGLD

    $name = 'modul_id' . $einheitid . '.txt';
}
header("Content-disposition: filename={$name}");
header("Content-type: application/octetstream");
header("Pragma: no-cache");
header("Expires: 0");
// doing some DOS-CRLF magic...
$crlf = "\n";
$client = getenv("HTTP_USER_AGENT");
if (ereg('[^(]*\\((.*)\\)[^)]*', $client, $regs)) {
    $os = $regs[1];
    // this looks better under WinX
    if (eregi("Win", $os)) {
        $crlf = "\r\n";
    }
}
if (isset($stgid)) {
    $sql_query = 'SELECT uid, nachname, vorname FROM campus.vw_student ' . 'WHERE studiengang_kz=' . $stgid . ' AND semester=' . $sem . ' AND verband=\'' . strtoupper($ver) . '\' AND gruppe=' . $grp . ' ORDER BY nachname';
}
if (isset($einheitid)) {
    $sql_query = 'SELECT uid, nachname, vorname FROM campus.vw_benutzer JOIN tbl_benutzergruppe USING(uid) WHERE gruppe_kurzbz=\'' . $einheitid . '\' ORDER BY nachname';
}
//echo $sql_query;
if (!($result = $db->db_query($sql_query))) {
    die($db->db_db_last_error());
}
$anz = $db->db_num_rows($result);
for ($j = 0; $j < $anz; $j++) {
    $row = $db->db_fetch_object($result, $j);
    echo '#' . $row->nachname . ' ' . $row->vorname . $crlf . $row->uid . $crlf;
}