關(guān)于復(fù)雜查詢的結(jié)果如何轉(zhuǎn)化JSON格式？
$username = $_POST['username'];
$password = $_POST['password'];
$sql = "SELECT * FROM user WHERE username = '$username'?
and password = '$password' ";
$aaa = mysql_query($sql);
if(mysql_num_rows($aaa)){
$rows = mysql_fetch_row($aaa);
echo "用戶名:".$rows[0]."<br/>";
echo "密碼:".$rows[1];
session_start();
$_SESSION['username'] = $rows[0];?
}else{
echo "錯誤";
}
連接數(shù)據(jù)庫查詢完結(jié)果后如何使輸出結(jié)果變成json格式？
2016-07-25
$arr=mysql_fetchAll($aaa); ?// 這里的參數(shù)$aaa ，是你上面的這句代碼【?$aaa = mysql_query($sql);】
$jsonStr=json_encode($arr); //數(shù)組轉(zhuǎn)化為json格式
echo $jsonStr; ?//顯示的就是json格式的字符了.