Question

怎样使得 MySQL 当记录不存在时插入，当记录存在时更新

Answer 1

$SQL="SELECT `phone` FROM `17wo` WHERE `phone`='{$phone}'";
$mysqli_r=$mysqli->query($SQL);
//如果用户存在则只更新 COOKIE
if($mysqli_r->fetch_array()){
$SQL="UPDATE `17wo` SET `phone`='{$phone}',`password`='{$password}' WHERE `phone`='{$phone}'";
if($mysqli->query($SQL)){
echo $phone.' 帐号更新成功！';
}else{
echo $phone.' 帐号更新失败！';
}
}else{//否则添加用户
$SQL="INSERT INTO `17wo` (`phone`,`password`,`state`,`zctime`) VALUES ('{$phone}','{$password}',0,'{$zctime}')";
if($mysqli->query($SQL)){
echo $phone.' 成功加入自动签到！';
}else{
echo $phone.' 加入自动签到失败！';
}
}