Get a value one time from array

Question

I've got an array generated from a SQL query :

<pre>
$df = $bdd->query('select * from V_Customer_Link where ref_customer in (select       ref_customer from V_Customer_Link group by ref_customer having count(*) >=4)');
$result = $df->FetchAll();
$df->closeCursor();
</pre>

When I do a print_r($result) I've got this :

As you can see, there is only two different ref_customer. In the future, there will be more.

I would like to display information from this array like this :

ALFKI : Rib, Carte Identité, Kbis, Contrat

BOLID : Rib, Carte Identité, Kbis, Contrat, Liasse fiscale

If I do a for or a while, the value ref_customer will be repeated each time. How can I limit this value once and get all the other?

you probably want to re-write your query to get the information you need, all attacked to the customer_ref you want. worst case, if that is not an option, just take every row, check what's in there, and build your own new array per customer_ref — Viridis, Dec 10 '13 at 15:31
This question is interesting to solve but should be simplified if possible. Unnecessesary complexity is evil. — Prashank, Dec 10 '13 at 15:37

score 1 · Answer 1 · answered Dec 10 '13 at 15:35

1

I'd create another array based on ref_customer and implode the values.

untested, but something along these lines

$ref_customers = array();
foreach($result as $r) {
    $ref_customers[$r['ref_customer']][] = $r['TypeDeDoc'];
}

foreach($ref_customers as $ref => $typededoc) {
    echo $ref . ' : ' . implode(", ", $typededoc);
}

answered Dec 10 '13 at 15:35

Aaron W.

9,254
2
34
45

Thanks a lot for you quick answer !! – Chris Dec 10 '13 at 15:53

score 0 · Answer 2 · answered Dec 10 '13 at 15:36

You need to individually collect your values from the base array. This can be done by iterating over the array values and storing them in another array.

You could do something like this (untested, but should work):

$return = array();

foreach($result as $r) {
    $key = $r['ref_customer'];
    $return[$key][] = $r['TypeDeDoc'];

    ////  and even this would work:
    // if (!array_key_exists($key, $return)) $return[$key] = array();
    // array_push($return[$key], $r['TypeDeDoc']);
}

foreach($return as $k => $v) {
    echo $k . ":" . implode(", ", $v);
}

This won't work because "ref_customer" can be inside another array (see my answer). You need to recursively check the $r and fetch that result. — Michael Villeneuve, Dec 10 '13 at 15:43

score 0 · Answer 3 · edited May 23 '17 at 12:29

Use a simple foreach() and organise your array how you would need it. For example :

$newArray = array();
foreach ( $yourArray as $record )
{
    $result = array_key_exists_r('ref_customer', $record); // use the function from the answer below
    $document = $record['TypeDeDoc'];
    $newArray[$result][] = $document;
}

Your new array will look like this :

["Alfki"] => Array
    (
        [0] => "Carte identité"
        [1] => "Contrat"
        [2] => "Autre document"
    )

Finding the key in a recursive way

Since you don't really know where the key is, you need to use a recursive function. There is a really good example with this answer.

@Chris don't forget to upvote/select the answer you used. It will help futur user to see what's working and what answer you used to solve your question. — Michael Villeneuve, Dec 10 '13 at 15:59

Get a value one time from array

3 Answers3