Json_encode更改我的查询顺序 [英] Json_encode changing the order of my query

问题描述

我有一个按列排序的mysql查询.如果我只是运行php，它就可以正常工作.在我使用json_encode并将其发送给客户端之后，该顺序将更改为主键.为什么要这样做，有解决方案吗?

I have a mysql query that orders by a column. It works fine if I just run the php. After I use json_encode and send it to the client, the order is changed to the primary key. Why does it do this and is there a solution?

查询如下:

try{
    $dbh = new PDO('mysql:host=localhost;dbname=Batik', 'root', 'root');
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
    $_SESSION['table'] = $_SESSION['category'] = $table = $_GET['button'];
    $count = $dbh->query("SELECT * FROM $table ORDER BY `order` ASC");
    $count->setFetchMode(PDO::FETCH_ASSOC);
    $myarray = array();
    while ($row = $count->fetch()) {
        $id = array_shift($row);
        $myarray[$id] = $row;
    }
    print json_encode($myarray);
}  catch (PDOException $exception) {
    echo "There was an error uploading your information, please contact James for assistance. "; 
    error_log($exception->getMessage());
 };

因此，我想要并以纯PHP格式获取的输出是这样的:(ID = primary_key)

So, the output I want and get in plain php is like this: (ID = primary_key)

  Order:     ID:      Location:
  1             4         foto1.jpg
  2             5         foto3.jpg
  3             3         foto2.jpg
  4             2          foto4.jpg
  5             1          foto5.jpg

在我对数组进行json_encode并输出到客户端之后，我得到了:(ID = primary_key)

After I json_encode the array and output to client, I get this: (ID = primary_key)

  Order:     ID:       Location:
  5             1          foto5.jpg
  4             2          foto4.jpg
  3             3          foto2.jpg
  1             4          foto1.jpg
  2             5          foto3.jpg

我希望这是有道理的.

推荐答案

简短的答案是:不要使用

Short answer is : don't use

$id = array_shift($row);
$myarray[$id] = $row;

建立阵列.改为使用以下语法构建一个基于0的实际数字索引数组:

to build your array. Build a real 0-based numerically indexed array instead with this syntax :

$myarray[] = $row;

尽管数组的记录结构略有不同(没有有意义的键)，但是数组将按照其循环顺序来构建.

and the array will be built with the items in the order they are looped over, although with a slightly different record structure (no meaningful keys).

另一种选择是，要保留当前结构，可以使用* sort系列函数(特别是 usort )在php中而不是SQL中对数组进行排序，就像这样(假设您的"order" 字段为数字，请参见 http://www.php.net/manual/zh-CN /function.usort.php (带有字符串类型字段的示例):

As an alternative, to preserve your current structure, you could order the array in php instead of SQL with the *sort family of functions (usort in particular), like so (assuming your "order" field is numeric, see http://www.php.net/manual/en/function.usort.php for an example with a string-type field) :

while ($row = $count->fetch()) {
    $myarray[] = $row;
}
usort($myarray,function ($a, $b){return ($a > $b) ? 1 : -1;});

这篇关于Json_encode更改我的查询顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！