請教一下更新語句,次數增加疑問!!!
select * from user where names='test';:——sql語句
update user SET num=$nums where names = '$test';:——sql增加次數語句
114:——$nums資料庫裡的儲存次數+1
113:——$row['num']資料庫裡的儲存次數
1:——$row['id']user表裡的ID
test:——$row['names']資料庫裡的test資料
$test = $_GET['names'];
$sql = "select * from user where names='$test'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$nums = $row['num']+1;
mysql_query("update user SET num=$nums where names = '$test'");
或者:mysql_query("update user SET num=$num+1 where names = '$test'");
CREATE TABLE IF NOT EXISTS `user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`names` varchar(15) NOT NULL DEFAULT '',
`num` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `names` (`names`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;
INSERT INTO `user` (`id`, `names`, `num`) VALUES
(1, 'test', 0);
當前頁面 - href="?names=test"
點擊頁面連結,增加兩次次數記錄,右鍵連結新視窗開啟運行和當前頁面重新整理只增加一次記錄!很是奇怪,到底我哪做錯了?
------解決思路----------------------
看你的描述是比較奇怪,可以這樣調試。
$test = $_GET['names'];
$sql = "select * from user where names='$test'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
file_put_contents('sos.txt', $row['num'].PHP_EOL,FILE_APPEND );
$nums = $row['num']+1;
file_put_contents('sos.txt', $nums.PHP_EOL,FILE_APPEND );
mysql_query("update user SET num=$nums where names = '$test'");
file_put_contents('sos.txt', 'update'.PHP_EOL,FILE_APPEND );
?>