user1001176
user1001176

Reputation: 1165

string replace multiple words in one sentence

I am making a tagging system in which there are user ids separated by comma in database . I call them after words and then break them and get the real user names for those ids . I am using str_replace to replace those words from a status update with their profile links (like facebook tag a friend) . The problem is how to replace multiple tags within the sentence ?

function tags($final_message,$tag_id)
{
    GLOBAL $con;
    if ($tag_id!==0)
    {
        $tag_id_explode=explode(",",$tag_id);
            foreach($tag_id_explode as $id)
        {   
        $tag_friend_query=mysqli_query($con,"select f_name,l_name from users_profile where user_id='$id'");
        $tag_friend_query_result=mysqli_fetch_assoc($tag_friend_query);
        $fname=$tag_friend_query_result['f_name'];
        $lname=$tag_friend_query_result['l_name'];
        $final_name=$fname.' '.$lname;
        $html="<a href='profile.php?id=".$id."'>".$final_name."</a>";

        }
            echo str_replace($final_name,$html,$final_message);

    }
} 

This only converts one user and if there are multiple it does not work . If i put str_replace inside the loop then it works but it converts at a time and returns two different output with same sentence and one user being converted in each . It should be multiple users converted in just once sentence .

Upvotes: 1

Views: 493

Answers (2)

zzlalani
zzlalani

Reputation: 24384

do this

foreach($tag_id_explode as $id)
{   
    $tag_friend_query=mysqli_query($con,"select f_name,l_name from users_profile where user_id='$id'");
    $tag_friend_query_result=mysqli_fetch_assoc($tag_friend_query);
    $fname=$tag_friend_query_result['f_name'];
    $lname=$tag_friend_query_result['l_name'];
    $final_name=$fname.' '.$lname;
    $html="<a href='profile.php?id=".$id."'>".$final_name."</a>";
    $final_message = str_replace($final_name,$html,$final_message);
}
echo $final_message;

Upvotes: 1

Rakesh Shewale
Rakesh Shewale

Reputation: 507

The problem seems here when you use $final_name in str_replace(), it only has one last user's final name. Instead put it in the loop and in $html you are collecting the link, so you may want to do it in this way:
$html .=yourlink;

Please try the string concatinator dot after the variable (.)

Upvotes: 0

Related Questions