Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $parametro_ano = filter_input(INPUT_GET, "parametro_ano");
- $parametro_mes = filter_input(INPUT_GET, "parametro_mes");
- $sql = "SELECT data_processo FROM tb_processo WHERE 1=1";
- if (isset($parametro_mes)) {
- $sql .= " AND MONTH (data_processo) = $parametro_mes";
- }
- if (isset($parametro_ano)) {
- $sql .= " AND YEAR (data_processo) = $parametro_ano";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement