how can the following data be organized into arrays in php

Question

I have these following values from a db using mysql_fetch_assoc()

Id - Val
0 - TextA
0 - TextB
1 - TextC
2 - TextD
2 - TextE
3 - TextF

I need to add these values into an array in php which can club values like this

0 - TextA,TextB
1 - TextC
2 - TextD,TextE
3 - TextF

Can't you do this at the db query? I had a similar requirement when using MySQL so I used group_concat - very handy. — tomfumb
– tomfumb, Commented May 10, 2011 at 19:03
@user519575: that's a good suggestion. I'd recommend posting it as an answer :) — Matchu
– Matchu, Commented May 10, 2011 at 19:05
@MeLight: the input format is unclear :/ I'm guessing he isn't getting the data as anything right now, and is just deciding what to put inside the loop where he's running mysql_fetch_array. — Matchu
– Matchu, Commented May 10, 2011 at 19:05
I read this incorrectly as wanting string array values (TextA,TextB). — No Results Found
– No Results Found, Commented May 10, 2011 at 19:10

Peter Porfy · Accepted Answer · 2011-05-10 19:06:49Z

2


$organized = array();

foreach($rows as $r)
{
  if (!isset($organized[$r['Id']]))
  {
    $organized[$r['Id']] = array();
  }
  $organized[$r['Id']][] = $r['Val'];
}

answered May 10, 2011 at 19:06

Peter Porfy

9,0603 gold badges33 silver badges41 bronze badges

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

Comments

tereško · Accepted Answer · 2011-05-10 19:05:14Z

2

Keep it in something like this.

array(
   0 => array( 'TextA', 'TextB' ),
   1 => array( 'TextC' ),
   2 => array( 'TextD', 'TextE'),
   3 => array( 'TextF')
);

You can fill it with:

$array = array();
foreach ( $data as $item )
{
   $id = $item['id'];
   if ( !array_key_exists( $id , $array))
   {
      $array[$id] = array();
   }
   $array[ $id ][] = $item['value'];
}

answered May 10, 2011 at 19:05

tereško

58.5k26 gold badges100 silver badges151 bronze badges

Collectives™ on Stack Overflow

how can the following data be organized into arrays in php

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