Fulltext - vylepšení vyhledávání

      <?php
$host = "IP";
$dbuser = "UŽIVATEL";       
$dbpass = "HESLO";
$db = "DATABÁZE";                                                                           
 
$con = mysql_connect($host, $dbuser, $dbpass);
if(!$con){
die(mysql_error());
}
 
$select = mysql_select_db($db, $con);
if(!$select){
die(mysql_error());
} 
$item = (isset($_GET['find']) ? $_GET['find'] : "");
if (empty($item)) 
 { 
return $message = "<b>Zadejte klíčové slovo a stiskněte tlačítko hledat.</b>";
 }
$data = mysql_query("SELECT * FROM hledat_web WHERE Nadpis LIKE ('%$item%')");
$cislo = mysql_num_rows($data);                
echo "<table><tr><td>Počet výsledků pro klíčové slovo &quot;<b>$item</b>&quot;: <b style='font-size: 16px'>$cislo</b></td></tr>";
while($row = mysql_fetch_array($data)){ 
  echo "<tr><td><br><br></td></tr>";
  echo "<tr><td><a href=".$row['Odkaz']."><span style='font-size: 20px; padding: 0 50px;'>".$row['Nadpis']."</span></a><br><span style='color: rgb(0,102,33);'>".$row['Microdata']."</span><br><p style='text-align:justify;'>".$row['Text']."</p></td></tr>";  
}
echo "</table>";
if(mysql_num_rows($data)==0) echo "<b>Nic nebylo nalezeno.</b> Jste si jistí, že tato položka existuje?&nbsp;";
?>

<?php require_once('hledej.php'); ?> 
    <div class="hledat">
            <form action="formular.php" method="get">   
            <fieldset>
                <input type="hidden" name="parent_id" value="0" />
                <legend>
                    <strong>Hledat na webu</strong>
                </legend>          
        <?php if(!empty($message_uspech)){ echo '<ul><li class="green">'.$message_uspech.'</li></ul>'; } ?>
        <?php if(!empty($message)){ echo '<ul><li class="red">'.$message.'</li></ul>'; } ?>
                <label class="label">Hledat: <small>(Klíčová slova)</small></label>
                <input name="find" type="search" style="width: 25%; height: 30px;" value="<?php if(isset($_GET['find'])){ echo $_GET['find']; }?>" placeholder="Klíčové slovo" />&nbsp;&nbsp;&nbsp;&nbsp;<button type="submit">HLEDAT</button>
                <br />
        <br />
                <label class="label">Možnosti hledání:</label>
                <input name="searchphrase" id="searchphraseall" checked="checked" value="all" type="radio"><label for="searchphraseall">Všechna slova</label><span style="color:#9eb23f;">|</span><input name="searchphrase" id="searchphraseexact" value="exact" type="radio"><label for="searchphraseexact">Přesná fráze</label><span style="color:#9eb23f;">|</span>
                <br />
        <label class="label">Prohledávat:</label>
        <input name="vse" type="checkbox" checked="checked"><span>Prohledávat vše</span><span style="color:#9eb23f;">|</span><input name="clanky" type="checkbox"><span>Články</span><span style="color:#9eb23f;">|</span><input name="foto" type="checkbox"><span>Foto a video galerie</span><span style="color:#9eb23f;">|</span><input name="ostatni" type="checkbox"><span>Ostatní</span><span style="color:#9eb23f;">|</span>
            </fieldset>
        </form>    </div>  
       <br> 
      <?php
if (empty(!empty($message))){ 
while($row = mysql_fetch_array($data)){ 
  echo "<table><tr><td><br><br></td></tr>";
  echo "<tr><td><span class='video' style='font-size: 20px; padding: 0 50px;'><a href=".$row['Odkaz'].">". $row['Nadpis'] ."</a></span><br><span style='color: #00FF00;'>".$row['Microdata']."</span><br><p style='text-align:justify;'>". preg_replace('/' . preg_quote($item, '/') . '/i', '<span style="font-weight: 900;color: #9EB23F;">\0</span>', $row['Text']) ."</p></td></tr>";  
echo "</table>";}}

<?php

// prihlaseni do databaze
$host = "IP";
$dbuser = "UŽIVATEL";       
$dbpass = "HESLO";
$db = "DATABÁZE";                                                                            

// zpracovani databaze
$con = mysql_connect($host, $dbuser, $dbpass);
if(!$con){
die(mysql_error());
}

$select = mysql_select_db($db, $con);
if(!$select){
die(mysql_error());
} 
// item je políčko s názvem find
$item = (isset($_GET['find']) ? $_GET['find'] : "");

// hlaska, ze navstevnik nezadal hledane slovo
if (empty($item)) 
 {                                                                                                                                                                                                                                                          
return $message = "Zadejte klíčové slovo a stiskněte tlačítko hledat. ";
 }

// minimalni pocet znaku jsou ctyri
if (strlen($item) <=3){               
return $message = "Minimální počet znaků v klíčovém slově je čtyři! ";
}

// vyhledani tabulky v databazi
$data = mysql_query("SELECT * FROM `hledat_web` WHERE `Nadpis` LIKE '%$item%' OR `Text` LIKE '%$item%'");

// pocet vysledku pro klicove slovo
$cislo = mysql_num_rows($data);
if (empty(mysql_num_rows($data)==0)){               
$message_uspech = "Počet výsledků pro klíčové slovo &quot;<b>".$item."</b>&quot;: <b style='font-size: 16px'>".$cislo."</b>";
}

// hlaska, ktera rika, ze nebylo nic nalezeno
if(mysql_num_rows($data)==0) $message = "<b>Nic nebylo nalezeno.</b> Jste si jistí, že tato položka existuje? ";
mysql_close ($con);
?>

<?php
function excerpt($text, $search, $length = 150, $wrap = NULL) {
    $searchLength = mb_strlen($search);
    $textLength = mb_strlen($text);
 
    # let's save positions of all occurences into an array
    $positions = [];
    $pos = 0;
    while (($pos = mb_stripos($text, $search, $pos)) !== FALSE) {
        $positions[] = $pos;
        $pos += $searchLength;
    }
    ($positions);
 
    if (count($positions) == 0) {
        # couldn't find $search anywhere
        # let's return part of the text from the beginning
        $begin = 0;
        $end = min($length, $textLength);
    } else {
        # let's find longest subsequence (of limited length) which contains most occurences
        $bestFrom = -1;
        $bestTo = -1;
 
        $from = 0; # $from is tail, $to is head
        for ($to = 0; $to < count($positions); $to++) {
            # moving the tail to keep the body <= $length
            while ($positions[$to] - $positions[$from] + $searchLength > $length) {
                $from++;
            }
 
            # does the body contain more occurences?
            if ($to - $from + 1 > $bestTo - $bestFrom) {
                $bestFrom = $from;
                $bestTo = $to;
            }
        }
 
        $begin = $positions[$bestFrom];
        $end = $positions[$bestTo] + $searchLength;
    }
    (array('begin' => $begin, 'end' => $end));
 
    # now we have estimates in $begin and $end, let's extend it as much as possible to size $length
    # we will alternate extending the region left and right until we excess the $length
    # we extends at least once to make sure we are at the border of a word
    # we assume that the words are separate by spaces or newlines
 
    $delta = 0;
    do {
        # find next space/nl
        $endOffset = min($end + $delta, $textLength);
        $endPos1 = mb_stripos($text, ' ', $endOffset);
        $endPos2 = mb_stripos($text, "\n", $endOffset);
        $end = min($endPos1 === FALSE ? $textLength : $endPos1, $endPos2 === FALSE ? $textLength : $endPos2);
 
        # find previous space/nl
        $beginOffset = max($begin - $textLength - 1 - $delta, -$textLength);
        $beginPos1 = mb_strripos($text, ' ', $beginOffset);
        $beginPos2 = mb_strripos($text, "\n", $beginOffset);
        $begin = max($beginPos1 === FALSE ? -1 : $beginPos1, $beginPos2 === FALSE ? -1 : $beginPos2) + 1;
 
        # this makes sure we look for border of the word for the first time, not further
        if ($delta == 0) {
            $delta = 1;
        }
        (array('begin' => $begin, 'end' => $end));
    } while($end - $begin + 1 < $length && ($begin != 0 || $end != $textLength));
 
    # now the $begin and $end form a region of words, time to wrap the search results
    $excerpt = mb_substr($text, $begin, $end - $begin + 1);
    if (is_callable($wrap)) {
        $regex = '/' . preg_quote($search, '/') . '/i';
        $excerpt = preg_replace_callback($regex, $wrap, $excerpt);
    }
 
    return $excerpt;
}
 
# function which is highlighting the found item
function boldize($matches) {
    return '<b>' . $matches[0] . '</b>';
}
 
# example usage
echo excerpt($row['Text'], $item, 150, 'boldize')
?>      

<?php require_once('hledej.php'); ?> 
<p></p>
    <div class="hledat">
            <form action="zkouska.php" method="get">   
            <fieldset>
                <input type="hidden" name="parent_id" value="0" />
                <legend>
                    <strong>Hledat na webu</strong>
                </legend>          
        <?php if(!empty($message_uspech)){ echo '<ul><li class="green">'.$message_uspech.'</li></ul>'; } ?>
        <?php if(!empty($message)){ echo '<ul><li class="red">'.$message.'</li></ul>'; } ?>
                <label class="label">Hledat: <small>(Klíčová slova)</small></label>
                <input name="find" type="search" style="width: 25%; height: 30px;" value="<?php if(isset($_GET['find'])){ echo $_GET['find']; }?>" placeholder="Klíčové slovo" />&nbsp;&nbsp;&nbsp;&nbsp;<button type="submit">HLEDAT</button>
                <br />
        <br />
                <label class="label">Možnosti hledání:</label>
                <input name="searchphrase" id="searchphraseall" checked="checked" value="all" type="radio"><label for="searchphraseall">Všechna slova</label><span style="color:#9eb23f;">|</span><input name="searchphrase" id="searchphraseexact" value="exact" type="radio"><label for="searchphraseexact">Přesná fráze</label><span style="color:#9eb23f;">|</span>
                <br />
        <label class="label">Prohledávat:</label>
        <input name="vse" type="checkbox" checked="checked"><span>Prohledávat vše</span><span style="color:#9eb23f;">|</span><input name="clanky" type="checkbox"><span>Články</span><span style="color:#9eb23f;">|</span><input name="foto" type="checkbox"><span>Foto a video galerie</span><span style="color:#9eb23f;">|</span><input name="ostatni" type="checkbox"><span>Ostatní</span><span style="color:#9eb23f;">|</span>
            </fieldset>
        </form>    </div>  
       <br> 
      <?php
if (empty(!empty($message))){ 
while($row = mysql_fetch_array($data)){ 
  echo "<table><tr><td><br><br></td></tr>";
  echo "<tr><td><span class='video' style='font-size: 20px; padding: 0 50px;'><a href=".$row['Odkaz'].">". $row['Nadpis'] ."</a></span><br><span style='color: #00FF00;'>".$row['Microdata']."</span><br><p style='text-align:justify;'>". preg_replace('/' . preg_quote($item, '/') . '/i', '<span style="font-weight: 900;color: #9EB23F;">\0</span>', $row['Text']) ."</p></td></tr>";  
  echo "</table>";
}}
?>
<?php
function excerpt($text, $search, $length = 150, $wrap = NULL) {
    $searchLength = mb_strlen($search);
    $textLength = mb_strlen($text);
 
    # let's save positions of all occurences into an array
    $positions = [];
    $pos = 0;
    while (($pos = mb_stripos($text, $search, $pos)) !== FALSE) {
        $positions[] = $pos;
        $pos += $searchLength;
    }
    ($positions);
 
    if (count($positions) == 0) {
        # couldn't find $search anywhere
        # let's return part of the text from the beginning
        $begin = 0;
        $end = min($length, $textLength);
    } else {
        # let's find longest subsequence (of limited length) which contains most occurences
        $bestFrom = -1;
        $bestTo = -1;
 
        $from = 0; # $from is tail, $to is head
        for ($to = 0; $to < count($positions); $to++) {
            # moving the tail to keep the body <= $length
            while ($positions[$to] - $positions[$from] + $searchLength > $length) {
                $from++;
            }
 
            # does the body contain more occurences?
            if ($to - $from + 1 > $bestTo - $bestFrom) {
                $bestFrom = $from;
                $bestTo = $to;
            }
        }
 
        $begin = $positions[$bestFrom];
        $end = $positions[$bestTo] + $searchLength;
    }
    (array('begin' => $begin, 'end' => $end));
 
    # now we have estimates in $begin and $end, let's extend it as much as possible to size $length
    # we will alternate extending the region left and right until we excess the $length
    # we extends at least once to make sure we are at the border of a word
    # we assume that the words are separate by spaces or newlines
 
    $delta = 0;
    do {
        # find next space/nl
        $endOffset = min($end + $delta, $textLength);
        $endPos1 = mb_stripos($text, ' ', $endOffset);
        $endPos2 = mb_stripos($text, "\n", $endOffset);
        $end = min($endPos1 === FALSE ? $textLength : $endPos1, $endPos2 === FALSE ? $textLength : $endPos2);
 
        # find previous space/nl
        $beginOffset = max($begin - $textLength - 1 - $delta, -$textLength);
        $beginPos1 = mb_strripos($text, ' ', $beginOffset);
        $beginPos2 = mb_strripos($text, "\n", $beginOffset);
        $begin = max($beginPos1 === FALSE ? -1 : $beginPos1, $beginPos2 === FALSE ? -1 : $beginPos2) + 1;
 
        # this makes sure we look for border of the word for the first time, not further
        if ($delta == 0) {
            $delta = 1;
        }
        (array('begin' => $begin, 'end' => $end));
    } while($end - $begin + 1 < $length && ($begin != 0 || $end != $textLength));
 
    # now the $begin and $end form a region of words, time to wrap the search results
    $excerpt = mb_substr($text, $begin, $end - $begin + 1);
    if (is_callable($wrap)) {
        $regex = '/' . preg_quote($search, '/') . '/i';
        $excerpt = preg_replace_callback($regex, $wrap, $excerpt);
    }
 
    return $excerpt;
}
 
# function which is highlighting the found item
function boldize($matches) {
    return '<b>' . $matches[0] . '</b>';
}
 
# example usage
echo excerpt($row['Text'], $item, 150, 'boldize')
?>   

<?php require_once('hledej.php');?>
    <div class="hledat">
            <form action="zkouska.php" method="POST">   
            <fieldset>
                <input type="hidden" name="parent_id" value="0" />
                <legend>
                    <strong>Hledat na webu</strong>
                </legend>          
        <?php if(!empty($message_uspech)){ echo '<ul><li class="green">'.$message_uspech.'</li></ul>'; } ?>
        <?php if(!empty($message)){ echo '<ul><li class="red">'.$message.'</li></ul>'; } ?>
                <label class="label">Hledat: <small>(Klíčová slova)</small></label>
                <input name="find" type="search" style="width: 25%; height: 30px;" value="<?php if(isset($_POST['find'])){ echo $_POST['find']; }?>" placeholder="Klíčové slovo" />&nbsp;&nbsp;&nbsp;&nbsp;<button type="submit">HLEDAT</button>
                <br />
        <br />
                <label class="label">Možnosti hledání:</label>
                <label><input value="all" type="radio"/>Všechna slova</label><span style="color:#9eb23f;">|</span><label><input value="exem" type="radio"/>Přesná fráze</label><span style="color:#9eb23f;">|</span>
            </fieldset>
        </form>    </div>  
       <br>
<?php
include('includes/class.Paging.php');

$link = mysql_connect('88.86.117.154:3306', 'kolemzeme.wz3044', 'heslo');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
if (!mysql_select_db('kolemzeme.wz3044')) {
die('Could not select database: ' . mysql_error());
}

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `hledat_web`"), 0);
$limit = 20;
$base = 'http://www.kolemzeme.wz.cz/zkouska.php/';

// celkem | [zakladna] | [po kolika] | [format parametru]
$paging = new Paging($total, $base, $limit, '?page=%s');
$paging->set_title_format('Stránka %s'); // nepovinne
$paging->set_around(2); // nepovinne
$paging->set_paging_mode(1); // 0
$paging->set_output_mode(1); // 0
$paging->set_paging();

// vystup
echo $paging->export_paging(); // echo $paging; // $tpl['paging'] = (string)$paging;

// parametry limit pro sql dotaz:
$sql_start = $paging->get_start();
$sql_limit = $paging->get_limit();

?>
<?php
            $print_paging = $paging->export_paging();
            if(!empty($print_paging)){
        ?>
            <p class="strankovani">
                <strong>Stránkování:</strong><br />
                <?php echo $print_paging; ?>
            </p>
        <?php }?>
      <?php
if (empty(!empty($message))){ 
while($row = mysql_fetch_array($data)){ 
  echo "<table><tr><td><br><br></td></tr>";
  echo "<tr>
  <td>
    <span class='video' style='font-size: 20px; padding: 0 50px;'>
      <a href=" . $row['Odkaz'] . ">" . $row['Nadpis'] . "</a>
    </span>
    <br>
    <span style='color: #00FF00;'>" . $row['Microdata'] . "</span>
    <br>
    <p style='text-align:justify;'>..." . excerpt($row['Text'], $item, 450, 'boldize') . "...</p>
  </td>
</tr>";  
  echo "</table>";
}}
?>

<?php
function excerpt($text, $search, $length = 450, $wrap = NULL) {
    $searchLength = mb_strlen($search);
    $textLength = mb_strlen($text);
 
    # let's save positions of all occurences into an array
    $positions = [];
    $pos = 0;
    while (($pos = mb_stripos($text, $search, $pos)) !== FALSE) {
        $positions[] = $pos;
        $pos += $searchLength;
    }
    ($positions);
 
    if (count($positions) == 0) {
        # couldn't find $search anywhere
        # let's return part of the text from the beginning
        $begin = 0;
        $end = min($length, $textLength);
    } else {
        # let's find longest subsequence (of limited length) which contains most occurences
        $bestFrom = -1;
        $bestTo = -1;
 
        $from = 0; # $from is tail, $to is head
        for ($to = 0; $to < count($positions); $to++) {
            # moving the tail to keep the body <= $length
            while ($positions[$to] - $positions[$from] + $searchLength > $length) {
                $from++;
            }
 
            # does the body contain more occurences?
            if ($to - $from + 1 > $bestTo - $bestFrom) {
                $bestFrom = $from;
                $bestTo = $to;
            }
        }
 
        $begin = $positions[$bestFrom];
        $end = $positions[$bestTo] + $searchLength;
    }
    (array('begin' => $begin, 'end' => $end));
 
    # now we have estimates in $begin and $end, let's extend it as much as possible to size $length
    # we will alternate extending the region left and right until we excess the $length
    # we extends at least once to make sure we are at the border of a word
    # we assume that the words are separate by spaces or newlines
 
    $delta = 0;
    do {
        # find next space/nl
        $endOffset = min($end + $delta, $textLength);
        $endPos1 = mb_stripos($text, ' ', $endOffset);
        $endPos2 = mb_stripos($text, "\n", $endOffset);
        $end = min($endPos1 === FALSE ? $textLength : $endPos1, $endPos2 === FALSE ? $textLength : $endPos2);
 
        # find previous space/nl
        $beginOffset = max($begin - $textLength - 1 - $delta, -$textLength);
        $beginPos1 = mb_strripos($text, ' ', $beginOffset);
        $beginPos2 = mb_strripos($text, "\n", $beginOffset);
        $begin = max($beginPos1 === FALSE ? -1 : $beginPos1, $beginPos2 === FALSE ? -1 : $beginPos2) + 1;
 
        # this makes sure we look for border of the word for the first time, not further
        if ($delta == 0) {
            $delta = 1;
        }
        (array('begin' => $begin, 'end' => $end));
    } while($end - $begin + 1 < $length && ($begin != 0 || $end != $textLength));
 
    # now the $begin and $end form a region of words, time to wrap the search results
    $excerpt = mb_substr($text, $begin, $end - $begin + 1);
    if (is_callable($wrap)) {
        $regex = '/' . preg_quote($search, '/') . '/i';
        $excerpt = preg_replace_callback($regex, $wrap, $excerpt);
    }
 
    return $excerpt;
}
 
# function which is highlighting the found item
function boldize($matches) {
return '<span style="font-weight: 900;color: #9EB23F;">' . $matches[0] . '</span>';
}
?>

$data = mysql_query("SELECT * FROM `hledat_web` WHERE `Nadpis` LIKE '%$item%' OR `Text` LIKE '%$item%'");

$data = mysql_query("SELECT * FROM `hledat_web` WHERE `Nadpis` LIKE '%$item%' OR `Text` LIKE '%$item%' DESC limit ".$paging->get_start().", ".$paging->get_limit()."")->assocList();