structure php array with db data

Question

I have an array returned from db with this structure:

[0] array(2) {
  ["Brand"] "A"
  ["Family"] "B"
}
[1] array(2) {
  ["Brand"] "A"
  ["Family"] "C"
}
[2] array(2) {
  ["Brand"] "A"
  ["Family"] "D"
}
[3] array(2) {
  ["Brand"] "B"
  ["Family"] "ABC"
}
[4] array(2) {
  ["Brand"] "B"
  ["Family"] "DD"
}

I need to create an array like so:

[0] array(2) {
  ["Brand"] "A" array() {
    "B",
    "C",
    "D"
}
[1] array(2) {
  ["Brand"] "B" array() {
    "ABC",
    "DD"
}

So basically, the Brand should be unique and inside each brand i need a list of families.

Have you tried anything?

Sougata Bose
– Sougata Bose

2015-10-28 11:43:59 +00:00
Commented Oct 28, 2015 at 11:43 — Sougata Bose
– Sougata Bose, Commented Oct 28, 2015 at 11:43

Lepanto · Accepted Answer · 2015-10-28 12:45:19Z

2

Try following, $mainarray is the array you have now

$brand = array();
foreach($mainarray as $v){
    $brand['Brand'][$v['Brand']][] = $v['Family'];
}

answered Oct 28, 2015 at 12:45

Lepanto

1,3981 gold badge8 silver badges15 bronze badges

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

Comments

Richard EB · Accepted Answer · 2015-10-28 12:33:45Z

0

This is a simple array recursion exercise.

Here's some PHP pseudo code:

$output = array();

foreach($array as $i){
//loop through the array returned from the db

$output[$i["brand"]] = array_unique(array_merge($output[$i["brand"]], array($i["Family"])));
//merge the existing families for the brand with the current iteration's, and maintain a set datastructure (no duplicate entries for each family)
}

var_dump($output);

answered Oct 28, 2015 at 12:33

Richard EB

1,03711 silver badges25 bronze badges

Comments

Amrinder Singh · Accepted Answer · 2015-10-28 12:42:06Z

0

here is what you required:

<?php

$array1=array(array('Brand'=>'A','Family'=>'B'), array('Brand'=>'A','Family'=>'C'), array('Brand'=>'A','Family'=>'D'), array('Brand'=>'B','Family'=>'ABC'), array('Brand'=>'B','Family'=>'DD'));


$brand=array();

        foreach($array1 as $value=>$data){
            foreach($data as $value2=>$data2){
                if($value2=='Family'):
                    if($value<3):
                    $brand['Brand']['A'][]=$data2;
                    else:
                    $brand['Brand']['B'][]=$data2;
                    endif;
                endif;
            }
        }

echo "<pre>";
print_r($brand);
echo "</pre>";  

?>

answered Oct 28, 2015 at 12:42

Amrinder Singh

5,62213 gold badges50 silver badges95 bronze badges

Collectives™ on Stack Overflow

structure php array with db data

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related