Guest User

Untitled

a guest
Dec 12th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. 'NULL' != NULL
  2.  
  3. ...
  4. <option value='todos'>Todos</option>
  5. ....
  6.  
  7. ...
  8.  
  9. AND tipo_venda IS NULL AND tipo IS NULL
  10.  
  11. ...
  12.  
  13. $WHERE = array();
  14. if( $_GET['tipo_pagamento'] != "null" ) // so coloca se nao for null
  15. array_push($WHERE,"tipo='$_GET['tipo_pagamento']'");
  16.  
  17. if( $_GET['tipo_vendas'] != "null" ) // so coloca se nao for null
  18. array_push($WHERE,"tipo_venda ='$_GET['tipo_pagamento']'");
  19.  
  20. $WHERE = count($WHERE) ? "AND ".join($WHERE," AND ") : "";
  21.  
  22. $qry = "SELECT * FROM vendas WHERE DATE(date_created) = '2018-12-12' {$WHERE} ORDER BY 'id'"
  23.  
  24. print $qry;
Add Comment
Please, Sign In to add comment