Search the Community
Showing results for tags 'php json'.
-
Hi All, Here is my code, trying to encode the result from database. $stmt = sqlsrv_query($conn, $result); $data = array(); while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) { $data[] = $row; } //echo json_encode( $data ); $out = array(); foreach($data as $element) { $out[$element['category']][] = array($element['trainFunction']=> $element['value1']); } echo json_encode( $out ); Result of JSON Echo: {"November":[{"A":7},{"B":8},{"C":3},{"D":4}],"December":[{"A":1},{"B":2},{"C":1}]} Expected Output: { "November": [{ "A": 7, "B": 8, "C": 3, "D": 4 }], "December": [{ "A": 1, "B": 2, "C": 1 }] }
-
I am trying to parse some JSON but it seems improperly formed but I'm an amateur at json. Trying to take http://middlecoin.com/json and get the values under a particular ID. for example 17GLRCLFRRue4NcV5mq7pGtRgLsTPhQBNB. Sample below. Any help would be appreciated { "totalPaidOut": "707.11990563", "totalRejectedMegahashesPerSecond": "68.5536", "totalImmatureBalance": "26.09407515", "totalMegahashesPerSecond": "1128.4542", "totalBalance": "28.64664489", "time": "2013-08-25 00:01:00", "report": [ [ "1PqM7xBPA6Q2DohamzncBGY48U17jC9tVA", { "lastHourShares": 7832, "immatureBalance": "1.98299637", "lastHourRejectedShares": 237, "paidOut": "77.12863943", "unexchangedBalance": "0.35186175", "megahashesPerSecond": "72.9995", "bitcoinBalance": "1.58811717", "rejectedMegahashesPerSecond": "2.2090" } ], [ "17GLRCLFRRue4NcV5mq7pGtRgLsTPhQBNB", { "lastHourShares": 7777, "immatureBalance": "1.94445547", "lastHourRejectedShares": 442, "paidOut": "23.71529615", "unexchangedBalance": "0.46860515", "megahashesPerSecond": "72.4869", "bitcoinBalance": "1.64996171", "rejectedMegahashesPerSecond": "4.1197" } Thanks. JR