php does not update registry in bd mysql

Question

I’m trying to update the database, it returns the message that the update was made, however, when seeing in the database, the update was not made.

What should happen:

When clicking the save button, the modified fields should be changed in the record.

What’s going on:

When I try to change the record, the msg of "saved successfully" appears and goes back to the previous page, as it should. But looking at phpMyAdmin, the record remains unchanged

The whole Code

<?php
session_start();
include_once("conexao.php");

$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
$data = filter_input(INPUT_POST, 'data', FILTER_SANITIZE_STRING);
$acordo = filter_input(INPUT_POST, 'acordo', FILTER_SANITIZE_STRING);
$valor = filter_input(INPUT_POST, 'valor', FILTER_SANITIZE_STRING);
$divida = filter_input(INPUT_POST, 'divida', FILTER_SANITIZE_STRING);


//echo " data " . $data . " - acordo " . $acordo . " - valor " . $valor . " - divida " . $divida  . " - id " . $id;

$atualizacao_data = $_SESSION['atualiza_Pcl-data'];
$atualizacao_divida = $_SESSION['atualiza_Pcl-divida'];
$atualizacao_acordo = $_SESSION['atualiza_Pcl-acordo'];
$atualizacao_valor = $_SESSION['atualiza_Pcl-valor'];
$mudanca = '';
$user = 'gustavo';

/* rastreio */
if ($atualizacao_data != $data) {
    $mudanca = 'DATA => antes - ' . $atualizacao_data . ' | depois - ' . $data . '<br>';
}

if ($atualizacao_divida != $divida) {
    $mudanca = $mudanca . 'DIVIDA => antes - ' . $atualizacao_divida . ' | depois - ' . $divida . '<br>';
}

if ($atualizacao_acordo != $acordo) {
    $mudanca = $mudanca . 'ACORDO => antes - ' . $atualizacao_acordo . ' | depois - ' . $acordo . '<br>';
}

if ($atualizacao_valor != $valor) {
    $mudanca = $mudanca . 'VALOR => antes - ' . $atualizacao_valor . ' | depois - ' . $valor;
}

//echo $mudanca;

/* cadastro rastreio */

$cad_auteracao = "UPDATE parcelamento set aut_por='$user',
                                            data_aut=now,
                                            auteracao='$mudanca',
                                            WHERE id='$id'";
$conect= mysqli_query($conn, $cad_auteracao);

/* cadastro atualização */

$atualiza = "UPDATE parcelamento SET datavenc='$data',
                                        divida='$divida',
                                        acordo='$acordo',
                                        valorpcl'='$valor'
                                        WHERE id='$id'";

$resul_atualiza = mysqli_query($conn, $atualiza);

echo $atualiza;

if(mysqli_affected_rows($conn)){
    $_SESSION['msgAtualiza_pcl'] = "<p style='color:green;'>Usuário editado com sucesso</p>";
    header("Location: ../edit-parcela.php?id=$id"); 
}else{
    $_SESSION['msgAtualiza_pcl'] = "<p style='color:red;'>Usuário não foi editado!</p>";
    header("Location: ../edit-parcela.php?id=$id");
}

?>

I have tested all variables, they are all working as they should. They are receiving the values, however the update is not being made. Could you help me please?

The only part that’s gone wrong is the code part:

Part where you have the problem

$atualiza = "UPDATE parcelamento SET datavenc='$data', divida='$divida', acordo='$acordo', valorpcl'='$valor' WHERE id='$id'";

$resul_atualiza = mysqli_query($conn, $atualiza);

The update (UPDATE) is not updating. It only returns that it was aturized, but when consulting the BD, the update was not done.

Answer 1

There are errors in your SQL’s.

The two are not being executed.

In the first one has a comma before the WHERE and the function now needs NOW parentheses().

In the second it has a single quotes after the field "valorpcl" and before the same (=).

And it lacked a little bit of good practice. When using variables inside strings, put between {keys}.

$cad_auteracao = "
    UPDATE parcelamento 
    SET 
        data_aut = NOW(),
        aut_por = '{$user}',
        auteracao = '{$mudanca}'
    
    WHERE id='{$id}'
";

/**************************************************/


$atualiza = "
    UPDATE parcelamento 
    SET 
        datavenc = '{$data}',
        divida = '{$divida}',
        acordo = '{$acordo}',
        valorpcl = '{$valor}'
    
    WHERE id = '{$id}'
";