opat vyhladavanie

$dia = "áäčďéíľĺňóôŕšťúýÁČĎÉÍĽĹŇÓŠŤÚÝŽ";
$nodia = "aacdeillnoorstuyacdeillnostuyz";

$convtbl_search = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z');

$convtbl_replace = array('[aáäAÁ]', '[bB]', '[cčCČ]', '[dďDĎ]', '[eéEÉ]', '[fF]', '[gG]', '[hH]', '[iíIÍ]', '[jJ]', '[kK]', '[lľĺLĽĹ]', '[mM]', '[nN]', '[oóôOÓ]', '[pP]', '[qQ]', '[rŕRŔ]', '[sšSŠ]', '[tťTŤ]', '[uúUÚ]', '[vV]', '[wW]', '[xX]', '[yýYÝ]', '[zžZŽ]');

$search = strtr($search, $dia, $nodia);
$regexp = str_replace($convtbl_search, $convtbl_replace, $search);

$hladat=mysql_query("SELECT * FROM tabulka  WHERE nazov LIKE  '%".$search."%' OR text LIKE '%".$search."%'");

$zaznam=eregi_replace( $search,'<strong>'.$search.'</strong>',$zaznam);

function TextToRegtext($text)
  // funkcia prekonvertuje vstupny text po jednom znaku tak ze vzhlada vstupny
  // znak v $sources a do vystupu zapise jeho ekvivalent z $replace. Ak znak nenajde
  // do vystupu zapise zdrojovy znak
  {
    $sources = array("aáäAÁÄ","bB","cCčČ","dDďĎ","eéeëEÉEË",
                     "fF","gG","hH","iIíÍ","jJ","kK","lĺľLĹĽ",
                     "mM","nN","oóöôOÓÖÔ","pP","qQ","rŕřRŔŘ",
                     "sšSŠ","tťTŤ","uúuüUÚUÜ","vV","wW","xX",
                     "yýYÝ","zžZŽ");
    $replace = array("[a,á,ä,A,Á,Ä]","[b,B]","[c,C,č,Č]","[d,D,ď,Ď]","[e,é,e,ë,E,É,E, Ë]",
                     "[f,F]","[g,G]","[h,H]","[i,I,í,Í]","[j,J]","[k,K]","[l,ĺ,ľ,L,Ĺ,Ľ]",
                     "[m,M]","[n,N]","[o,ó,ö,ô,O,Ó,Ö,Ô]","[p,P]","[q,Q]","[r,ŕ,ř,R,Ŕ,Ř]",
                     "[s,š,S,Š]","[t,ť,T,Ť]","[u,ú,u,ü,U,Ú,U,Ü]","[v,V]","[w,W]","[x,X]",
                     "[y,ý,Y,Ý]","[z,ž,Z,Ž]"); 
    $regtext = "";
    for ($j = 0; $j < mb_strlen($text,'UTF-8'); $j++)
    {
      for ($k = 0; $k < count($sources); $k++)
      {
        $Decoded = false;
        if (mb_stristr($sources[$k], mb_substr($text,$j,1,'UTF-8')) != false)
        {
          $regtext = $regtext.$replace[$k];       
          $Decoded = true;
          break;
        }     
      }
      if (!$Decoded)
      {
        $regtext = $regtext."[".mb_substr($text,$j,1,'UTF-8')."]";
      }     
    }
    return $regtext.""; 
  }

SELECT * FROM tabulka WHERE text REGEXP '$regexp'

eregi_replace($regexp, '<strong>\\0</strong>', $zaznam);

SELECT * FROM tabulka WHERE text REGEXP '$regexp'

SELECT * FROM tabulka WHERE text REGEXP 'SELECT * FROM tabulka WHERE text REGEXP '%$regexp%'

$hladat=mysql_query("SELECT * FROM tabulka WHERE text REGEXP '$regexp' COLLATE 'utf8_general_ci' ");

$hladat="hladaj"; //vloz hladany retazec bez diakritiky
$text="Ano, hladaj skrikol dedo.";// tu je ta duplicita textu z DB bez dia
$text_o="Áno, hľadaj skríkol dedo.";// text z DB s diakritikou
$a=explode(' ',$text);
$b=explode(' ',$text_o);


for ($i=0; $i<=count($a); $i++)
  {
     if (strtolower($hladat)==strtolower($a[$i]))  $b[$i]="<b>$b[$i]</b>" ;                                                                                           $b[i]="<b>$b[i]</b>";
$vysledok=$vysledok." ".$b[$i];
trim($vysledok);
                                                                                                           
  }
  echo  "$vysledok";

Fatal error: Maximum execution time of 5 seconds exceeded in domains/.....

$zaznam=ereg_replace( $search,'<strong>'.$search.'</strong>',$zaznam);

$zaznam = "misko miško michal mískó MÍško";
$search = "misko";  //hladany vyraz
$regexp = "m[ií][sš]k[oó]"; //regexp zo $search

echo eregi_replace($regexp, '<strong>\\0</strong>', $zaznam);