Jump to content

Archived

This topic is now archived and is closed to further replies.

extrovertive

Creating a tagging system search database?

Recommended Posts

Sites with a 'tagged' feature which you can add tags to your blog item, bookmark item, news item, etc, how are these tags stored in the database?


Say, if I have a profile page and I want to tags my

Would the form be like this?

[code]
Tags, seperated by comma <input type="text" name="tags" />
[/code]

Then in my PHP code for storing the tags in the database for searching, are the tags stored all in one field or seperate rows for each tag?

How would the query work to search for certain items (news, blogs, etc) based on tag(s)?

Share this post


Link to post
Share on other sites
Have a table called tags with a structure like this:

tag_id
tag_object_id
tag_user_id
tag_name

Share this post


Link to post
Share on other sites
So, each tag has an id of its own?

Let's say a user has a blog, and enter tags. If a tag_name already exist in the database, then don't add it right, but if it doesn't exists then auto increment the tag_id and add the tag_name?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.