include ("inc_functions.php"); $codigo = isset($_GET['codigo']) && intval($_GET['codigo']) ? intval($_GET['codigo']) : 0; if (!$codigo || $codigo == 0) { $sql = "select 'Brasil' as NOME, sum(v06) as POP_HOM, sum(v09) as POP_MUL from sinopse_censo2010"; } else if(strlen($codigo) <= 2) { $sql = "select '".utf8_decode(getNome($codigo))."' as NOME, sum(v06) as POP_HOM, sum(v09) as POP_MUL from sinopse_censo2010 where LEFT(CODMUN, ".strlen($codigo).") = '".$codigo."'"; } else { $sql = "select a.NOME as NOME, b.v06 as POP_HOM, b.v09 as POP_MUL from municipios a join sinopse_censo2010 b where a.CODMUN = '".$codigo."' and a.CODMUN = b.CODMUN"; } include ("inc_connection.php"); mysqli_select_db($link, "cidadesat2013"); $query = mysqli_query($link,$sql); $rs = mysqli_fetch_array($query); $titulo = "População Rural - ".utf8_encode($rs["NOME"]); if (strlen($codigo) > 2) { $titulo .= " (".getSigla(substr($codigo, 0, 2)).")"; } $valores = array($rs["POP_HOM"], $rs["POP_MUL"]); $desc = array("HOMENS", "MULHERES"); $cores = array("d8fe35", "41c300"); $nFatias = count($valores); ?>
Fonte: IBGE, Censo Demográfico 2010.