string在一个句子中替换多个单词

Question

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 .

Answer 1

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;