doufu5747
2015-02-18 20:12
浏览 43
已采纳

使用PDO MySQL查询将字符串传递给javascript

I've got a table that has columns 'banned_ip' and 'reason', and I'm trying to display an error message specific to the banned user. For some reason, there seems to be a problem with displaying $row['reason']. Any ideas?

PHP:

$stmt = $conn->prepare('SELECT * FROM blackList WHERE banned_ip = :ip');
$stmt->execute(array('ip' => $_SERVER['REMOTE_ADDR']));

foreach ($stmt as $row) {
    echo "<script language='javascript'> displayBanError('" . $row['reason'] . "'); </script>";
}

JS:

function displayBanError(reason) {
    document.getElementById('error_field').innerHTML = "<p>Error: This IP has been blacklisted.<br>Reason: " + reason + "</p>";
}
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

相关推荐 更多相似问题