- $sql = " UPDATE hq_votedetail SET nums = nums+1 WHERE did = '$opt' ";
- $this->_db->query($sql);
- $sql = " UPDATE hq_votedetail a,(SELECT SUM(nums) as snums FROM hq_votedetail WHERE vid = '$this->_vid') b
- SET a.rate = a.nums/b.snums
- WHERE a.vid = '$this->_vid'";
- $this->_db->query($sql);
数据库的操作主要在这两部
更新表的时候票数加一,同时更新选项的比率
最后
- $json = Zend_Json::encode($result);
- echo $json;
前台用eval函数接受json
如果需要复杂一点的功能可以再把第三个表加上去