How to separate JSON Array with space in PHP

Question

I have a JSONArray as

{"test":
[
{"Name":"aaa","Reg/Admission Number":"001"},
{...}]}

And I can separate Name by

$read_data = array();
foreach ($data->test as $result){
  $name = $result->Name;
  $read_data[] = "('$name')";
}

the result of read_data as ('aaa'),('bbb')...

Anyone can suggest how to separate the array of Reg/Admission Number which has the special character as '/' and 'space'

inside the for each add this var_dump($result); and look the name of that field. — Jorge Campos
– Jorge Campos, Commented Jan 13, 2015 at 4:50
have you tried using an escape character? like Reg\/Admission\ Number? alternatively i believe $result->{'Reg/Admission Number'} should work — haxxxton
– haxxxton, Commented Jan 13, 2015 at 4:51
@haxxxton $result->{'Reg/Admission Number'}` it works fine.. thanks for your suggestion — No_Rulz
– No_Rulz, Commented Jan 13, 2015 at 4:54

vishwa · Accepted Answer · 2015-01-13 05:22:17Z

4

Why Dont you use the php function

json_encode() http://php.net/manual/en/function.json-encode.php
json_decode() http://php.net/manual/en/function.json-decode.php

answered Jan 13, 2015 at 5:22

vishwa

4306 silver badges18 bronze badges

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

Comments

No_Rulz · Accepted Answer · 2015-01-13 04:56:44Z

1

As per @haxxxton suggestion it works

 $read_data = array();
    foreach ($data->test as $result){
      $name = $result->Name;
      $no = $result->{'Reg/Admission Number'}`
      $read_data[] = "('$name','$no')";
    }

answered Jan 13, 2015 at 4:56

No_Rulz

2,7192 gold badges22 silver badges34 bronze badges

Comments

parveen · Accepted Answer · 2015-01-13 04:50:24Z

0

You can convert json array to PHP array first and then can do your operation.

answered Jan 13, 2015 at 4:50

parveen

5773 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to separate JSON Array with space in PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related