<?php
$today=date("Y-m-d");
$row=$mysql->query("select * from `tongjidata` where `day` ='{$today}' limit 1;");
if($row[0]['id']!='')
{
$mysql->query("UPDATE `tongjidata` SET `pv` = '{$row[0]['pv']}'+1 WHERE `tongjidata`.`id` ='{$row[0]['id']}';");
}
else{
$mysql->query("INSERT INTO `tongjidata` (`id`, `ip`, `pv`, `day`) VALUES (NULL, '0', '1', '{$today}');");
}
?>
复制代码
注意mysql当中,调用php函数使用格式:’{KaTeX parse error: Expected 'EOF', got '}' at position 6: today}̲' 外面是单引号,调用计算格式…row[0][‘pv’]}’+1,也就是说,调用函数时候不允许计算。