php json_encode mysql 结果
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3563389/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-08-25 10:14:31 来源:igfitidea点击:
php json_encode mysql result
提问by Michael
I have a simple mysql_queryand I would like to encode the results(title= > $title, price => $price etc)in json .
我有一个简单的mysql_query，我想results(title= > $title, price => $price etc)在 json 中编码。
$sql = mysql_query("SELECT * FROM item_details WHERE posting_id='$item_number'");
while($row = mysql_fetch_array($sql))
{
$title = base64_decode($row['title']);
$price = $row['price'];
$seller_user = $row['user'];
}
回答by reko_t
$sql = mysql_query("SELECT * FROM item_details WHERE posting_id='$item_number'");
$results = array();
while($row = mysql_fetch_array($sql))
{
$results[] = array(
'title' => base64_decode($row['title']),
'price' => $row['price'],
'seller_user' => $row['user']
);
}
$json = json_encode($results);
