Update MYSQL table data

Question

Update MYSQL table data

Navigation

#1 by (2 votes)

0

I can not perform UPDATE of the data in my table.

$id = 7;
$TrocaNome = "Ronaldo";  
$TrocaEmail = "[email protected]";  
$up = "UPDATE usuario SET nome='$TrocaNome', email='$TrocaEmail' WHERE id=$id";  
 var_dump($id,$TrocaNome,$TrocaEmail);  **//verifica se esta recebendo informações  
 passadas.**

if(mysqli_affected_rows($conn) < 1){  
echo "Nenhuma informação foi registrada no sistema.";  
}else{  
    echo"Dados Atualizados copm Sucesso";  
}  
mysqli_close($conn);

RESULT: int(7) No information has been entered into the system.

php mysql

asked by anonymous 06.09.2018 / 15:52

1 answer

Save incremented value inside a JQuery click function How to join two vectors in another that does not have repeated values?

score 2 · Accepted Answer

Missing query is missing:

$id = 7;
$TrocaNome = "Ronaldo";  
$TrocaEmail = "[email protected]";  
$up = "UPDATE usuario SET nome='$TrocaNome', email='$TrocaEmail' WHERE id=$id";  
$exec = mysqli_query($conn, $up);

Useful links

Documentation: mysqli_query