Adding Tag-usage to a site

[Undrium]

Greetings, all.

I have been thinking about adding tags to one of my website for easier categorization and better navigation. Problem is I'm not quite sure how I should structure it up, how I should extend my database for the sort of messy tag-system.

Anyone who knows a good guide out there telling you how to structure up a tag system? I'm particulary interested in knowing how to store tags in a database and how to best use php for it.

I consider myself skilled with PHP, I just want to make sure I do this right from the beginning.

Thanks in advance for your help. 🙂

[Kudose]

You could create a new tables called, say, tags and which has two columns, say, postId and tagId

Then you have another table called, say, tag_values which has two columns, tagId and tagValue

Add your new tags to tag_values and search for tags on the table tags and associate them to the postId

Hope that makes sense.