fork download
  1. <?php
  2.  
  3. $kpi = 'kpi';
  4. $pilote = 'aaa';
  5. $janPrev = 'bbb';
  6. $janReal = 'ccc';
  7. $fevPrev = 'ddd';
  8. $fevReal = 'eee';
  9. $marPrev = 'fff';
  10. $marReal = 'ggg';
  11. $abrPrev = 'hhh';
  12. $abrReal = 'iii';
  13. $maiPrev = 'jjj';
  14. $maiReal = 'kkk';
  15. $junPrev = 'lll';
  16. $junReal = 'mmm';
  17. $julPrev = 'nnn';
  18. $julReal = 'ooo';
  19. $agoPrev = 'ppp';
  20. $agoReal = 'qqq';
  21. $setPrev = 'rrr';
  22. $setReal = 'sss';
  23. $outPrev = 'ttt';
  24. $outReal = 'uuu';
  25. $novPrev = 'vvv';
  26. $novReal = 'xxx';
  27. $dezPrev = 'zzz';
  28. $dezReal = 'www';
  29. $id = 'ID';
  30.  
  31.  
  32. $sql = "UPDATE `banco`.`qualite` SET `KPI` = '$kpi', `PILOTE` = '$pilote', `JAN PREV` = '$janPrev', `JAN REAL` = '$janReal', `FEV PREV` = '$fevPrev', `FEV REAL` = '$fevReal', `MAR PREV` = '$marPrev', `MAR REAL` = '$marReal', `ABR PREV` = '$abrPrev', `ABR REAL` = '$abrReal', `MAI PREV` = '$maiPrev', `MAI REAL` = '$maiReal', `JUN PREV` = '$junPrev',
  33. `JUN REAL` = '$junReal', `JUL PREV` = '$julPrev', `JUL REAL` = '$julReal', `AGO PREV` = '$agoPrev', `AGO REAL` = '$agoReal', `SET PREV` = '$setPrev', `SET REAL` = '$setReal', `OUT PREV` = '$outPrev', `OUT REAL` = '$outReal', `NOV PREV` = '$novPrev', `NOV REAL` = '$novReal', `DEZ PREV` = '$dezPrev', `DEZ REAL` = '$dezReal' WHERE `qualite`.`ID` = '$id'";
  34.  
  35. var_dump($sql);
Success #stdin #stdout 0.02s 23448KB
stdin
Standard input is empty
stdout
string(574) "UPDATE  `banco`.`qualite` SET `KPI` = 'kpi', `PILOTE` = 'aaa', `JAN PREV` = 'bbb', `JAN REAL` = 'ccc', `FEV PREV` = 'ddd', `FEV REAL` = 'eee', `MAR PREV` = 'fff', `MAR REAL` = 'ggg', `ABR PREV` = 'hhh', `ABR REAL` = 'iii', `MAI PREV` = 'jjj', `MAI REAL` = 'kkk', `JUN PREV` = 'lll',
    `JUN REAL` = 'mmm', `JUL PREV` = 'nnn', `JUL REAL` = 'ooo', `AGO PREV` = 'ppp', `AGO REAL` = 'qqq', `SET PREV` = 'rrr', `SET REAL` = 'sss', `OUT PREV` = 'ttt', `OUT REAL` = 'uuu', `NOV PREV` = 'vvv', `NOV REAL` = 'xxx', `DEZ PREV` = 'zzz', `DEZ REAL` = 'www' WHERE  `qualite`.`ID` = 'ID'"