[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-general
Subject:    Re: [PHP] Web2.0 style tags - where to start?
From:       Børge_Holen <borge () arivene ! net>
Date:       2008-07-29 8:16:03
Message-ID: 200807291016.03572.borge () arivene ! net
[Download RAW message or body]

On Tuesday 29 July 2008 00:57:22 Paul Jinks wrote:
> Jason Norwood-Young wrote:
> > On Mon, 2008-07-28 at 14:48 +0100, Paul Jinks wrote:
> > > I think my first post was ambiguous. What we're thinking of is to build
> > > a site on which people can view videos with the option to add metadata
> > > to a video after viewing it.
> > > 
> > > We think that the content we have will be of wide interest to a lot of
> > > people and the best way to index it is for users to 'tag' it themselves,
> > > since it's hard for us to anticipate the uses that people may have for
> > > the content.
> > 
> > How do you plan to have users enter the info? Through the Flash player,
> > through some kinda Ajax form, through a form in a frame or just a static
> > form?
> > 
> > Also, would the tags be predefined by you (eg. genres like the ID3 tag
> > genres) or would people be able to add their own tags?
> > 
> > The way I'd do it would be to let the users enter the info through an
> > Ajax form below the video, with suggestions popping up as they type.
> > Then save it in a separate table (I assume all your vids are in their
> > own table) with a link table between the vids table and the tags table
> > (M2M relationship). This means that if the tag is already in there and
> > linked to one vid, you don't replicate it for a second vid. It's also
> > very easy to do lookups of similar items. I'd also add a weighting to
> > the tags in the links table, maybe with the more people that add a
> > specific tag, the more weight that tag gets.
> > 
> > Also check out http://www.music-map.com/ as an example of showing
> > similar music - you might even be able to plug into this data.
> 
> Hi Jason
> 
> Hmm, food for thought. music-map is brilliant, though not what I'm
> looking for graphically at the moment (was surprised to find Cesaria
> Evora in close proximity to The Cardigans but I digress).
> 
> What you describe is pretty much what I'm chasing, thanks and helps me
> down the road, particularly with thinking about the database set up.
> They 'only' problem is, my php/mysql skills are some way behind my
> javascript/actionscript  knowhow (I'm pretty much a noob here);  what I
> could use now is a how-to tutorial to give me some code to work off,
> either online or in a book. If it ain't there, I can build from scratch
> but it's going to mean a lot of calls for help! =)

http://www.google.com/search?q=mysql+php+tutorials&ie=utf-8&oe=utf-8&aq=t&rls=org.debian:en-US:unofficial&client=iceweasel-a
 I like from scratch... =D I guss I can do that cuz I don't make a living out 
of it ;D

> 
> Many thanks
> 
> Paul



-- 
---
Børge Holen
http://www.arivene.net

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[prev in list] [next in list] [prev in thread] [next in thread]