Пример #1
0
    function buscaAmigos($idUser) {
    
    
    	$sql = "SELECT * FROM relaciones WHERE id='".$idUser."' OR idbis='".$idUser."'";

 
    	$amigos = array();
    	$searchResults = array();
    	
    	$result = $this->conn->execute($sql);
    	
    	while ($row = $this->conn->nextRow($result)) {
    		 
    		$id = $row[0];
    		$idbis = $row[1];
    		 
    		if($id == $idUser)
    			array_push($amigos, $idbis);
			else
    			array_push($amigos, $id);
    	}
    	
    	
    	$ids = implode(',', $amigos);
    	
    	$sql = "SELECT id, nombre, apellido, email FROM usuarios WHERE id IN ($ids)";

    	if(strlen($ids)>0){

    	$result = $this->conn->execute($sql);
    	
	    	$amigos=NULL;
	    	$amigos = array();
	    	
	    	while ($row = $this->conn->nextRow($result)) {	 
	    		
	    		$temp = new usuarioModel();
	    		$temp->setid($row[0]);
	    		$temp->setNombre($row[1]);
	    		$temp->setApellido($row[2]);
	    		$temp->setEmail($row[3]);

	    		array_push($searchResults, $temp);
	    	}
	    	return $searchResults;
    	}
    	
	    return false;
    }