我有一个简单的 mysql_query ,我想对 results(title => $ title,price => $ price等进行编码)在json中。
$ sql = mysql_query(" SELECT * FROM item_details WHERE posts_id ='$ item_number'");
while($ row = mysql_fetch_array($ sql))
{
$ title = base64_decode($ row [’title’]);
$ price = $ row [’price’];
$ seller_user = $ row [’user’];
}
解决方案
$ 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'] ),
'价格'=> $ row ['price'],
'seller_user'=> $ row ['user']
));
}
$ json = json_encode($ results);