Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. $parametro_ano = filter_input(INPUT_GET, "parametro_ano");
  2. $parametro_mes = filter_input(INPUT_GET, "parametro_mes");
  3.  
  4. $sql = "SELECT data_processo FROM tb_processo WHERE 1=1";
  5. if (isset($parametro_mes)) {
  6. $sql .= " AND MONTH (data_processo) = $parametro_mes";
  7. }
  8.  
  9. if (isset($parametro_ano)) {
  10. $sql .= " AND YEAR (data_processo) = $parametro_ano";
  11. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement