source: Search.php

<?php
  //hlavièka
  include 'includes/Global.php';
  
  /* tabulky v kterých se má hledat:
    articles- Name, Description, TextWithoutTags
    news- Name, Description, Text, User
    downloaddir- Name, Description
    downloadfile- Name, Description, FileName
    links- Name, Description, Address
    picturealbums- Name, Description
    pictures- FileName
    section- Name, Description
  */
    
  //TODO: mozila plugin

  if (array_key_exists('Search', $_GET)){
    $SearchOrig = $_GET['Search'];
  } else {
    $SearchOrig = '';
  }
?>
<Table>
  <tr><td>
    <form action="Search.php" method="get">
      <table border="0">
        <tr><td>Hledané heslo:</td></tr>
        <tr><td><input type="text" name="Search" value="<?php echo $SearchOrig; ?>"></td></tr>
        <tr><td><input type="submit" value="Vyhledat"></td></tr>
      </table>
    </form>
  </td><td>
  
Legenda: <br>
<b>%</b> - Procento nahrazuje libovolný poèet znakù. Pøíklad: 'Ko%'<br>
<b>_</b> - Podtržítko nahrazuje jeden jediný znak. Pøíklad: 'Ko_ina'<br>
<b>[ ]</b> - Znaky zahrnuté do hranatých závorek, znamenají, že se v hledaném textu má vyskytovat buï ten nebo onen znak. Pøíklad: 'Ko[sz]ina'<br>
<b>[-]</b> - Pomocí pomlèky v hranatých závorkách zvolíme rozsah písmen, které se mohou vyskytovat v hledaném textu. Pøíklad: '[K-N]osina'<br>
<b>[^]</b> - Støíška (^) znamená negaci. Uvedené znaky za ní se ve výrazu nemají vyskytovat. Mùžeme dané znaky vypsat [^abcde] anebo použít rozsah [^a-e]. Pøíklad: 'Ko[^sz]ina'<br>
  </td></tr>
</table>
<?php

if ($SearchOrig <> '') {   //pøihlášení / odhlášení
    $Search = strtr($SearchOrig, ' ', '%');

    Echo '<H3>Výsledek hledání:</h3>';
    
    //TODO: zjišovat poèet slov, vybrané tabulky, a zobrazování

    $FoundAll = False;

  //èlánky
  $sql = "SELECT * FROM articles WHERE TextWithoutTags LIKE '%$Search%' or Description LIKE '%$Search%' or Name LIKE '%$Search%'";  
  
  $IDdb = $db->SQLCommand($sql);
  $TestLine = mysql_fetch_array($IDdb);
  
  if (!$TestLine) {
    $Found = False;
  } else {
    $Found = True;
    $FoundAll = True;
  }
  
  if ($Found) {
    echo '<h4>Èlánky:</h4>';    
  }

  $IDdb = $db->SQLCommand($sql);
  while ($Line = mysql_fetch_array($IDdb)) {
    if (strlen($Line['TextWithoutTags']) > 400) {
        $position = strpos($Line['TextWithoutTags'],$Search);
        $start = $position - 70;
        if ($start < 0) 
          $start = 0;
      
        $length = strlen($Search)+140;
      $Text = '..'.substr($Line['TextWithoutTags'],$start,$length).'..';
    } else {
      $Text = $Line['TextWithoutTags'];
    }
      //TODO: zvírazòovat všechny slova
      $Text = ereg_replace($SearchOrig, '<b>'.$SearchOrig.'</b>', $Text);
      
    echo '<a href="Section.php?Article='.$Line['ID'].'">Zobrazit celý èlánek</a>
    <div class="ArticlesItem"><span class="ArticlesName">'.$Line['Name'].'</span> - <span class="ArticlesDescription">'.$Line['Description'].'</span> - <span class="Date">'.$Line['Date'].'</span>';

    if ($AdminLevel > 1) // level 2
      echo '<a href="/Administrace/AddArticles.php?Mode=FormEdit&amp;ID='.$Line['ID'].'"> '.$Icons['Edit'].'</a>';
    if ($AdminLevel > 3) // level 4
      echo '<a href="/Administrace/AddArticles.php?Mode=DelArticle&amp;Section='.$Line['ID'].'" '.JavaQuestionDel().'> '.$Icons['Del'].'</a>';

      echo '<br />'.$Text.'</div>';     
  }

  //aktuality
  $sql = "SELECT * FROM news WHERE Text LIKE '%$Search%' or Description LIKE '%$Search%' or Name LIKE '%$Search%' or User LIKE '%$Search%'";  
  $IDdb = $db->SQLCommand($sql);
  $TestLine = mysql_fetch_array($IDdb);
  
  if (!$TestLine) {
    $Found = False;
  } else {
    $Found = True;
    $FoundAll = True;
  }
  
  if ($Found) {
    echo '<h4>Aktuality:</h4>'; 
  }

  $IDdb = $db->SQLCommand($sql);
  while ($Line = mysql_fetch_array($IDdb)) {
    if (strlen($Line['Text']) > 400) {
        $position = strpos($Line['Text'],$Search);
        $start = $position - 70;
        if ($start < 0) 
          $start = 0;
      
        $length = strlen($Search)+140;
      $Text = '..'.substr($Line['Text'],$start,$length).'..';
    } else {
      $Text = $Line['Text'];
    }
      //TODO: zvírazòovat všechny slova
      $Text = ereg_replace($SearchOrig, '<b>'.$SearchOrig.'</b>', $Text);
    echo '<a href="index.php?AllNews">Zobrazit celou aktualitu</a>
    <div class="NewsItem" title="'.$Line['Description'].'"><span class="Date">'.$Line['Date'].'</span> - <span class="NewsName">'.$Line['Name'].'</span> (<span class="NewsUser">'.$Line['User'].'</span>)';

    if ($AdminLevel > 0) // level 1
      echo '<a href="/Administrace/AddNews.php?Mode=EditNewsForm&amp;ID='.$Line['ID'].'"> '.$Icons['Edit'].'</a>';
    if ($AdminLevel > 3) // level 4
      echo '<a href="/Administrace/AddNews.php?Mode=Del&amp;ID='.$Line['ID'].'" '.JavaQuestionDel().'> '.$Icons['Del'].'</a>';

    echo '<br><span class="NewsText">'.$Text.'</span></div>';
  }


  if ($FoundAll == False) {
        echo 'Nepodaøilo nalézt!';
  }
}  


// složitý sql z php my admin : SELECT * FROM `maron`.`downloaddir` WHERE (`ID` LIKE '%maron%' OR `Name` LIKE CONVERT(_utf8 '%maron%' USING latin2) COLLATE latin2_czech_cs OR `Description` LIKE CONVERT(_utf8 '%maron%' USING latin2) COLLATE latin2_czech_cs OR `Date` LIKE '%maron%' OR `PreviousDir` LIKE '%maron%') OR (`ID` LIKE '%super%' OR `Name` LIKE CONVERT(_utf8 '%super%' USING latin2) COLLATE latin2_czech_cs OR `Description` LIKE CONVERT(_utf8 '%super%' USING latin2) COLLATE latin2_czech_cs OR `Date` LIKE '%super%' OR `PreviousDir` LIKE '%super%') OR (`ID` LIKE '%test%' OR `Name` LIKE CONVERT(_utf8 '%test%' USING latin2) COLLATE latin2_czech_cs OR `Description` LIKE CONVERT(_utf8 '%test%' USING latin2) COLLATE latin2_czech_cs OR `Date` LIKE '%test%' OR `PreviousDir` LIKE '%test%')

  
  //botièka (konec)
  ShowFooter();
?>