Part II: Poking the API in Java

Encoding PDF-417 2d barcode in Java Part II: Poking the API

Or, results using PHP would be as follows:

( [0] => Array ( [movies] => Casablanca, The Shawshank Redemption, It s A Wonderful Life, Babette s Feast, Field of Dreams, Pride & Prejudice (A&E Version), Band of Brothers (HBO), Chariots of Fire, Am lie (Le Fabuleux destin d Am lie Poulain), Groundhog Day, Braveheart, Princess Bride, Les Miserables (1998 version), Signs, The Lord of the Rings trilogy, Benny & Joon, Vertigo, Sense & Sensibility, The Count of Monte Cristo, A Little Princess, Double Indemnity, Forrest Gump, The Incredibles, The African Queen, Henry V (1989 version), The Truman Show [name] => Rich Wagner ) )

As I discuss in 2, some of the fields are containers (or arrays) of data For example, the event table has a venue field that actually contains six pieces of site-related data, including city, state, country, latitude, and longitude You can retrieve the entire venue array with the following statement:

However, if you want to retrieve just a single venue-related field, you can use dot notation to reference the subfield For example, if you wanted to just retrieve the city, you could modify the statement as follows:

In the examples I have shown so far, the WHERE conditions have always used the equal sign to specify the matches, such as this:

However, FQL allows you to use several other operators to add power to your queries Consider a scenario in which you want to retrieve all the events of a

user 664567292 that have an eid of less than or equal to 7630890908 Here s the query:

The <= operator is used to retrieve all the eids that are less than or equal to 7630890908 This query also uses the AND operator to add a Boolean condition to the statement ensuring that both conditions are met Table 5-3 lists all the available operators

Table 5-3

Equal to Not equal to Greater than Greater than or equal to Less than Less than or equal to Boolean operators Used to create a subquery when an exact value is known for one of indexable fields

Shakespeare s Hamlet may have featured a play within a play, but that s old school now Facebook s FQL can top that with its support for a query within a query You connect queries with the IN clause For example, suppose you wanted to retrieve the name and location of all the events attached to a particular Facebook page (8645672921) The problem is that because the event table has only eid as an indexable field, you cannot use the page ID in a query on the event table

However, the event_member table provides the link you are looking for I can use the following query to retrieve the eids that are linked with the page ID:

In PHP, the fuller example would be:

$uid = 8645672921 ; $FQL = SELECT eid FROM event_member WHERE uid=$uid ; $result_set = $facebook->api_client->fql_query($FQL); echo <pre> ; print_r($result_set); echo </pre> ;

Here s the XML output:

<event_member> <eid>7688563787</eid> </event_member> <event_member> <eid>9542531788</eid> </event_member> <event_member> <eid>9610357779</eid> </event_member> <event_member> <eid>7714358414</eid> </event_member> <event_member> <eid>20803947584</eid> </event_member> <event_member> <eid>9405416779</eid> </event_member> <event_member> <eid>11573937673</eid> </event_member> <event_member> <eid>9374611460</eid> </event_member> <event_member> <eid>7630890908</eid> </event_member> </fql_query_response>

The PHP result set would look like:

Array ( [0] => Array ( [eid] => 7352524755 ) [1] => Array ( [eid] => 11501651899 ) [2] => Array ( [eid] => 7902052238 ) [3] => Array ( [eid] => 8181301283 ) [4] => Array ( [eid] => 8071913190 ) [5] => Array ( [eid] => 9536366299 ) [6] => Array ( [eid] => 8169259038 ) [7] => Array ( [eid] => 20951632704 ) [8] => Array ( [eid] => 7552445899 ) [9] => Array