PHP user tagging system

Question

So I haven't really found anything about this topic online while doing my research. Basically all I want to do is allow people to "tag" other users in their post. Like

@Bob, SO is a great place!

Then I'd handle the notification once I know that a username has been tagged and I'd notify the user. So my question is how would I approach this. I'm trying to achieve something like Twitters tagging system where if you click on the tag it'll take you to the users profile. Would I use regex and weed out the username from the @? Are their any libraries for this to make it easier? Any assistance would be great.

That appears to be more of an article tag. And there's only SQL examples. Not sure how to do it with PHP is my issue @Jatin — user3100859
– user3100859, Commented Jul 7, 2014 at 1:34
@user3100859 So is your question "how to setup a tagging system from scratch?" with sourcecode? Then your question is too broad. If it is about matching @username with regex then there is already some duplicates around. I do not see the technical problems you encountered. This site is not a request-for-tutorial site. — HamZa
– HamZa, Commented Jul 7, 2014 at 1:37
I'm requesting a guideline, not a tutorial. All I want is some direction to head to. As you stated This site is not a request-for-tutorial site. Can you explain this Or maybe this, oh and even this? @HamZa — user3100859
– user3100859, Commented Jul 7, 2014 at 1:41
@user3100859 I don't want to go too deep into the questions you linked. But the first one is quite old (stackoverflow was less strict in the old days), the second one is not a request-for-tutorial and the third one is about explanation of a certain feature of a programming language. You might better go to a chatroom IMO since opinions on how to tackle this might differ. Again, this is not a specific programming problem. So might as well be too broad. — HamZa
– HamZa, Commented Jul 7, 2014 at 1:46

Rameez Rami · Accepted Answer · 2015-08-16 05:27:16Z

2

you can use textntag plugin for @ or # tagging its completely editable and core files can be simply edited according to your specific needs. http://daniel-zahariev.github.io/jquery-textntags

answered Aug 16, 2015 at 5:27

Rameez Rami

5,7682 gold badges33 silver badges39 bronze badges

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

Comments

Andie2302 · Accepted Answer · 2014-07-09 12:15:02Z

0

The regex to get @username without the @ is:

(?<=@)[\p{L}\p{N}]+

This regex assumes that a username only consists of unicode letter characters and numbers. It also works with the german umlaut: Ü,ü,Ä,ä,Ö,ö,ß

answered Jul 9, 2014 at 12:15

Andie2302

4,9254 gold badges26 silver badges46 bronze badges

Comments

hex494D49 · Accepted Answer · 2014-07-09 22:50:24Z

The whole logic lies on these few lines. Find all @names on the post, find their emails in your database and send them a notification.

<?php

$id = 551; // id of this post which is unique
$post = "@Bob, SO is a great place! Even @John is here"; // post content
$pattern = '/@([a-zA-Z0-9]+)/'; // the pattern to extract all nicknames (without @)
preg_match_all($pattern, $post, $matches);

// let's select all these users in order to retrieve their emails
$query = "SELECT nickname, email FROM users WHERE nickname IN ('" . implode("', '", $matches[1]) . "')";
$results = $mysqli_query($query);

while($row = $mysqli_fetch_array($results, MYSQLI_ASSOC)){
    // send an email and a link to the post where he/she has been tagged / mentioned 
    mail($row["email"], "Subject", "Hello " . $row["nickname"] . " someone tagged you. <a href='http://domain/posts/" . $id . "'>Take a look</a>");    
}

?>

Collectives™ on Stack Overflow

PHP user tagging system

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related