fork download
copy 
  1. <?php
  2. $estado = 'RS';
  3. $sexo = 'M';
  4. $formacao = 'SUPERIOR';
  5.  
  6. $sql = 'SELECT * FROM candidatos WHERE id =' . $id;
  7. if ($estado != 'TODOS') {
  8.     $sql .= " AND estado = '$estado' ";
  9. }
  10.  
  11. if ($sexo != 'TODOS') {
  12.     $sql .= " AND sexo = '$sexo' ";
  13. }
  14.  
  15.  
  16. if (!empty($formacao)) {
  17.     $sql .= " AND formacao = '$formacao' ";
  18. }
  19. echo $sql;
  20. ?>
Success #stdin #stdout #stderr 0.01s 20520KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
SELECT * FROM candidatos WHERE id = AND estado = 'RS'  AND sexo = 'M'  AND formacao = 'SUPERIOR'
stderr
copy 
PHP Notice:  Undefined variable: id in /home/8vPU7y/prog.php on line 6
https://ideone.com/fJ6Zhp
language:
PHP (php 7.3.5)
created:
9 years ago
visibility:
public

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!