Using Symfony 4, I'm looking at the documentation for choicetype here and I see this
use App\Entity\Category; use Symfony\Component\Form\Extension\Core\Type\ChoiceType; // ... $builder->add('category', ChoiceType::class, [ 'choices' => [ new Category('Cat1'), new Category('Cat2'), new Category('Cat3'), new Category('Cat4'), ],
I assume that by calling
new Category('Cat1') that it would basically do a lookup in the database of that record based of something like a name field.
How do you do that in the Entity constructor? Unfortunately I don't see any documentation on how that would be done? Or is it just making a new category there (though I fail to see how this would work as it would be missing the database id without a lookup)?
Basically I have the following:
Employee Table - employee_id Employee Roles Table - employee_id - role_id Roles Table - role_id
So one employee can have many roles. I use a mapping table to do this. What I need is a choicetype that gives me all the roles (all records from Roles table) and then selects the ones that are found in the mapping table (Employee Roles where employee_id = x)