Question

能否得到所有用户的复印件+每一册的图片数量?

我可以通过:

SELECT aid, pid, src_small, src, src_big FROM photo WHERE aid IN(SELECT aid FROM album WHERE owner=me()

。

but I want to get also how many pictures in each album。。。。

我可以操作一个“Loop”所有用户集,而“FQL”则每个集都有另一个“FQL”,但是,如果能够以更好的方式更快/更高效地做到这一点,我会ander。

任何建议?

Thanks, Gtamir

Answer 1

    function getAlbum() {
FB.api( /me/albums , function(resp) {
    console.log( Albums , resp);
    var ul = document.getElementById( albums );
    for (var i=0, l=resp.data.length; i<l; i++) {
      var
        album = resp.data[i],
        li = document.createElement( li ),
        span = document.createElement( span ),
        a = document.createElement( a );

      a.innerHTML = album.name;
       span.innerHTML = album.count;
      li.appendChild(a);
      li.appendChild(span);
      ul.appendChild(li);
    }
  });

}

Answer 2

每一册的样本都有“album”表“photo_count”财产,因为你需要“photo”表格的照片资料,而FQL不支持加入表格,你唯一的捕获量是使用多频率。

$multiQuery = {
 "query1":"SELECT aid,owner,name,photo_count,type,object_id FROM album WHERE owner IN (SELECT uid2 FROM friend WHERE uid1 = me())",
 "query2":"SELECT aid, pid, src_small, src, src_big FROM photo WHERE aid IN(SELECT aid FROM album WHERE owner=me())"
 };

$param = array(       
  method  =>  fql.multiquery ,       
  queries  => $multiQuery,       
  callback  =>   );

$queryresults = $facebook->api($param);

我先亲自测试了该守则,但应该这样做。

友情链接