if($_POST['q']){ $q=$_POST['q']; }else{ $q=$_GET['q']; } $win=array('±','¶','Ľ','ˇ','¦','¬'); $iso=array('±','¶','Ą','·','¦','¬'); function dopasuj_do_bazy($q){ global $win; global $iso; $male=array('q','w','e','r','t','y','u','i','o','p','a','s','d','f','g','h','j','k','l','z','x','c','v','b','n','m'); $duze=array('Q','W','E','R','T','Y','U','I','O','P','A','S','D','F','G','H','J','K','L','Z','X','C','V','B','N','M'); $q=str_replace($iso,$win,$q); $q=explode(" ", $q); $i=0; while($q[$i]){ $ret .= str_replace($male,$duze,substr($q[$i],0,1)).str_replace($duze,$male,substr($q[$i],1))." "; $i++; } return substr($ret,0,strlen($ret)-1); } include "config.php" $err="Proszę wprowadzić rok w formie RRRR lub imię i nazwisko"; $err2="Nie znaleziono nikogo takiego w bazie"; $sql = mysql_connect ($db_host, $db_user, $db_pass); mysql_select_db($db_name); if($q){ if(!ereg("[0-9]", $q)){ $q=explode(" ", dopasuj_do_bazy($q)); $query = "SELECT * FROM `absolwenci` WHERE (`IMIE` LIKE '".$q[0]."%' || `NAZWISKO` LIKE '".$q[0]."%')"; $i=1; while($q[$i]){ $query .= "&& (`IMIE` LIKE '".$q[$i]."%' || `NAZWISKO` LIKE '".$q[$i]."%')"; $i++; } }elseif(ereg("[0-9]{4}", $q)){ $query = "SELECT * FROM `absolwenci` WHERE `ROK` = '".$q."' "; }else{ die($err); } unset($txt); $query_exec = mysql_query($query); while($line = mysql_fetch_array($query_exec)){ $txt .= "