php - 如何在php中选择mysql中的特定语句？

Question

如何在php中选择mysql中的特定语句？

$query = "select * from table where title LIKE '%{$java}%'";
if ($result = $mysqli->query($query))) {
    $row = $result->fetch_array(MYSQLI_BOTH);
    $title = $row2['title'];

    if ($title ==TOBE== "<pink>$title</pink>") {
            ...........................
            ...........................
            ...........................
    }

}

因为我想要这样，我搜索“java”这个词，当它出现时，只有java这个词是粉红色的

Answer 1

假设$java是一个包含搜索词的变量

$query = "select * from table where title LIKE '%{$java}%'";
if ($result = $mysqli->query($query))) {
    $row = $result->fetch_array(MYSQLI_BOTH);
    $title = $row['title'];

    $title = str_replace($java,"<pink>{$java}</pink>",$title);

}

这会将字符串中出现的任何搜索词替换为 <pink> 中包含的词。所以

"I don't like java programming" 

将会

"I don't like <pink>java</pink> programming"

它也适用于这种情况

"aldfhasdjavaasdkas;ldk"

将成为

"aldfhasd<pink>java</pink>asdkas;ldk"