在數(shù)據(jù)庫(kù)表中，列name是varchar(255)列上的編碼：utf8_unicode_ci列中的示例值：Garner Heating & Cooling當(dāng)我查詢(xún)這個(gè)值時(shí)，使用：$conn = new mysqli($host, $user, $pw, $db);$sql = "SELECT id,name FROM bizs WHERE name = 'Garner Heating & Cooling'";if ($result = $conn->query($sql)) { if ($conn->affected_rows > 0) { while ($row = $result->fetch_assoc()) { echo "OLD Name: " . $row['name'] . "\n"; } }}輸出： OLD Name: Garner Heating & Cooling為什么&被轉(zhuǎn)換為&？
2 回答
倚天杖
TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超3個(gè)贊
使用這一行來(lái)查看相同的編碼數(shù)據(jù)：
echo "OLD Name: " . htmlentities($row['name'], ENT_QUOTES) . "\n";
紅顏莎娜
TA貢獻(xiàn)1842條經(jīng)驗(yàn) 獲得超13個(gè)贊
您應(yīng)該使用 htmlentities 功能：
$conn = new mysqli($host, $user, $pw, $db);
$sql = "SELECT id,name FROM bizs WHERE name = 'Garner Heating & Cooling'";
if ($result = $conn->query($sql)) {
if ($conn->affected_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "OLD Name: " . htmlentities($row['name'], ENT_QUOTES) . "\n";
}
}
}
- 2 回答
- 0 關(guān)注
- 114 瀏覽
添加回答
舉報(bào)
0/150
提交
取消