generate arrays from string

Question

When I run :

while($r = mysql_fetch_assoc($result3)) { 

echo json_encode($r); 

}

the results is :

{"test1":"1","test2":"2","test3":"3","test4":"4"}

{"test1":"5","test2":"5","test3":"7","test4":"8"}

my question is : How can I create arrays from the results above knowing that the number of lines is not fixed, it may change depend on the data. So, I could make changes to the arrays and parse it in a format similar to this :

["test1"=>"1","5"],

["test2"=>"2","6"], 

["test3"=>"3","7"], 

["test4"=>"4", "8"]

Thanks!!

please print_r($result3); then put the result over here whatever it display its easy to help it out — Jalpesh Patel
– Jalpesh Patel, Commented Aug 21, 2012 at 7:08
@Jalpesh: $result3 is (presumably) a MySQL resource identifier. — eggyal
– eggyal, Commented Aug 21, 2012 at 7:09
@kech: One assumes that the change in the second value for test2 (from 5 in the current output to 6 in the desired output) is merely a typo? In any event, each array element has its own key so the desired output as shown doesn't really make sense: perhaps you are instead after something like { "test1" : [1,5], "test2" : [2,5], ... } ? — eggyal
– eggyal, Commented Aug 21, 2012 at 7:11
@Jalpesh: yes - it's a MySQL resource identifier. print_r($r) gaves: ( [test1] => 1 [test2] => 2 [test3] => 3 [test4] => 4 ) Array ( [test1] => 5 [test2] => 6 [test3] => 7 [test4] => 8 ) — mongotop
– mongotop, Commented Aug 21, 2012 at 7:19

Dr.Kameleon · Accepted Answer · 2012-08-21 07:37:13Z

6

Try this :

<?php

$arr = array();

while ($r = mysql_fetch_assoc($result3)) 
{ 
    foreach ($r as $index=>$item)
    {
        $arr[$index][]=$item;
    }
}

?>

And to encode as JSON (after re-arranging the array) :

$arr = json_encode($arr);

edited Aug 21, 2012 at 7:37

answered Aug 21, 2012 at 7:12

Dr.Kameleon

22.8k21 gold badges124 silver badges241 bronze badges

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

12 Comments

eggyal Over a year ago

+1 For completeness, I'd also show where you perform the json_encode() here (i.e. after exiting the while loop).

Dr.Kameleon Over a year ago

@eggyal IF he actually wants it as Json. (my guess is that he used json only as a means of showing as the output)

eggyal Over a year ago

Perhaps... but the question is tagged javascript and json, so my guess is not.

eggyal Over a year ago

If I was to be really pedantic, I'd point out that your edit still doesn't clarify exactly where the call to json_encode() should be placed. But I'm not gonna do that. ;)

mongotop Over a year ago

when I run print_r($arr[$index]); inside foreach I get the values without the keys : ( [0] => 1 ) Array ( [0] => 2 ) Array ( [0] => 3 ) Array ( [0] => 4 ) Array ( [0] => 5 ) Array ( [0] => 6 ) Array ( [0] => 7 ) Array ( [0] => 8 ) wherever I put $arr = json_encode($arr); inside or outside the while loop, when I run print_r($arr); it dispay ( [test1] => Array ( [0] => 5 ) [test2] => Array ( [0] => 6 ) [test3] => Array ( [0] => 7 ) [test4] => Array ( [0] => 8 ) )

|

Collectives™ on Stack Overflow

generate arrays from string

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related