php - 使用 mysql 和 php 搜索字符串中的每个单词

Question

我需要在数据库中搜索字符串的每个单词。如果存在一个词，则需要将其突出显示。当前脚本有效，但我的服务器需要大量内存。我不知道如何让它变得更容易，但也许你会这样做？

<?php

$total_messages = $_POST['total'] - 1;

for($x = 0; $x <= $total_messages; $x++)
{
    //Search highlights
    $result = $mysqli->query("SELECT * FROM highlights WHERE enabled=1")
    while($row = $result->fetch_assoc())
    {
        //Vars for highlights
        $highlight_txt = $row['value'];
        $highlight_type = $row['type'];
        $highlight_color = "black";
        $highlight_title = null;

        //If the text isnt empty
        if($highlight_txt != null || $highlight_txt != "")
        {
            //Type highlights
            if($highlight_type == "tree") //Tree type
            {
                $highlight_type = "18"; //Category number
                $highlight_background = "pink"; //Background
                if($row['option1'] != null)
                {                       
                    $highlight_title = htmlentities($row['option1']);
                }
            }           
            else
            {
                $highlight_background = "yellow"; //Background
            }

            //Add highlight
            $message = preg_replace("/\b($highlight_txt)\b/i", "<span class='bc_highlight' highlight-type='$highlight_type' highlight-value='$highlight_txt' style='background: $highlight_background; color: $highlight_color;' title=''>$highlight_txt</span>", $message);    
        }       
    }   
    echo $message; //Display the message
}

Answer 1

为什么不做这样的事情呢？

$messages = ["This is my message1","This is my message2"];
$highlights = [];
$result = $mysqli->query("SELECT * FROM highlights WHERE enabled=1")
while($row = $result->fetch_assoc()) {
    $highlights[$row["value"]] = [
        "type" => $row["type"],
        "color" => $row["color"]
    ];
}
$callback = function($matches) use ($highlights) {
  $word = $matches[1];
  if(isset($highlights[$word])) {
      $highlight = $highlights[$word];
      return sprintf('<span style="color:%s">%s</span>',$highlight["color"],$word);
  } else {
      return $word;
  }
};
foreach($messages as &$message) {
    $message = preg_replace_callback("/(\w+)/i",$message,$callback);
}