php - Why I can't format my JSON object? -

-

i'm trying construct json object containing inner objects.

i'm trying following code - $ids array containing ids:

$result = array();  foreach ($ids $value) {     $temparray = getcustomoptions($host, $dbusername, $dbpassword, $dbname, $_session['companyid'], $value);     array_push($result, $temparray); }     print_r(json_encode($result));

the getcustomoptions() returns array using following script:

$dataarray = []; while ($stmt->fetch()) {       $dataarray[] = array(            'id' => $id,            'description' => $description       ); }

the problem when print_r(json_encode($result)); i'm getting following result:

[     [         {             "id":21,             "description":"bshd"         },         {             "id":22,             "description":"gandhi "         },         {             "id":23,             "description":"aaaa"         },         {             "id":24,             "description":"bbbbb"         }     ],     [         {             "id":12,             "description":"121"         },         {             "id":13,             "description":"qwe"         },         {             "id":16,             "description":"wd2"         },         {             "id":17,             "description":"we"         }     ],     [     ] ]

as can see returns arrays inside of array, need following structure:

{      "data1":[         {             "id":21,             "description":"bshd"         },         {             "id":22,             "description":"gandhi "         },         {             "id":23,             "description":"aaaa"         },         {             "id":24,             "description":"bbbbb"         }     ],     "data2":[         {             "id":12,             "description":"121"         },         {             "id":13,             "description":"qwe"         },         {             "id":16,             "description":"wd2"         },         {             "id":17,             "description":"we"         }     ]  }

i know i'm missing small , basic here, me json manipulation in php still hard.

can give me clue or push?

you can try following code generate array in proper format. code not tested please check once.

$result = array(); $i=1; foreach ($ids $value) {       $temparray = getcustomoptions($host, $dbusername, $dbpassword, $dbname, $_session['companyid'], $value);     $result['data'.$i] = $temparray;     $i++; }

Comments

Post a Comment

Popular posts from this blog

php - Using str_replace to translate a MySQL Table in html -

-
i have website contains pricelist of cs:go items. now, how did this: mysql db w/ prices --> select db x ( item name ) --> echo table ( works fine ) now want translation of item names. how planned it: mysql db --> $result= ( signature character ) --> $translate = str_replace (signature character $result) however, there's issue code or str_replace think. $translate returns $result no filtering. <?php require 'lang.php'; $servername = "localhost"; $username = ""; $dbname = ""; $password = ""; // create connection $conn = new mysqli($servername, $username, $password, $dbname); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } // filter name $sql = "select name, price utf name 'k%'"; $result = $conn->query($sql); // translate $tr = str_replace('k','karambit','$result'); // ech...
Read more

SQL Server - MyCTE query based on 24 hour period (next day) -

-
i have bit of code: ;with mycte ( select *, row_number() over(partition carduser order cardtableid) newvariation cardchecker ) update mycte set status = newvariation which updates status column, want happen on 24 hour period, status starts again next day @ 1, , counts again based on carduser specified above: current data , happens: 2 aaa 1 2015-06-25 08:00:00.000 123 1 null 3 ccc 1 2015-06-25 00:00:00.000 124 1 null 4 aaa 1 2015-06-25 17:30:00.000 125 2 null 5 aaa 1 2015-06-26 17:30:00.000 125 *3* null what want happen: 2 aaa 1 2015-06-25 08:00:00.000 123 1 null 3 ccc 1 2015-06-25 00:00:00.000 124 1 null 4 aaa 1 2015-06-25 17:30:00.000 125 2 null 5 aaa 1 2015-06-26 17:30:00.000 125 *1* null im not quite sure how add above query possible point me in right direction? the main problem eventtime field contains both date , time, adding partition means status 1 based on time parameter of field thanks ...
Read more

asp.net mvc - Cannot display error message on Editor or EditorFor -

-
in mvc application, can display error messages inputs i.e. textboxfor , dropdownlist , etc. however, using same approach, cannot show validation error kendo().editor() or kendo().editorfor() . tried validationmessage beside validationmessagefor , not make sense. might problem be? view: <script type="text/javascript"> $(function () { //for using kendo validation: $("form").kendovalidator(); }); </script> //validation works textboxfor, dropdownlist, etc.: @html.labelfor(m => m.summary) @html.textboxfor(m => m.summary, new { maxlength = 50, @class = "k-textbox"}) @html.validationmessagefor(m => m.summary) //validation not work editor or editorfor: @html.labelfor(m => m.description, new { maxlength = 1000, @class = "editor-label" }) @(html.kendo().editor() //@(html.kendo().editorfor(m=>m.description) //also tried .name("description") .htmlattributes(new { @class...
Read more