Programming a Tags Feature in PHP

Question

How would I go about writing up a basic tags feature? (similar to the one on this site)

I'm struggling coming up with good logic with little redundancy and would like a more experienced programmer's take on this.

The site I have is fully developed as of right now and has a search feature (searches through titles) - I'm just looking to expand on this and allow the search to sift through tags as well.

Edit:

I was considering adding a row on to my main table called "tags". Then separating them by spaces.

But I have also thought about create a new table and using the same id's from my main table, creating tags in this manner.

With respect that you're asking of guidance, what have you tried so far? — Jason McCreary
– Jason McCreary, Commented Oct 17, 2011 at 17:02
Simply have a tags table with a foreign key for your titles? — el_pup_le
– el_pup_le, Commented Oct 17, 2011 at 17:05

Surreal Dreams · Accepted Answer · 2011-10-17 17:22:33Z

2

I'd suggest 2 tables. One contains Tags - the name of the tag, a tag id, any anything else you want to keep track of on a tag. Also create a relationship table that connects your article/post id to the tag id. You won't repeat data in the database, you should be able to search the tags and join tables together to come up to return articles, and also query the tags if you want to display them along with posts.

answered Oct 17, 2011 at 17:22

Surreal Dreams

26.4k4 gold badges49 silver badges61 bronze badges

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

1 Comment

ghbarratt Over a year ago

Using the relationship table is a great way to do it because it allows you to have an index on the individual tags while efficiently joining to the content table.

Collectives™ on Stack Overflow

Programming a Tags Feature in PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related