Get an array of arrays in PHP with a loop

Question

I am working on Symfony 3.4 in PHP 5.6.

Here is the context of my problem:

I have an "information" table that contains several lines. I want to sort these lines and display them according to a certain column called "Zone". So the goal is to have for example

"Zone 1" * Lines of information corresponding to this area " "Zone 2" * Lines of information corresponding to this area " ...

I realized my functions in the Repository, and I also made the layout under Twig. Everything worked. All I had to do was optimize my code on the controller to make it cleaner.

My idea was therefore:

Retrieve an array containing all the existing distinct areas by a query.
Loop on this array using each value of the array as a parameter for the SQL query that retrieves the rows corresponding to the passed field and retrieve them in an array variable
Make an array_push () of the array of each zone, in another array that will contain the array of each zone.

But I can't. This is my code

Repository :

public function getInformationsZone($zone)
    {
        $queryBuilder = $this->createQueryBuilder("i")
        ->where("i.zone = :zone")
        ->orderBy("i.updatedAt","DESC")
        ->orderBy("i.criticite","DESC")
        ->setParameter('zone',$zone);

        return $queryBuilder->getQuery()->getResult();
    }

    public function getZonesActives()
    {
        $queryBuilder = $this->createQueryBuilder("i")
        ->select("i.zone")
        ->distinct(true);

        return $queryBuilder->getQuery()->getResult();
    }

controller

/**
     * Lists all information entities.
     *
     * @Route("/", name="informations_index")
     * @Method("GET")
     */
    public function indexAction()
    {
        $em = $this->getDoctrine()->getManager();

        $information = $em->getRepository('PagesBundle:Information')->findAll();


        $listZones = $this->getDoctrine()->getRepository('PagesBundle:Information')->getZonesActives();
        $tabInfos = array();

        foreach($listZones as $key=>$value)
        {
            $zone = $this->getDoctrine()->getRepository('PagesBundle:Information')->getInformationsZone($value);
            array_push($tabInfos,$zone);
        }



// This is what i did just before

      /*  $infosZone1 = $this->getDoctrine()->getRepository('PagesBundle:Information')->getInformationsZone("Zone 1");
        $infosZone2 = $this->getDoctrine()->getRepository('PagesBundle:Information')->getInformationsZone("Zone 2");
        $infosZone3 = $this->getDoctrine()->getRepository('PagesBundle:Information')->getInformationsZone("Zone 3");

        $tabInfos = array($infosZone1,$infosZone2,$infosZone3);*/

        return $this->render('information/index.html.twig', array(
           /* 'information' => $information,
            'infosZone1'=> $infosZone1,
            'infosZone2'=> $infosZone2,
            'infosZone3'=> $infosZone3,*/
            'tabInfos'=>$tabInfos,
        ));
    }

I've this error :

An exception occurred while executing 'SELECT i0_.id AS id_0, i0_.contenu AS contenu_1, i0_.updated_at AS updated_at_2, i0_.zone AS zone_3, i0_.titre AS titre_4, i0_.criticite AS criticite_5 FROM information i0_ WHERE i0_.zone = ? ORDER BY i0_.criticite DESC' with params ["Zone 1"]:

SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

Possible duplicate of "Invalid parameter number: parameter was not defined" Inserting data — Yassine CHABLI
– Yassine CHABLI, Commented Mar 26, 2019 at 12:52
Dump $value parameter in the loop and see the actual value of it. If it's returning only a string likeZone 1. — Canser Yanbakan
– Canser Yanbakan, Commented Mar 26, 2019 at 13:15
Using $zone = $this->getDoctrine()->getRepository('PagesBundle:Information')->getInformationsZone($value); I have : array:1 [▼ "zone" => "Zone 1" ] — Agar io FR
– Agar io FR, Commented Mar 26, 2019 at 13:26
It's okay, i updated ($value) by ($value['zone']. It's work, thanks ! — Agar io FR
– Agar io FR, Commented Mar 26, 2019 at 13:38

Canser Yanbakan · Accepted Answer · 2019-03-26 13:22:45Z

1

Replace:

$zone = $this->getDoctrine()->getRepository('PagesBundle:Information')->getInformationsZone($value);

With this:

$zone = $this
    ->getDoctrine()
    ->getRepository('PagesBundle:Information')
    ->getInformationsZone($value->getZone());

You are passing the all zone entity to the getInformationsZone method.

So to get the title of the zone, you must call the getter of the zone.

$value to $value->getZone();

Edit: So, just change $value->getZone() to $value['zone'];

edited Mar 26, 2019 at 13:22

answered Mar 26, 2019 at 12:52

Canser Yanbakan

3,8903 gold badges43 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Agar io FR Over a year ago

I updated my code. But I have this error : Error: Call to a member function getZone() on array My getZonesActives() function return a string array, not an objects array :/

Canser Yanbakan Over a year ago

@AgarioFR Updated the codes. Just see the last line.

Collectives™ on Stack Overflow

Get an array of arrays in PHP with a loop

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related