php mysql_fetch_assoc 转 json 编码

Question

我正在使用以下代码 php 数组来编码 Json

$query = "SELECT * FROM register WHERE email='$email'AND password='$password'AND status!='0'";

        $result = mysql_query($query) or die('Errant query:  ' . $query);
        $numResults = mysql_num_rows($result);
        if ($numResults > 0)
        {
            $data = array();
            while ($row = mysql_fetch_assoc($result))
            {
                $data = $row;

            }
        echo json_encode($data);
    }

它给了我这样的结果

{"id":"26","fname":"Shankar","lname":"Salunkhe","category_name":"2"}

但我想要的结果是这样的

{"SignIn":[{"id":"26","fname":"Shankar","lname":"Salunkhe","category_name":"2"}],"errors":[],"totalNumberOfRecords":1,"responseCode":"00000"}

我该怎么做

或者建议我任何其他方法来做到这一点

Answer 1

您需要执行如下操作才能获得所需的输出。

$query = "SELECT * FROM register WHERE email='$email'AND password='$password'AND status!='0'";

        $result = mysql_query($query) or die('Errant query:  ' . $query);
        $numResults = mysql_num_rows($result);
        if ($numResults > 0)
        {
            $data = array();
            while ($row = mysql_fetch_assoc($result))
            {
                $data[] = $row;
            }
        $result = ['SignIn' => $data, 'totalNumberOfRecords' => $numResults, 'errors' => [], 'responseCode' => 0000];
        echo json_encode($result);
        exit;
    }