Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Start FacebookAPP with FuelPHP

k2mi yagi
October 15, 2012

Start FacebookAPP with FuelPHP

k2mi yagi

October 15, 2012
Tweet

More Decks by k2mi yagi

Other Decks in Technology

Transcript

  1. FQL SELECT uid2 FROM friend WHERE uid1=me() *ࣗ෼ͷ༑ਓͷidΛऔಘ SELECT object_id

    FROM like WHERE user_id=me() *ࣗ෼͕likeͨ͠෺Λऔಘ 12೥10݄15೔݄༵೔
  2. FQL+SUBQUERY SELECT object_id FROM like WHERE uid1=me() SELECT owner,src_small,src_big FROM

    photo WHERE object_id IN (SELECT object_id FROM like WHERE uid1=me()) *ࣗ෼͕likeͨ͠෺͔Βࣸਅͷ৘ใΛൈ͖औΔɻ 12೥10݄15೔݄༵೔
  3. API->MULTIQUERY $facebook->multiquery(array( q1=>’SELECT object_id FROM like WHERE uid1=me()’, q2=>’SELECT src_small

    FROM photo WHERE object_id IN (SELECT object_id FROM #q1)’ )); 12೥10݄15೔݄༵೔
  4. API->MULTIQUERY $facebook->multiquery(array( 'q1'=> 'SELECT uid2 FROM friend WHERE uid1=me()', 'q2'=>

    'SELECT uid,name,relationship_status,sex FROM user WHERE sex = “female” AND uid IN (SELECT uid2 FROM #q1)', )); if( relationship_status ==‘Single’){ ..... } 12೥10݄15೔݄༵೔