$sql = "SELECT 'x' FROM `pro_hit_week` WHERE `proId` = ".$val['id']." LIMIT 1";
$exist = $dbStat->get($sql);
if ($exist) {
$sql = "UPDATE `pro_hit_week` SET `pv` = `pv` + ".$val['pv']."
WHERE `proId` = '".$val['id']."' LIMIT 1";
} else {
$sql = "INSERT INTO `pro_hit_week` SET `proId` = '".$val['id']."',
`pv` = '".$val['pv']."'";
}
$exist = $dbStat->get($sql);
if ($exist) {
$sql = "UPDATE `pro_hit_week` SET `pv` = `pv` + ".$val['pv']."
WHERE `proId` = '".$val['id']."' LIMIT 1";
} else {
$sql = "INSERT INTO `pro_hit_week` SET `proId` = '".$val['id']."',
`pv` = '".$val['pv']."'";
}
'replace into `pro_hit_week` set pv=pv+1,pv="123"'这样的语句每次执行,pv字段都只是1,而不是原先的值+1.
貌似没有比LZ更加好的办法。
$sql = "INSERT INTO `pro_hit_week` (`proId`,`pv`) VALUES('$val['id']','$val['pv']') ON DUPLICATE KEY UPDATE `pv`=`pv`+$val['pv']";
————————————————————————————————
勋章啊……我啥时候也能得到这些……
————————————————————————————————
基于CSDN论坛提供的插件扩展功能,自己做了个签名档工具,分享给大家,欢迎技术交流 :)