$range - 1 ) $end_id = $start_id + $range - 2; else $end_id = $start_id + $num - 1; } function set_query () { global $autor, $titel, $jahr, $schlagwort, $sprache, $konnektor, $query, $pr_query; if ( $autor != "" ) { $subquery = "(autor like \"%$autor%\" OR herausgeber like \"%$autor%\")"; if ( $query != "" ) { $query = "$query AND $subquery"; } else $query = "$subquery"; $pr_query = "Autor = \"$autor\""; } if ( $titel != "" ) { $subquery = "(titel like \"%$titel%\" OR titel2 like \"%$titel%\")"; if ( $query != "" ) { $query = "$query AND $subquery"; $pr_query = "$pr_query UND"; } else $query = "$subquery"; $pr_query = "$pr_query Titel = \"$titel\""; } if ( $jahr != "" ) { $subquery = "jahr like \"%$jahr%\""; if ( $query != "" ) { $query = "$query AND $subquery"; $pr_query = "$pr_query UND"; } else $query = "$subquery"; $pr_query = "$pr_query Jahr = \"$jahr\""; } if ( $schlagwort != "" ) { $subquery = "schlagwort like \"%$schlagwort%\""; if ( $query != "" ) { $query = "$query AND $subquery"; $pr_query = "$pr_query UND"; } else $query = "$subquery"; $pr_query = "$pr_query Schlagwort = \"$schlagwort\""; } if ( $sprache != "" ) { $subquery = "sprache like \"%$sprache%\""; if ( $query != "" ) { $query = "$query AND $subquery"; $pr_query = "$pr_query UND"; } else $query = "$subquery"; $pr_query = "$pr_query Sprache = \"$sprache\""; } if ( $konnektor != "" ) { $subquery = "konnektor like \"%$konnektor%\""; if ( $query != "" ) { $query = "$query AND $subquery"; $pr_query = "$pr_query UND"; } else $query = "$subquery"; $pr_query = "$pr_query Konnektor = \"$konnektor\""; } $query = utf8_encode ($query); } function show_result_header () { global $start_id, $end_id, $pr_query, $num, $maxnum, $sort; printf ("
Datenbankanfrage: %s
\n", $pr_query); print (""); if ( $num == 0 ) print ("Es wurden keine Datensätze gefunden."); else if ( $num == 1 ) printf ("Datensatz: %d von %d", $start_id + 1, $end_id + 1); else printf ("Datensätze: %d - %d von %d", $start_id + 1, $end_id + 1, $maxnum); if ( $num > 0 && $maxnum > 1 ) { if ( $sort == "alpha" ) print (", Sortierung: alphabetisch"); else if ( $sort == "chrono" ) print (", Sortierung: chronologisch"); } print ("
\n"); } function show_results () { global $result; $data = mysql_fetch_array($result); print ("\n");
if ( $data[autor] != "" ) {
printf ("%s", utf8_decode($data[autor]));
if ( $data[herausgeber] != NULL && $data[titel1] == "" )
print (" (Hg.)");
print ("");
}
if ( $data[jahr] != "" )
printf (" (%s)", $data[jahr]);
print (": ");
/*
if ( $data[autor] != "" )
printf ("%s\n", $data[autor]);
else
printf ("%s (Hg.)\n", $data[herausgeber]);
if ( $data[jahr] != "" )
printf ("(%s)", $data[jahr]);
print (": ");
*/
if ( $data[titel] != "" ) {
printf ("%s", utf8_decode($data[titel]));
if ( ereg ("[?!\.]$", $data[titel]) || ereg ("[?!]\"$", $data[titel]) )
print (" ");
else
print (". ");
}
if ( $data[titel1] != "" ) {
if ( $data[herausgeber] != "" )
printf ("In: %s (Hg.): %s", utf8_decode($data[herausgeber]), utf8_decode($data[titel1]));
else
printf ("In: %s", utf8_decode($data[titel1]));
if ( $data[jahrgang] != "" ) {
printf (" %s", utf8_decode($data[jahrgang]));
if ( $data[heft] != "" )
printf ("/%s", utf8_decode($data[heft]));
}
print (".\n");
}
/*
if ( $data[thesis] != "" ) {
printf ("%s", utf8_decode($data[thesis]));
if ( $data[ort] != "" )
printf (" %s", utf8_decode($data[ort]));
} else */
if ( $data[ort] != "" )
printf ("%s", utf8_decode($data[ort]));
if ( $data[verlag] != "" ) {
if ( $data[ort] != "" )
printf (": %s", utf8_decode($data[verlag]));
else
printf ("%s", utf8_decode($data[verlag]));
if ( ! ereg ("\.$", $data[verlag]) )
print (".");
}
if ( $data[seiten] != "" )
printf (" S. %s.\n", $data[seiten]);
if ( $data[reihe] != "" ) {
printf (" (%s", utf8_decode($data[reihe]));
if ( $data[bandnr] != "" )
printf (" %s", utf8_decode($data[bandnr]));
print (")\n");
}
if ( $data[url] != "" )
printf ("
%s\n", $data[url], $data[url]);
print ("
\n\n"); } function show_links ($id, $maxnum) { global $database, $table, $autor, $titel, $jahr, $schlagwort, $sprache, $konnektor, $sort, $maxhits; if ( $_SERVER[DOCUMENT_ROOT] == "/httpd/htdocs" ) { $homefile = "anfrage.html"; $phpfile = "konn1.html"; } else { $homefile = "anfrage.html"; $phpfile = "konn1.phtml"; } print ("
\n"); $count = 0; $page = 1; if ( $id > 0 ) printf ("< \n", $phpfile, $id - $maxhits); while ( $count < $maxnum ) { if ( $count == $id ) printf ("%d \n", $page); else printf ("%d \n", $phpfile, $page); $count += $maxhits; $page++; } if ( $id + $maxhits < $maxnum ) printf ("> \n", $phpfile, $id + $maxhits); printf ("| Neue Datenbankanfrage\n", $homefile); print ("
\n"); } print ("