JSON decode Array and insert in DB

Question

I have some issue with a decoded Json object sended to a php file. I have tried some different format like this

{"2":"{Costo=13, ID=9, Durata_m=25, Descrizione=Servizio 9}","1":"{Costo=7, ID=8, Durata_m=20, Descrizione=Servizio 8}"}

or this.

[{"Costo":"7.5","ID":"3","Durata_m":"30","Descrizione":"Barba Rasoio"},{"Costo":"4.5","ID":"4","Durata_m":"20","Descrizione":"Barba Macchinetta"}]

In order the first, any suggestions helps me, then i have converted previous string using GSON, however php doesn't decode.

This is my php:

//Receive JSON
 $JSON_Android = $_POST["JSON"];
//Decode Json
$data = json_decode($JSON_Android, true);
foreach ($data['servizi'] as $key => $value) 
    { echo "Key: $key; Value: $value<br />\n";
 }

How can I access single elements of array? What I'm doing wrong? Thanks in advance

I haven't code here, but if I remember correctly, it's the string above without initial number {"1": — Jayelef
– Jayelef, Commented Oct 7, 2015 at 19:03

ScaisEdge · Accepted Answer · 2015-10-07 18:24:53Z

1

I think you should check the content in this way

//Receive JSON
$JSON_Android = $_POST["JSON"];
//Decode Json
$data = json_decode($JSON_Android, true);
foreach ($data as $key => $value) { 
    echo "FROM PHP:  " . $value;

    echo "Test : " .$value['ID'];

}

answered Oct 7, 2015 at 18:24

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

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

2 Comments

Jayelef Over a year ago

Here I am. This is the output of echo test: Warning: Illegal string offset 'ID' in D:\...etc

Jayelef Over a year ago

bold 'It Works!' Using string converted by GSON in this format [{"Costo":"7.5","ID":"3","Durata_m":"30","Descrizione":"Barba Rasoio"}] I'm able to access to elements of array. Thank you

azngunit81 · Accepted Answer · 2015-10-08 13:15:39Z

0

your elements of {Costo=7, ID=8, Durata_m=20, Descrizione=Servizio 8}

are not properly formated as an array element. That is a pure string and not an array value.

This is a json object with 1 element of array:

{
  "1": {
    "Costo": 7,
    "ID": 8,
    "Durata_m": 20
  }
}

The Inside are json objects. Therefore your json string was not properly formated to operate with that logic. What you had was an element of a string. That is the reason why it was a valid json (passing jsonlint) but was not the correct one that you wanted to use.

UPDATE Because this format is fix, I have a non-elegant way:

//Receive JSON
$JSON_Android = $_POST["JSON"];
//Decode Json
$data = json_decode($JSON_Android, true);
foreach ($data as $key => $value) { 
    //to separate each element
    $newArray = explode(',',$value);
    $newItem = explode('=', $newArray[1]);
    echo "ID". $newItem[1];
}

That would be the dirty way to do it ONLY IF THE PLACEMENT OF DATA IS FIX. (ie the second element of the first explode is always ID.

I will leave it to someone else to make the suggested code better. I would recommend more to ensure that the json you are receive is proper because as I explained, it is incorrectly formated and as an api developer, you want an adaptive way for any given client to use the data efficiently.

edited Oct 8, 2015 at 13:15

answered Oct 8, 2015 at 12:27

azngunit81

1,6043 gold badges22 silver badges40 bronze badges

4 Comments

Jayelef Over a year ago

Thank you for response. I had imagined that problem was just this string, but i don't know how to change or reformat it. It cames from a listview selection on android listview, and i have followed some tutorial to convert to json object. Have you any suggest or solution?

azngunit81 Over a year ago

@Jayelef I added more detail and suggested code with explanation, but it is not the 100% solution, you will need to take it and work with it.

Jayelef Over a year ago

Well, while you had suggested your code, i'm trying to change method to create the array. I'm just working yet, however i have copied your snippet and i have tested it. This is the output: Warning: explode() expects parameter 2 to be string, array given in D:\inetpub...etc

Jayelef Over a year ago

Using GSON library, i have converted the string to send in this format [{"Costo":"4.5","ID":"4","Durata_m":"20","Descrizione":"Barba Macchinetta"},{"Costo":"7.5","ID":"3","Durata_m":"30","Descrizione":"Barba Rasoio"}], but now i'm not able to decode it in php file. Always error. Blob...(

Collectives™ on Stack Overflow

JSON decode Array and insert in DB

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related