$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 ("

Bibliografie-Datenbank \"Konnektoren im Deutschen\"

\n"); print ("

Ergebnis der Datenbankanfrage

\n"); $db_serv = 'localhost'; $db_user = 'anonymous'; $db_pass = 'anonymous'; $database = $_GET[database]; $table = $_GET[table]; $autor = $_GET[autor]; $titel = $_GET[titel]; $jahr = $_GET[jahr]; $schlagwort = $_GET[schlagwort]; $sprache = $_GET[sprache]; $konnektor = $_GET[konnektor]; $id = $_GET[id]; $maxnum = $_GET[maxnum]; $sort = $_GET[sort]; $maxhits = $_GET[maxhits]; $db = mysql_connect($db_serv, $db_user, $db_pass) or die('ERROR!'); mysql_select_db($database, $db) or die('ERROR!'); mysql_set_charset ("latin1"); set_query (); if ( $id == 0 ) { $result = mysql_query ("SELECT COUNT(*) FROM $table WHERE $query"); $data = mysql_fetch_row($result); $maxnum = $data[0]; mysql_free_result ($result); } if ( $sort == "alpha" ) $orderlist = "autor,jahr DESC,titel"; else if ( $sort == "chrono" ) $orderlist = "jahr DESC,autor,titel"; if ( $maxhits < 10 ) $maxhits = 10; $range = $maxhits + 1; $result = mysql_query ("SELECT * FROM $table WHERE $query ORDER BY $orderlist LIMIT $id,$range"); $num = 0; if ( $result != "" ) $num = mysql_num_rows($result); set_id ($id); show_result_header (); if ( $num != 0 ) { $count = 1; show_links ($start_id, $maxnum); print ("
\n"); while ( $count <= $maxhits && $count <= $num ) { show_results (); $count++; } mysql_free_result ($result); print ("
\n"); show_links ($start_id, $maxnum); } mysql_close ($db); ?>