fork download
copy 
  1. <?php
  2.  
  3. $_POST = [
  4.     "ambiente" => "Novo ambiente",
  5.     "logotipo" => "",
  6.     "certificado" => "",
  7.     "senha" => "Nova senha"
  8. ];
  9.  
  10. $id = 1;
  11.  
  12. $data = array_filter($_POST);
  13.  
  14. $fields = array_map(function ($value, $key) {
  15.     return sprintf("`%s`='%s'", $key, $value);
  16. }, $data, array_keys($data));
  17.  
  18. $query = sprintf("UPDATE `tabela` SET %s WHERE `id`=%d", implode(",", $fields), $id);
  19.  
  20. echo $query, PHP_EOL;
Success #stdin #stdout 0.01s 82880KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
UPDATE `tabela` SET `ambiente`='Novo ambiente',`senha`='Nova senha' WHERE `id`=1
https://ideone.com/LSIakm
language:
PHP (php 7.3.5)
created:
7 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!