Hi I am developing a movie database app with symfony and facing few problems My Problem is One content will have many roles, like: Actor, Actress, Director.. One Artist may have many role within one content. Now i dont know how can i build the relational entity table. I would like to have a cast table where content_id, role_id, artist_id will be saved.
the next issue is i want to enter all data from content form, where I would like to have all roles from db will be displayed as HTML label and next to it artist name box dropdown.
You can use the FOSUserBundle ;) Then you have users (= Artist etc.) and you have multiple roles for each user.
Or if you would realize your idea, create a entity ContentRoleArtist with your fields.
Then use filters (custom query builder) for your forms, so you can display all roles from db - within content - in the dropdown.
Or you take a look at ACLs. So you can define roles for each object/entity. Maybe thats better for you?
For the 15 $ I help you to create your entity so that works. (The middle idea)
And i help you with the query builder, so that you have a dropdown with the contents artists.