尝试从php表单更新db值但不反映任何结果

Question

here my php program for same:

public function updateUser($id,$name,$lname,$username,$password,$gender,$email,$mobile,$address) {
  printF($id);
  $update = ("UPDATE oops SET firstname = '$name',lastname = '$lname', username= '$username',password='$password',email = '$email', gender = '$gender', mobile = '$mobile' , address = '$address' WHERE uid = '$id'");
  printF($update);
  $result = mysql_query($update);

  if ($result) {
    return true;
  } else {
    return false;
  }
}

Answer 1

Try removing () parenthesis from $update variable and DO NOT use mysql_* features , use mysqli_* instead of mysql_*

public function updateUser($id,$name,$lname,$username,$password,$gender,$email,$mobile,$address) {
  printF($id);
  $update = "UPDATE oops SET firstname = '$name',lastname = '$lname', username= '$username',password='$password',email = '$email', gender = '$gender', mobile = '$mobile' , address = '$address' WHERE uid = '$id'";

  printF($update);
  $result = mysqli_query($update);

  if ($result) {
    return true;
  } else {
    return false;
  }
}