php - 如何只更新选定的 mysql 数据库条目而不弄乱早期的条目

Question

好吧，我真的需要一些帮助，我需要能够仅更新数据库的选定部分，而不会弄乱任何早期条目。此代码确实填充了数据库，但最终弄乱了早期的条目

$errors = array();
if(isset($_POST)){
 $v_fname = ((isset($_POST['v_fname']))?sanitize($_POST['v_fname']):'');
 $v_lname = ((isset($_POST['v_lname']))?sanitize($_POST['v_lname']):'');
 $v_dob = ((isset($_POST['v_dob']))?sanitize($_POST['v_dob']):'');
 $v_country = ((isset($_POST['v_country']))?
 sanitize($_POST['v_country']):'');

 $v_city = ((isset($_POST['v_city']))?sanitize($_POST['v_city']):'');

 $v_phone = ((isset($_POST['v_phone']))?sanitize($_POST['v_phone']):'');

 $v_bio = ((isset($_POST['v_bio']))?sanitize($_POST['v_bio']):'');


if($v_bio == "" && $v_phone == "" && $v_city == "" && $v_fname == "" && 
 $v_lname == ""&& $v_country == "" ){
 $errors = "Please Fill all the details";

}
if(!empty($errors)){
//echo display_errors($errors);

}else{


$db-> query("UPDATE `vendors` SET `v_phone` = '$v_phone', `v_fname` 
='$v_fname', `v_bio` = '$v_bio', `v_location` = '$v_city', `v_country` = 
'$v_country', `v_dob` = '$v_dob', `v_lname` = '$v_lname' WHERE v_id = 
'$v_id'");
echo $v_id;

}
}

这是我想要更新的个人资料。我希望用户能够有选择地进行输入

Answer 1

您需要设置$v_id

我在你的代码中没有看到它