只匹配一些字母

zkure5ic  于 2021-06-21  发布在  Mysql
关注(0)|答案(2)|浏览(192)

在我的网站有搜索功能。问题是:如果我写litmanova这个词,它什么也找不到,因为在mysql中有litmanovej、litman等词。
如果我把litmanova放在搜索输入中,有没有办法找到例如result litmanovej?谢谢您。

function search() {
  echo "<div class='col-md-12' style='margin-top:20px;'>";
  echo "<div id='custom-search-input'>";
  echo "<form action='vyhladavanie' method='GET'>";
  echo "<div class='input-group col-md-12'>";
  echo "<input type='text' class='form-control input-lg' name='query' placeholder='Napíšte slovo, ktoré hľadáte...' />";
  echo "<span class='input-group-btn'>";
  echo "<button class='btn btn-info btn-lg' type='submit' style='background:#cf585b;border:1px #cf585b solid;'>";
  echo "<i class='glyphicon glyphicon-search'></i>";
  echo "</button>";
  echo "</span>";
  echo "</div>";
  echo "</form>";
  echo "</div>";
  echo "</div>";
}

function showVideoResults() {
  global $conn;
  $query = $_GET['query'];
  $query = "SELECT * FROM videos WHERE video_title LIKE '%".$query."%' OR video_description LIKE '%".$query."%' ORDER by video_date DESC";
  $result = mysqli_query($conn, $query);

  if (!$result) {
    die("Problém" . mysqli_error($conn));
  }

  while ($row = mysqli_fetch_array($result)) {
      $video_id = $row['video_id'];
      $video_title = $row['video_title'];
      $video_date = $row['video_date'];
      $video_description = $row['video_description'];
      $video_link = $row['video_link'];
      $video_category = $row['video_category'];
      $video_url = $row['video_url'];

      echo "<div class='col-md-4'>";
      echo "<a href='video/$video_id-$video_url'>";
      echo "<h3 class='meta_title'>$video_title</h3></a>";

      echo "</div>";
  }
}
trnvg8h3

trnvg8h31#

恐怕没有“简单”的方法,但你可以在比赛中玩转。
这里有一些很好的例子。

368yc8dk

368yc8dk2#

您不必对代码做任何更改。您需要更改数据库表列的定义
您需要将collate utf8\u general\u ci添加到列的定义中。

ALTER TABLE videos 
 MODIFY COLUMN video_title VARCHAR(…) CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI;

相关问题