php - 如何从数据库中查找字符串中的文本？

Question

Let's say i have:

$title = "Rihanna - Man Down";

and a database multiple rows including one with a field called "name" with the "Rihanna" value

now... how can i check if in $title exists "Rihanna" and if it does how to add a link on "Rihanna" like this:

with other words check if one of the expresions from $title exists the database

• i think this second formulation it is better

<a href="artist?id=Rihanna">Rihanna</a> - Man Down

I want to do something like youtube does at some of it;s music videos to be more clear

Answer 1

$words = explode("-", $title);
$result = array();

foreach ($words as $word)
{
    $word = trim($word);
    $res = mysql_query("SELECT name FROM table WHERE name='" . mysql_real_escape_string($word) . "'");

    if (mysql_num_rows($res) > 0)
    {
        $result[] = '<a href="artist?id=' . $word . '">' . $word . '</a>';
    }
    else
    {
        $result[] = $word;
    }
}

$result = implode($result, " - ");

This will however also link to "artist?id=Pink" if a song from another artist is named Pink, but you have the artist Pink in your database.