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?


$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>";


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

1条回答 默认 最新

  • douzhang5121 2015-02-18 22:09

    Mixing plain PHP with JavaScript may be a hell, because of all these quotes and other characters to be escaped. Try to pass PHP -> JS strings base64-encoded in PHP, in JS there are functions to decode it back to readable form.

    ...or try Smarty.

    解决 无用
    打赏 举报

相关推荐 更多相似问题