mysql assoc中的PHP数组

Question

把我的价值观弄乱了

家庭代码

$user = getventList();
    $response = array();
    if(mysql_num_rows($user) > 0){
    while ($row = mysql_fetch_assoc($user)){
         $response[] = $row;
         echo json_encode($response);
    }
    } else {
         return false;
    }


enter code here

函数事件这个函数是从mysql生成结果的函数。

$result = mysql_query("SELECT * from event where status = '2'")；返回$result；

坏结果

[  {"cPID":"123","image_event":"enjoy.jpg"} 
]

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"}
]

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"}
]

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"},
   {"cPID":"123456","image_event":"enjoy.jpg"}
]

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"},
   {"cPID":"123456","image_event":"enjoy.jpg"},
   {"cPID":"1234567","image_event":"enjoy.jpg"}
]

我只想得到最后一个数组

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"},
   {"cPID":"123456","image_event":"enjoy.jpg"},
   {"cPID":"1234567","image_event":"enjoy.jpg"}
]

Answer 1

将json_encode从while循环中移出。另外，停止使用mysql，开始使用mysqli或PDO函数。

$user = getventList();
    $response = array();
    if(mysql_num_rows($user) > 0){
    while ($row = mysql_fetch_assoc($user)){
         $response[] = $row;          
    }
    } else {
         return false;
    }
    echo json_encode($response);

现在，您的输出将是预期的输出。

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"},
   {"cPID":"123456","image_event":"enjoy.jpg"},
   {"cPID":"1234567","image_event":"enjoy.jpg"}
]