php - how to find text in a string from database?

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

Please rephrase your question it's a bit tough to understand. — voldomazta
– voldomazta, Commented Nov 24, 2011 at 11:14

Faraona · Accepted Answer · 2011-11-24 11:54:31Z

3

If I understood correct, this can do the work:

Then first search in DataBase, your query must be something like this:

//Search for word in DataBase on filed "name"

$title = "Rihanna - Man Down";
$arr = explode('-', $title); 
$title = $arr[0];

$result = mysql_query("SELECT name FROM table WHERE name LIKE '%" . mysql_real_escape_string($title) . "%'");

//If find results, then we replace and generate links in this loop

while($row = mysql_fetch_array( $result )) {
    $str = str_replace($title, '<a href="artist?id='.$title.'">'.$title.'</a>', $row['name']);
    echo $str; //<a href="artist?id=Rihanna">Rihanna</a> - Man Down
}

edited Nov 24, 2011 at 11:54

answered Nov 24, 2011 at 11:13

Faraona

1,7002 gold badges22 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

m3tsys Over a year ago

thank you, this works but that was just an example... i need to check if a word from $title exists in the dataabse and put a link on that word if it exists. please think at the youtube example.

Faraona Over a year ago

Look at modified answer, try this.

m3tsys Over a year ago

thanks, this really works ; but it works when $title = "Rihanna"; ; when $title = "Rihanna - Man Down"; (or with other words, when it contains something more than the artist name it doesn't work)

Faraona Over a year ago

If your Artist is always first word of $title, then you can use this: $arr = explode(' ', $title); $title = $arr[0];

Faraona Over a year ago

Or this is better: $arr = explode('-', $title); $title = $arr[0];

|

CodeCaster · Accepted Answer · 2011-11-24 12:25:13Z

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.

edited Nov 24, 2011 at 12:25

answered Nov 24, 2011 at 11:24

CodeCaster

153k24 gold badges237 silver badges287 bronze badges

6 Comments

m3tsys Over a year ago

i've tried this but i have this error: "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given" on the line with if (mysql_num_rows($res) > 0)

CodeCaster Over a year ago

@m3tsys then start debugging. Probably there's an error in the query. Enable error reporting, print the query.

m3tsys Over a year ago

error reporting is on: i get the same error ; when i echo $result i get - sign

CodeCaster Over a year ago

@m3tsys I accidentally swapped the parameters for explode(). Should work now.

m3tsys Over a year ago

thanks a lot! that worked... now i have a question... Let's say $title = "justin bieber will be father"; is there posible to do the same thing ? i mean to work with or without that - sign?

|

socha23 · Accepted Answer · 2011-11-24 11:23:37Z

1

Split your title into words, and for each word check if your database contains row with that name. If yes, replace occurences of the word with link.

foreach (preg_split("/\s+/", $title) as $word) {
    if (word_in_database($word)) {
        $title = str_replace($word, "<a href=\"artist?id=$word\">$word</a>", $title);
    }
}

edited Nov 24, 2011 at 11:23

answered Nov 24, 2011 at 11:17

socha23

10.3k3 gold badges31 silver badges25 bronze badges

Collectives™ on Stack Overflow

php - how to find text in a string from database?

3 Answers 3

6 Comments

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related