>From my experience with Codeigniter, thats one of the best php frameworks I have ever seen. It functionality is awesome, you can integrate your own modifications to the IC core without any problems at all, for more confortable you even don't have to use a template system (but I'm pretty sure that you can integrate Smarty to IC) and write your template with a pseudo code, CI supports <?php ?> code inside your template! Nitsan 2008/7/29 Jason Norwood-Young <jason@xxxxxxxxxxxxxxxxxxx> > > On Mon, 2008-07-28 at 23:57 +0100, 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! =) > > > > Many thanks > > > > Paul > > In that case, I suggest the following solution: > 1. Download the unternet into your puter > 2. Open the file called mysql.com > 3. Read and learn > 4. Open the file called php.net > 5. Read and learn > 6. Rinse and repeat > > In all seriousness, this is a nice, simple project to learn on. You want > to look at different types of relationships in Sql (one-to-one, > one-to-many and many-to-many) and learn a bit about basic DB > architecture; make some tables and play with getting data in and out > (get PHPMyAdmin to help you out); maybe use a nice simple framework like > CodeIgniter to get you kick-started on the PHP. > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
