include 'func4search.php'; // zjisti, zda je uzivatel prihlasen /* Připojení, výběr databáze */ $link = mysql_connect($server, $uziv_jmeno, $server_heslo) or die("Nelze se připojit: " . mysql_error()); mysql_select_db($databaze) or die("Nelze vybrat databázi"); if($pismeno == "Ch") { $pismeno1=$pismeno . "%"; $pismeno2= "%– " . $pismeno . "%"; $query = "SELECT * FROM Data WHERE `author` like '$pismeno1' OR `author` like '$pismeno2'"; $query = $query . "ORDER BY `author`, `year`, `fasc`, `page`"; } elseif($pismeno == "C") { $pismeno1=$pismeno . "%"; $pismeno2= "%– " . $pismeno . "%"; $pismeno3= "Č" . "%"; $pismeno4= "%– " . "Č" . "%"; $query = "SELECT * FROM Data WHERE (`author` like '$pismeno1' OR `author` like '$pismeno2' OR `author` like '$pismeno3' OR `author` like '$pismeno4') AND `author` NOT REGEXP '^Ch'"; $query = $query . "ORDER BY `author`, `year`, `fasc`, `page`"; } elseif($pismeno == "S") { $pismeno1=$pismeno . "%"; $pismeno2= "%– " . $pismeno . "%"; $pismeno3= "Š" . "%"; $pismeno4= "%– " . "Š" . "%"; $query = "SELECT * FROM Data WHERE `author` like '$pismeno1' OR `author` like '$pismeno2' OR `author` like '$pismeno3' OR `author` like '$pismeno4'"; $query = $query . "ORDER BY `author`, `year`, `fasc`, `page`"; } elseif($pismeno == "R") { $pismeno1=$pismeno . "%"; $pismeno2= "%– " . $pismeno . "%"; $pismeno3= "Ř" . "%"; $pismeno4= "%– " . "Ř" . "%"; $query = "SELECT * FROM Data WHERE `author` like '$pismeno1' OR `author` like '$pismeno2' OR `author` like '$pismeno3' OR `author` like '$pismeno4'"; $query = $query . "ORDER BY `author`, `year`, `fasc`, `page`"; } else { $pismeno1=$pismeno . "%"; $pismeno2= "%– " . $pismeno . "%"; $query = "SELECT * FROM Data WHERE `author` like '$pismeno1' OR `author` like '$pismeno2'"; $query = $query . "ORDER BY `author`, `year`, `fasc`, `page`"; } /* else $query = "SELECT * FROM Data WHERE 0"; */ $result = mysql_query($query) or die("Dotaz nelze provést: " . mysql_error()); $zaznamu = mysql_NumRows($result); mysql_close($link); ?>
|
etnografický časopis |
||||||||||||||||||||||||||
|
/* Zobrazení výsledku v HTML */ print "
|
||||||||||||||||||||||||||