我有這行查詢$sql = " SELECT c.name, IF(a.addressid IS NOT NULL,0,1) AS checkedFROM customers cLEFT JOIN addresses a ON c.customerid = a.customeridWHERE customerid = 123 ";$array = array();$GetResult = $Obj->FetchData($sql, $Obj->DEFAULT_PDO_CONNECTIONS);while ($row = $GetResult->fetch()) { $array[] = $row;}header("Content-type: application/json");$result = json_encode($array);echo $result;當(dāng)我以 JSON 格式回顯時，它將我的checked輸出顯示為字符串。我想知道默認(rèn)情況下 alias 的數(shù)據(jù)類型是checked什么？以及如何更改為整數(shù)數(shù)據(jù)類型？
3 回答
UYOU
TA貢獻(xiàn)1878條經(jīng)驗 獲得超4個贊
感謝您的回答，是的，默認(rèn)情況下它已經(jīng)在數(shù)據(jù)類型編號中，json格式問題。它產(chǎn)生 my checkedas 字符串。所以我在這里找到了答案PHP json_encode encoding numbers as strings。
$result = json_encode($array, JSON_NUMERIC_CHECK);
蝴蝶刀刀
TA貢獻(xiàn)1801條經(jīng)驗 獲得超8個贊
我添加了該列的轉(zhuǎn)換函數(shù)來表示整數(shù)類型。希望這將轉(zhuǎn)化為您想要的結(jié)果
SELECT c.name, Convert(IF(a.addressid IS NOT NULL,0,1), unsigned integer) AS checked
FROM customers c
LEFT JOIN addresses a
ON c.customerid = a.customerid
WHERE customerid = 123
- 3 回答
- 0 關(guān)注
- 147 瀏覽
添加回答
舉報
0/150
提交
取消