implementation of tags with php and mysql

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
howardr
Forum Newbie
Posts: 17
Joined: Mon Oct 31, 2005 1:33 pm

implementation of tags with php and mysql

Post by howardr »

I was wondering if anyone has implemented a tagging system, like flikr.com, where users can describe content or images using php and mysql. I am building a kind of groupware application with php. People will be uploading pictures and video and i want members to be able to describe them, and I hope this method will also allow for searching of this media.

If you have implemeted tagging, can you please share this with me?

thanks
User avatar
blacksnday
Forum Contributor
Posts: 252
Joined: Sat Jul 30, 2005 6:11 am
Location: bfe Ohio :(

Post by blacksnday »

Im not fully sure what you mean by a 'tag system' but
I might have something that helps?

on my site I recently developed a 'AdWords' type system.
It can be used for many more features.. possible a tag system.

What it does right now... is that I define in SQL what words I want to
be used as an 'AdWord', What I want the AdWord to be displayed as
and what description I want it to have
when it is viewed(or in my case... mouseovered).

Then on php side whenever that word is used
on my site, it automacticlly is shown without any further intervention on my end.

Now this same idea could be used as a Tag Word ... since if I wanted to I could allow
anyone to determine what word is an 'AdWord' and same for the description.

You can check out a description of how it works by going to
http://bashmyex.com/adword.php
and if you browse my site's main page, you will see many 'bashes' that offer
a mousever of certain words.... thats the AdWord system in action :P

If this is something like your talking about, then let me know
and I can help you develop it into a Tag Word type system.
howardr
Forum Newbie
Posts: 17
Joined: Mon Oct 31, 2005 1:33 pm

Post by howardr »

i found a bookmark on http://del.icio.us/search/?all=tags on how how they [del.icio.us] implements tags. The article i used can be found at http://www.pui.ch/phred/archives/2005/0 ... hemas.html .

i like how you do the javascript onover thing. I might put the top five popular images when a user puts his mouse over a certain tag.
Post Reply