404

D7net
:/ var / www / html / idoso_ant / adm / vendor / api /
Filename : busca_residente.php
back
<?php
session_start();
header('Content-Type: application/json');
include_once "ConectaApi.php";

//$id_user = $_REQUEST['iduser'];
// conecta ao banco de dados

$link = mysqli_connect(HOST, USER, PASS);



if (!$link) {

    die('Não conseguiu conectar: ' . mysql_error());

}



// seleciona o banco devcodes

$db_selected = mysqli_select_db( $link,DBNAME);



if (!$db_selected) {

    die ('Não pode selecionar o banco '.DBNAME.' : ' . mysql_error());

}
//$_SESSION['id_user']
$json = array();

//$id = htmlspecialchars($_REQUEST['id']);
$id = $_GET['id'];
$gre_filial_id = $_GET['gre_filial_id'];
//$gre_filial_id = htmlspecialchars($_REQUEST['gre_filial_id']);
//var_dump($id.'-'.$gre_filial_id);
if(!empty($id)){
	$sql = "SELECT resid.id, resid.nome
                from gre_residente resid
	        WHERE resid.id = {$id} and resid.gre_filial_id = {$gre_filial_id} and resid.adms_sit_id <> 2 order by resid.nome";
	// echo $sql;    
	$result1 = mysqli_query ( $link, $sql );

	$qnt = $result1->num_rows;



	if($qnt>0) {

		while($row = mysqli_fetch_object($result1))

		{

			$json = json_encode($row);

		}

	}else{

		$json = json_encode(array('nome'=> 'Erro'));



	}

	echo $json;

}