dedecms留言板修改

CREATE TABLE `dede_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_id` int(11) NOT NULL,
  `user_ip` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

{dede:php}
$likeCount = $dsql->GetOne("SELECT COUNT(*) FROM dede_like WHERE msg_id='$msgid'");
{/dede:php}
<button onclick="likeMessage({$msgid})">点赞 ({$likeCount})</button>

{dede:php}
$likeUrl = "plus/like_msg.php?msgid={$msgid}";
{/dede:php}
<script>
function likeMessage(msgid) {
  var xhr = new XMLHttpRequest();
  xhr.open("POST", "{$likeUrl}", true);
  xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
  xhr.onreadystatechange = function() {
    if (xhr.readyState === 4 && xhr.status === 200) {
      var response = JSON.parse(xhr.responseText);
      if (response.success) {
        document.querySelector('button').innerText = '点赞 (' + response.likeCount + ')';
      }
    }
  };
  xhr.send("msgid=" + msgid);
}
</script>

<?php
require_once(dirname(__FILE__) . '/config.php');
$msgid = intval($_POST['msgid']);
$user_ip = $_SERVER['REMOTE_ADDR'];

$dsql = new DedeSql(false);
$dsql->ExecuteNoneQuery("INSERT INTO dede_like (msg_id, user_ip) VALUES ('$msgid', '$user_ip') ON DUPLICATE KEY UPDATE user_ip='$user_ip'");

$likeCount = $dsql->GetOne("SELECT COUNT(*) FROM dede_like WHERE msg_id='$msgid'");
echo json_encode(array('success' => true, 'likeCount' => $likeCount));
?>