How to update mysqli database table with UPDATE?

Question

How to update mysqli database table with UPDATE?

Navigation

#1 by (1 votes)

1

I am creating a data listing system, and I created a data change page, with 6 fields, name, experience, email, phone, city and bio. but my function does not update the fields. The data arrives in function change_data () but does not update in the database. Just the field experience updates.

 function Altera_Dados(){
  $retorno="";
  $conecta = DBConnect();

  if(isset($_POST["atualiza"])){        
        $Nome = $_REQUEST['DadoNome']; 
        echo $_REQUEST['DadoNome'];
        $experiencia = $_POST['experiencia'];
        echo $_POST['experiencia'];
        $email = $_POST['email'];  
        echo $_POST['email'];     
        $telefone = $_POST['telefone'];
        echo $_POST['telefone'];
        $cidade = $_POST['cidade'];
        echo $_POST['cidade'];
        $id = $_POST['id'];
    //$biografia = $_POST['biografia'];

        $query ="UPDATE cadastro3 SET nome = '$Nome',experiencia='$experiencia',email='$email' where id ='$id'";
        $retorno = mysqli_query($conecta,$query)or die ('Erro na consulta ::. '. mysqli_error($conecta));
     }
  DBClose($conecta);
  return $retorno;
}

I used the ID ai the following message appears: mysqli_num_rows () expects parameter 1 to be mysqli_result, boolean given in C: \ xampp \ htdocs \ BuildersFree \ Dozero \ System \ funcoes.php on line 284 Warning: Not updated!

php mysql sql-update

asked by anonymous 08.11.2017 / 13:28

1 answer

Call class method within a promise returns: Uncaught (in promise) TypeError: _this3.updateShelvesState is not a function Problems creating app to consume mail services

score 1 · Accepted Answer

Try the ID . The problem may be in the where. You should be looking for something that does not exist:

$up = mysql_query("UPDATE cadastro3 SET nome ='$Nome',experiencia='$experiencia',email='$email' WHERE id=$id");

if(mysql_affected_rows() > 0){
  echo "Sucesso: Atualizado corretamente!";
}else{
  echo "Aviso: Não foi atualizado!";
}

mysql_close($conexao);