How to perform UPDATE with PDO in PHP?

Question

So guys, I wanted to rescue the data to edit on update.php, but I’m a little lost here, it’s got to give?

   <div class="container">
<div class="table-responsive">
    <table class="table">
        <tr>
            <th>Produtos</th>
            <th>Marca</th>
            <th>Modelo</th>
            <th>Quantidade</th>
            <th>Estado</th>
            <th>Opções</td>
        </tr>
            <?php foreach ($resultado as $key) :?>
        <tr>
            <td><?php echo $key->nome;?></td>
            <td><?php echo $key->marca;?></td>
            <td><?php echo $key->modelo;?></td>
            <td><?php echo $key->quantidade;?></td>
            <td><?php echo $key->estado;?></td>
            <td>
                <a href="mysql/update.php?id=<?php echo $key->id; ?>">Alterar</a>
                <a href="mysql/delete.php?id=<?php echo $key->id; ?>">/Deletar</a>
            </td>
        </tr>
        <?php endforeach;?>
    </table>
</div>

• update php.

      <?php 
  try{
      $id = $_GET['id'];
      $sql = $pdo->prepare("UPDATE FROM estoqueprodutos . produtos WHERE id = $id");
      $sql->execute();
      var_dump($id);
  
      echo $sql->rowCount();
  
  }catch (PDOException $e){
      echo 'Error: '. $e->getMessage();
  
  }    ?>
  

  EDITED

Guys I’m having a problem I created this code to get leaner but it’s not running and it’s not giving me any error you could help me to solve this problem?

if(!empty($_POST['id'])){
    try {
        $sql = "update produtos set nome = ?, marca = ?, modelo = ?, quantidade = ?, estado = ? where id = ?";

        $statement = $pdo->prepare($sql);

        $statement->bindParam(1, $_POST['nome']);
        $statement->bindParam(2, $_POST['marca']);
        $statement->bindParam(3, $_POST['modelo']);
        $statement->bindParam(4, $_POST['quant']);
        $statement->bindParam(5, $_POST['estado']);
        $statement->bindParam(6, $_POST['id']);

        $statement->execute();


        var_dump($statement);
    } catch (PDOException $e) {
        print $e->getMessage();
    }
} else {
    echo "Desculpe-nos, mas não foi possível alterar este produto. Entre em contato com o suporte!";
}

?>

Answer 1

The logic to perform the update is as follows, in your file update.php he will not execute a UPDATE tabela SET campo = valor.

update.php in you need to make a query in the database through the id received by get, with the information in hand create the html form and fill in the attribute value with database value something like:

<?php
//linhas omitidas ...
$sql->execute();
$registro = $sql->fetch(PDO::FETCH_ASSOC);
?>

<form method="post" action="gravar.php">
  <input type="hidden" name="id" value="<php echo $registro['id']; ?>" />
  <input type="text" name="nome" value="<php echo $registro['nome']; ?>" />

In the archive grava.php will be saved a new record or updated. But how to know which operation to perform?

This can be done by checking the value of id(see form fields).

write php.

<?php
  if(!empty($_POST['id']){
      //realizar um update
  }else{
      //Não existe um id, logo é um registro novo, insert nele!
  }