Fetching objects from database in Symfony

Question

I have entity Domain which has fields id, domain, users in field users, I have an id which is the id of the user who created that domain.

now I have created for in the template which will display every domain that the user created.

I messed it up somehow and I don't know how to solve it.

workspaces.html.twig

{% for domain in workspaces %}
    <div class="workspace card">
        <div class="card-body">
            <h4 class="card-title">{{workspaces.number}}</h4>
            <a href="/project" class="card-link">Card link</a>
        </div>
    </div>
    {% endfor %}

MainController.php

public function show()
{
    //todo: show domains for current user
    $repository = $this->getDoctrine()->getRepository(Domain::class);

    $currentUser = $this->getUser()->getID();
    $workspaces = $this->getDoctrine()
        ->getRepository(Domain::class)
        ->findByUsers($currentUser);
    return $this->render('workspaces.html.twig',array('workspaces' => $workspaces));
}

DomainRepository.php

/**
 * @param $currentUser
 * @return Domain[] Returns an array of Domain objects
*/

public function findByUsers($currentUser)
{
    return $this->createQueryBuilder('d')
        ->andWhere('d.users = :val')
        ->setParameter('val', $currentUser)
        ->orderBy('d.id', 'ASC')
        ->setMaxResults(15)
        ->getQuery()
        ->getResult();
}

Error that I get: Key "domain" for an array with keys "0, 1" does not exist. currently, I got 2 records in the database but when I add more then the error shows more keys "0, 1, 2..."

I know that I somehow messed up for or something (bad naming does not help :( ).

what is {{workspaces.number}} supposed to be? what type of relation do you have between Domain and User, OneToOne, ManyToMany? — Arleigh Hix
– Arleigh Hix, Commented Nov 13, 2019 at 0:37
should be {{ domain.id }} instead of {{ workspaces.number }} — Rufinus
– Rufinus, Commented Nov 13, 2019 at 5:50
@ArleighHix I forgot to change "number" for "domain". relation is ManyToMany. — Alvin
– Alvin, Commented Nov 13, 2019 at 10:37
@Rufinus then i get Variable "workspaces" does not exist. — Alvin
– Alvin, Commented Nov 13, 2019 at 10:38
if the code you showed is all you have, thant it can't be. workspaces is defined in your controller - the for loop is the only one accessing the collection array. — Rufinus
– Rufinus, Commented Nov 13, 2019 at 10:47

awtzez · Accepted Answer · 2019-11-14 06:55:01Z

Did you check your query if its working? if its working there is a problem in your code

First let's clean a little the code.

MainController.php

    public function showAction()
    {
        //todo: show domains for current user

        $currentUser = $this->getUser()->getID();
        $workspaces = $this->getDoctrine()
            ->getRepository(Domain::class)
            ->getDomainsByUser($currentUser);

        return $this->render('workspaces.html.twig',array('workspaces' => $workspaces));
    }

DomainRepository.php

public function getDomainsByUser($currentUser)
{
    return $this->createQueryBuilder('d')
        ->andWhere('d.users = :val')
        ->setParameter('val', $currentUser)
        ->orderBy('d.id', 'ASC')
        ->setMaxResults(15)
        ->getQuery()
        ->getResult();
}

workspaces.html.twig

The problem in the code is in the twig part.
{{ domain.domain }} not {{ workspaces.number }}

{% for domain in workspaces %}
    <div class="workspace card">
        <div class="card-body">
            <h4 class="card-title">{{ domain.domain }}</h4>
            <a href="/project" class="card-link">Card link</a>
        </div>
    </div>
{% endfor %}

Nimantha · Accepted Answer · 2021-10-31 02:25:36Z

1

The naming seems a bit off since your Domain Entity seems to have a field called domain. So your solution would look like this:

{% for domain in workspaces %} //loop workspaces = every domain object
    <div class="workspace card">
        <div class="card-body">
            <h4 class="card-title">{{domain.domain}}</h4> //access domain field in object domain
            <a href="/project" class="card-link">Card link</a>
        </div>
    </div>
{% endfor %}

You loop over all domain objects and access the field you want to use, called domain.

edited Oct 31, 2021 at 2:25

Nimantha

6,5376 gold badges32 silver badges78 bronze badges

answered Nov 13, 2019 at 13:57

Syllz

3401 gold badge6 silver badges26 bronze badges

Collectives™ on Stack Overflow

Fetching objects from database in Symfony

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related