PHP multidimensional array algorithm?

Question

I need to form an multidimensional array as below format however I could not figure out the algorithm

array( [0]=>array( "id"=>"1","data"=>array([0]=>array("kid"=>"434","k"=>"Ali","m"=>"msj1"), [1]=>array("kid"=>"344","k"=>"Dali","m"=>"msj3")), [1]=>array( "id"=>"2","data"=>array([0]=>array("kid"=>"347","k"=>"Cenk","m"=>"msj2"), [1]=>array("kid"=>"345","k"=>"Tan","m"=>"msj4")))

the data comes from mysql query like below:

SELECT kid, k, m, id FROM table1 WHERE rid=1 ORDER BY (id)

sample data:

id kid k m 1 434 Ali msj1 2 347 Cenk msj2 1 344 Dali msj3 2 345 Tan msj4

php loop is as below:

do { //whatever I tried here failed :( } while ($t = mysql_fetch_assoc($r_tav));

I hope that I will understand multidimensional arrays better with this sample

do-while is not your friend here as you will not be able to access the $t array in the loop. — Narcis Radu
– Narcis Radu, Commented Nov 18, 2011 at 10:38
i think there should be a dummy variable to check if "id" change or not. depending on the change of id a new array to hold other data arrays should be formed. But some how i cant write down the code — aliaktas
– aliaktas, Commented Nov 18, 2011 at 11:01

Poonam Bhatt · Accepted Answer · 2011-11-18 11:06:36Z

4

$arrRows = mysql_fetch_array($r_tav); $arrRowData = array(); $arrRowDataFinal = array(); foreach ($arrRows as $key => $value){ $arrRowData[$value['id']][] = array("kid"=>$value['kid'],"k"=>$value['k'],"m"=>$value['m']); } foreach($arrRowData as $key => $value){ $arrRowDataFinal[] = array('id' => $key, 'data' => $value); }

answered Nov 18, 2011 at 11:06

Poonam Bhatt

10.4k16 gold badges56 silver badges73 bronze badges

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

2 Comments

aliaktas Over a year ago

i tried the code, i generates the arrays in right format however it fails to collect data in common "id" arrays. i will work on to generate correct output

aliaktas Over a year ago

your solution is correct one, except we need to form the array of raw data in to $arrRows.. i do that with code of

$t = mysql_fetch_assoc($r_tav); $row_sayi = mysql_num_rows($r_tav); if ($row_sayi > 0) { do { $tav_a[]=$t; $op=$t; } while ($t = mysql_fetch_assoc($r_tav)); } $arrRows = $tav_a;

betters ways of generating above array is welcome.. tahnks Poonam, thanks stackoverflow

Jan Dragsbaek · Accepted Answer · 2011-11-18 10:46:17Z

4

It seemed like all you want is:

while ($t = mysql_fetch_assoc($r_tav)){ $arr[] = $t; }

and $arr will contain your array

After re-reading the question, it seems that it is not exactly the structure you want, but it can simply be turned into:

while ($t = mysql_fetch_assoc($r_tav)){ $arr[] = array('id' => $r_tav['id'], 'data' => array('kid' => $r_tav['kid'], 'k' => $r_tav['k'], 'm' => $r_tav['m'])); }

edited Nov 18, 2011 at 10:46

answered Nov 18, 2011 at 10:36

Jan Dragsbaek

8,1212 gold badges28 silver badges46 bronze badges

5 Comments

aliaktas Over a year ago

i wish it could be such simple however as you can see there are nested arrays including data related with the same id

Jan Dragsbaek Over a year ago

i updated the post with a snippet that should generate the correct array

aliaktas Over a year ago

this one is improved however how can i collect the data with the same id inside one array named "data" ?

Jan Dragsbaek Over a year ago

that is beyond the original question, and adds a new layer of complexity

aliaktas Over a year ago

it is my mistake to fully wrote down the final array, now we have a solution. hope that it will help others with the same need. thanks for your effort

Collectives™ on Stack Overflow

PHP multidimensional array algorithm?

2 Answers 2

2 Comments

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Related