MySql字段加1出错-PHP Tutorial-php.cn

Table of Contents

回复内容：

Home

Backend Development

PHP Tutorial

MySql字段加1出错

Jun 06, 2016 pm 08:23 PM

mysql php web

很多天前就发现的问题，当时以为是自己机器问题，现在上传云服务器还是没能解决，望大神助我~
首先是我的个人博客文章在Mysql里有个Look字段，每次查看这个博客，这个字段便在原值上加1，但问题是我每次点击查看它总是原值加2，这真的令我费解，看源码

<code>public function viewBlog(){
        $_sql='SELECT *
            FROM blog
            WHERE id='.$this-&gt;_id.' AND verify=1';
        $_sqlView='UPDATE blog SET `look`=`look`+1 WHERE id='.$this-&gt;_id;
        parent::aud($_sqlView);
        return parent::getOne($_sql);
    }
    </code>

Copy after login

这是Model里的源码

<code>private function viewBlog(){
            $this-&gt;_model-&gt;_id=Tool::checkInt(@$_GET['id']);
            $_oneBlog=$this-&gt;_model-&gt;viewBlog();
            $this-&gt;_tpl-&gt;assign('oneBlog',$_oneBlog);
        </code>

Copy after login

这是控制器的源码片段，已确定viewBlog()函数只执行了一遍，更诡异的是如果我点击评论（评论和查看相比a标签只多了一个#anchor锚点定位到评论框）它的look值便会加3，然后再点击查看或评论它便正常加1了。。。。。。
求大神告知个人博客这是我的博客地址，并不是求访问量，真的求大神解答~~~

回复内容：

<code>public function viewBlog(){
        $_sql='SELECT *
            FROM blog
            WHERE id='.$this-&gt;_id.' AND verify=1';
        $_sqlView='UPDATE blog SET `look`=`look`+1 WHERE id='.$this-&gt;_id;
        parent::aud($_sqlView);
        return parent::getOne($_sql);
    }
    </code>

Copy after login

这是Model里的源码

<code>private function viewBlog(){
            $this-&gt;_model-&gt;_id=Tool::checkInt(@$_GET['id']);
            $_oneBlog=$this-&gt;_model-&gt;viewBlog();
            $this-&gt;_tpl-&gt;assign('oneBlog',$_oneBlog);
        </code>

Copy after login

你先不要直接存进数据库先，测试一下look=look+1是不是这里有问题，看看是不是真的访问了一次

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn