create associative array from db results array using array row as index

Question

I created db query that joins four tables and returns the following results in an array in codeigniter.

I want to create an associative array using the client_id so I can group al the information for a client together and display it together. This is to produce a receipt. The same documents can be sent to different clients, so the receipt must be displayed per client.

I have tried to create a foreach loop to reorganize the array.

so what's your problem, are u reorganize your array with foreach — Nuriddin Rashidov
– Nuriddin Rashidov, Commented Oct 25, 2015 at 18:40

Hasse Björk · Accepted Answer · 2015-10-29 12:33:15Z

1

This will group the results into an array, the original array is called $arr:

$result = array();
foreach( $arr['results'] as $v ) {
    $result[$v->client_id][] = $v;
}

To get a single clients ($client_id) all result display them like this

foreach( $result[$client_id] as $res ) {
    // Use the data
    echo 'Slip: ' .  $res->slip_id . "<br />\n"
        . 'Title: ' . $res->dwg_title  . "<br />\n";
}

To display everything, ordered by client, do somethoing like:

foreach( $result as $client_id => $temp ) {
    echo 'Client_id: ' . $client_id . "<br />\n";
    foreach( $temp as $res ) {
        // Use the data
        echo 'Slip: ' .  $res->slip_id . "<br />\n"
            . 'Title: ' . $res->dwg_title  . "<br />\n";
    }
}

Is this an answer to your question?

Edit2 $res is an object...

A way to display a single client and a way to display all clients!

edited Oct 29, 2015 at 12:33

answered Oct 25, 2015 at 18:48

Hasse Björk

1,61114 silver badges19 bronze badges

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

6 Comments

user5051310 Over a year ago

OP asked for an associative array but this should provide the same result

Juan-Emil Saayman Over a year ago

@Hasse Thanks for your help. The first part of the code that you provided me with worked and gave me a rearranged array according to $client_id. I'm struggling with the next bit to pass the array to my view.

Hasse Björk Over a year ago

Thank you for pointing out the last part was in error. Of course it is an associative array, not an object. I have updated the script to show this!

Juan-Emil Saayman Over a year ago

@HasseBjörk So I've tried the updated code, but I keep running into problems to display it. I manage to get the post array of the $client_id from the previous view with which I create a $client array and pass to foreach($result[$client] as $res){...}. But I keep getting a Illegal offset type error. Unmodified Post array (client array) -

Array (     [1] => Array         (             [client_id] => 1         )      [3] => Array         (             [client_id] => 3         )  )

Hasse Björk Over a year ago

What are you trying to do with the data? Display a single client or display all clients?

|

Collectives™ on Stack Overflow

create associative array from db results array using array row as index

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related