I have a .php file that gets data from SQL and then produces them as json array using json_encode. What I would like to know is, is it possible to sort them? or anything along those lines? Thanks
1条回答 默认 最新
douquan2023 2015-03-19 15:21关注You need to sort, order, group or whatever you like them in either the sql query or through array manipulation before using json_encode.
json_encode (as it is clear from its name) is only used for encoding the data, not sorting etc. Whatever you give it, it will just encode/serialize to json.
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏举报
分享
- 2015-03-19 15:13回答 1 已采纳 You need to sort, order, group or whatever you like them in either the sql query or through array
- 2019-08-11 14:49回答 1 已采纳 The problem is json_encode can not access private properties. Here are some workarounds you could
- 2017-12-19 19:54回答 1 已采纳 As @LSerni said, I was implicitly assigning the encrypted id which is a string to the integer prop
- 2021-04-23 09:51Python咖啡的博客 php关联数组排序后，用json_encode输出给前端，为什么顺序会发生变化？这是用file_put_contents函数写入到文件里的排序过的数组，顺序是对的。这是用echo json_encode()输出到前台的数据，顺序发生了变化。为什么呢...
- 2019-02-19 05:46回答 1 已采纳 I found the answer from another related question I posted on a different post. The errors array wa
- 2019-05-10 09:16回答 3 已采纳 You can add a second parameter to json_encode. This is called the JSON_PRETTY_PRINT constant: <
- 2018-04-02 07:55回答 2 已采纳 I have checked its working fine with me. Please see below code: <?php $requests = '{"Monday":"
- 2021-04-09 12:52weixin_39782355的博客 php关联数组排序后，用json_encode输出给前端，为什么顺序会发生变化？这是用file_put_contents函数写入到文件里的排序过的数组，顺序是对的。这是用echo json_encode()输出到前台的数据，顺序发生了变化。为什么呢...
- 2015-05-07 08:47回答 4 已采纳 Your PHP starts like this: <html> <body> Whatever else it outputs after that, it is
- 2019-03-05 18:24回答 1 已采纳 I found the problem. It wasn't in the code it was in the data returned from the SQL query. This ch
- 2016-05-26 09:30回答 2 已采纳 JSON_ERROR_RECURSION indicates that the data passed to json_encode() contains one or more recursiv
- 2017-08-09 10:44zNULLT的博客 简说PHP JSON问题（有序无序问题） 首先 什么是JSON: 通俗的说，它是一种数据的存储格式，就像PHP序列化后的字符串一样。它是一种数据描述。比如我们将一个数组序列化后存放，就可以很容易的反序列化后应 用。JSON...
- 2011-10-29 10:46回答 2 已采纳 json_encode() has the (undocumented) habit of silently nulling properties that contain invalid (=
- 2020-10-15 11:37例如，数组`array('18' => ..., '19' => ...)`会被编码为`{"18": ..., "19": ...}`，但数组`array(' 18' => ..., ' 19' => ...)`则会保持原样，因为在这里，数字键被识别为字符串，PHP不会对字符串进行排序。...
- 2018-10-22 16:27张一丁的博客 json_encode 索引为数字，自动排序问题 使用son_encode 给前端返回数据，结果顺序不对，经debug调试，发现是json_encode 函数的问题； { "code": 0, "msg": "请求成功!", "...
- 2020-11-18 16:44鱼丸粗面1928的博客 PHP 下标不是以0开始的数组 json_encode 格式化会转为对象 遇到这种问题，很是麻烦。 例如： $array = array( '1'=>array( 'a'=>'red', 'b'=>'blue', 'c'=>'green' ), '3'=>array( 'd'=&...
- 2021-09-03 17:36一殊酒的博客 【代码】【前端开发】Laravel框架：JSON。
- 2021-01-28 11:54居居是居居啦的博客 mysql里的查询如 like "%\u6211\u662f%" 也是不会有结果的，原因是反斜线被mysql转义了， 需要如下的格式才能查询: like "%\\\\u6211\\\\u662f%" (四个反斜杠) 注意:mysql5.7版以后增加了直接对json格式的支持....
- 没有解决我的问题, 去提问
悬赏问题
- ¥15 metadata提取的PDF元数据，如何转换为一个Excel
- ¥15 关于arduino编程toCharArray()函数的使用
- ¥100 vc++混合CEF采用CLR方式编译报错
- ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误，如何解决？
- ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
- ¥15 c#逐行读取txt文本，但是每一行里面数据之间空格数量不同
- ¥50 如何openEuler 22.03上安装配置drbd
- ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
- ¥15 无线连接树莓派，无法执行update，如何解决？（相关搜索：软件下载）
- ¥15 Windows11, backspace, enter, space键失灵