19 Apr 2011 12:05 AM #1
Manipulating data from 2 database tables
I have just been pointed to ExtJS as a good candidate for a project I'm on, but there is too much information to get an overview of where to get started. I hope someone here can help me.
I have a database table (mysql) with millions of rows and a table for classifying the rows (with a table keeping track of relations between records in each). It's like a table with posts and one with tags, and a post_tags table.
I need a way to display a grid with data from the posts table and all the tags each post has, in each grid row. I need to be able to add/delete tags for each post, but I also need to be able mark all of the results in a search (query) and tag them.
I hope this makes sense and that I'm asking the question in the right place. I would really be grateful if someone can point me in the right direction.
19 Apr 2011 3:10 AM #2
19 Apr 2011 6:11 AM #3
The best alternative that suits my needs is to follow a tutorial like http://superdit.com/2010/07/10/crud-...s-grid-part-1/ and adapt for tagging multiple rows instead of editing users. Any other suggestions are very welcome.
19 Apr 2011 7:34 AM #4
How many tags per item are we talking - roughly?????
19 Apr 2011 11:14 PM #5
Roughly 10-20 tags per item, on average. On the whole, it would probably range from 0 to 50, but the vast majority would have no more than 20 tags.
20 Apr 2011 11:03 AM #6
How do you envision it being displayed?
Need to get an idea as there are various possibilities and there's no point someone on here assisting with a solution if it's not what you want.
23 Apr 2011 10:25 AM #7
26 Apr 2011 1:15 AM #8
Any suggestions on how to implement this?
By niblettes in forum Ext 3.x: Help & DiscussionReplies: 3Last Post: 24 Dec 2010, 1:21 AM
By whanonalane in forum Ext 3.x: User Extensions and PluginsReplies: 0Last Post: 24 May 2010, 5:25 AM
By stevieke in forum Ext 2.x: Help & DiscussionReplies: 1Last Post: 17 Apr 2009, 12:58 AM
By robin30 in forum Ext 1.x: Help & DiscussionReplies: 6Last Post: 6 Sep 2007, 11:47 AM
By devnull in forum Ext 1.x: Help & DiscussionReplies: 7Last Post: 12 Jul 2007, 1:49 PM