Convert php multidimensional array to json format to use in Jquery $.post

Question

With fetchAll(PDO::FETCH_ASSOC) get such array

$array = 
Array
(
    [0] => Array
        (
            [FinalCurrencyRate] => 0.000062
        )
)

Need to json_encode to use in

$.post("__02.php", { 'currency': currency }, function(data, success) {
$('#currency_load').html(data.FinalCurrencyRate);
$('#currency_load0').html(data.FinalCurrencyRate0);
$('#currency_load1').html(data.FinalCurrencyRate1);//and so on
}, "json");

If simply echo json_encode($array); then does not work.

Need to convert to json format array like this:

$arr = array ('FinalCurrencyRate'=>"0.000062");

To convert to json format, wrote such code

$json_array = "{";
$flag_comma = 0;
foreach($array as $i =>$array_modified) {

if ($flag_comma == 0) {
$json_array .="'FinalCurrencyRate". $i."'=>'". $array_modified[FinalCurrencyRate]. "'";
$flag_comma = 1;
}
else {
$json_array .=", 'FinalCurrencyRate". $i."'=>'". $array_modified[FinalCurrencyRate]. "'";
}

}
$json_array .= "}";

Then echo json_encode($json_array);. And only one echo json_encode.

But does not work.

Understand that there are errors in code to convert to json format. What need to correct, please?

Just a little question back: Do you know what the 404 status code stands for? — hakre
– hakre, Commented Aug 25, 2013 at 8:06
OK. But the question is about php code convert php array json format array. There is some errors in code and need to understand what to correct. — user2465936
– user2465936, Commented Aug 25, 2013 at 8:09
@user2465936 404 Not Found means that you are trying to access a page that doesn't exist. Most likely you made a typo in your url. json_encode is perfectly able to turn a multidimensional array into a json string. — Sumurai8
– Sumurai8, Commented Aug 25, 2013 at 8:11
@user2465936 No, that is not what a 404 error means. A 404 error is invoked by your httpd service. It never executes your page. — Sumurai8
– Sumurai8, Commented Aug 25, 2013 at 8:14

omma2289 · Accepted Answer · 2013-08-25 08:32:22Z

1

If I understand correctly you just want to return the first row form your array, then you just need to do this

echo json_encode($array[0]);

UPDATE

I think I see what you're trying to do now, you're trying to append the index to the FinalCurrencyRate key in each row. No need to do that, what you should do is change your javascript code to look like this:

$('#currency_load0').html(data[0].FinalCurrencyRate);
$('#currency_load1').html(data[1].FinalCurrencyRate);//and so on

edited Aug 25, 2013 at 8:32

answered Aug 25, 2013 at 8:20

omma2289

54.7k8 gold badges66 silver badges68 bronze badges

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

1 Comment

user2465936 Over a year ago

Want to return whole array. May be to use inside foreach $array[$i]. Thanks for advice. I will try (may be to modify array).

Collectives™ on Stack Overflow

Convert php multidimensional array to json format to use in Jquery $.post

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related