我正在尝试将列(LastName)更新为NULL,如果该列有空值,否则使用下面的mysql查询更新它的值。
$updateUserInfo = "UPDATE `UsersNew` SET MobileNo = '".$dataArray['MobileNo']."',FirstName = '".$dataArray['FirstName']."', LastName = IF(LastName = '' OR LastName IS NULL, 'NULL', LastName), EmailId = '".$dataArray['EmailId']."' where Uid = '".$uid."';";但是LastName值没有更新
我希望如果LastName为null,则希望该列更新为NULL,否则为'".$dataArray['LastName ']."'
发布于 2019-01-03 15:54:55
基本上,您需要将更新LastName的部分更改为以下内容:
LastName = " . (empty($dataArray['LastName']) ? 'NULL' : "'{$dataArray['LastName']}'") . "请注意,NULL不应用引号括起来。所以你的整个查询变成:
$updateUserInfo = "UPDATE `UsersNew`
SET MobileNo = '".$dataArray['MobileNo']."',
FirstName = '".$dataArray['FirstName']."',
LastName = ".(empty($dataArray['LastName']) ? 'NULL' : "'{$dataArray['LastName']}'") . ",
EmailId = '".$dataArray['EmailId']."'
WHERE Uid = '".$uid."';";发布于 2019-01-03 15:56:02
三元运算符很适合这样做:
$updateUserInfo = "UPDATE `UsersNew`
SET MobileNo = '".$dataArray['MobileNo']."',
FirstName = '".$dataArray['FirstName']."',
LastName = ".$dataArray['MobileNo']? "'".$dataArray['MobileNo']."'":"NULL,
EmailId = '".$dataArray['EmailId']."' where Uid = '".$uid."';";但是要注意,您需要使用准备好的语句或PDO清理输入,否则您的代码可能会受到SQL注入的影响。
发布于 2019-01-03 16:18:57
'UsersNew' 不应包含‘’并为UsersNew
来自w3Schools的示例
$sql = "UPDATE MyGuests SET lastname='Doe' WHERE id=2";另一个来源:Update query PHP MySQL
这本身可能不能解决所有问题,但结合其他答案,它可能会解决问题。最后,使用预准备语句。
https://stackoverflow.com/questions/54018229
复制相似问题