PHP convert string starting with @ to user profile URL

Question

I have PHP code which shows post text. Sometimes this post text content contains user mentions like @[2] where 2 is the serial number of the row for the mentioned user in the user table in my database. Suppose this user has username @mark.

I want to replace this mention code @[2] with a user profile link, for example <a href="https://example.com/mark">@mark</a>

Like take value 2 from @[2] string. This value is a variable Find respected row in user table in database for Show username and user profile link instead of @[2].

Why would anyone write @[2] instead of @name? How would users know the database-internal index no? Is this question about linkifying those placeholders, or about doing the database lookups (=too broad)? — mario
– mario, Commented Mar 6, 2019 at 18:06
Possible duplicate of php regex - Replace all @usernames with link in a string / Regular expression to convert usernames into links like Twitter does — mario
– mario, Commented Mar 6, 2019 at 18:08
I have purchased a script which shows mentions as @[2] instead of @name. so i want to implement this. — Mark
– Mark, Commented Mar 6, 2019 at 18:12
Possible duplicate of php regex - Replace all @usernames with link in a string — Bhaumik
– Bhaumik, Commented Mar 6, 2019 at 19:23

mario · Accepted Answer · 2019-03-06 18:20:23Z

1

For the string replacement trick, you'd usually use preg_replace_callback.
The weirdo @[2] placeholder can be matched with a regex like:

/@\[(\d+)\]/
# ↑   ↑   ↑
#@ [ num  ]

And then you do your link mapping in the callback:

$texty = preg_replace_callback(
     "/@\[(\d+)\]/",
     function($m) {
         return "<a href='/profile?id=$m[1]'>" . user_id_to_name($m[1]) . "</a>";
     }
     $texty
);

Obviously with the appropriate id→name lookup function for your database.

answered Mar 6, 2019 at 18:20

mario

146k20 gold badges243 silver badges293 bronze badges

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

Collectives™ on Stack Overflow

PHP convert string starting with @ to user profile URL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related