1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123

OAuth using pecl/OAuth

<?php
try {
    $o = new OAuth("YourConsumerKey","YourConsumerSecret",
                   OAUTH_SIG_METHOD_HMACSHA1,OAUTH_AUTH_TYPE_AUTHORIZATION);
    $o->fetch("http://query.yahooapis.com/v1/yql?q=show%20tables&format=json");
    $response_info = $o->getLastResponseInfo();
    print_r($response_info);
    $result = json_decode($o->getLastResponse(),true);
    print_r($result);
} catch(Exception $E) {
    echo "Error: [".$E->errorMessage."]<br>\n";
    echo "Response: [".$E->lastResponse."]<br>\n";
    exit;
}

This outputs:

Array
(
    [http_code] => 200
    [content_type] => text/json;charset=utf-8
    [url] => http://query.yahooapis.com/v1/yql?q=show%20tables&format=json
    [header_size] => 435
    [request_size] => 417
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0.025724
    [namelookup_time] => 0.01291
    [connect_time] => 0.016731
    [pretransfer_time] => 0.016734
    [size_upload] => 0
    [size_download] => 1263
    [speed_download] => 49098
    [speed_upload] => 0
    [download_content_length] => 1263
    [upload_content_length] => 0
    [starttransfer_time] => 0.0257
    [redirect_time] => 0
)
Array
(
    [query] => Array
        (
            [count] => 53
            [created] => 2009-03-03T06:39:56Z
            [lang] => en-US
            [updated] => 2009-03-03T06:39:56Z
            [uri] => http://query.yahooapis.com/v1/yql?q=show+tables
            [diagnostics] => Array
                (
                    [publiclyCallable] => true
                    [user-time] => 1
                    [service-time] => 0
                    [build-version] => 911
                )

            [results] => Array
                (
                    [table] => Array
                        (
                            [0] => atom
                            [1] => csv
                            [2] => feed
                            [3] => flickr.photos.exif
                            [4] => flickr.photos.info
                            [5] => flickr.photos.interestingness
                            [6] => flickr.photos.recent
                            [7] => flickr.photos.search
                            [8] => flickr.photos.sizes
                            [9] => flickr.places
                            [10] => flickr.places.info
                            [11] => geo.places
                            [12] => geo.places.ancestors
                            [13] => geo.places.belongtos
                            [14] => geo.places.children
                            [15] => geo.places.neighbors
                            [16] => geo.places.parent
                            [17] => geo.places.siblings
                            [18] => geo.placetypes
                            [19] => gnip.activity
                            [20] => html
                            [21] => json
                            [22] => local.search
                            [23] => microformats
                            [24] => mybloglog.community.find
                            [25] => mybloglog.member
                            [26] => mybloglog.member.contacts
                            [27] => mybloglog.member.newwithcontacts
                            [28] => mybloglog.member.newwithme
                            [29] => mybloglog.members.find
                            [30] => mybloglog.stats.find
                            [31] => rss
                            [32] => search.images
                            [33] => search.news
                            [34] => search.web
                            [35] => social.connections
                            [36] => social.contacts
                            [37] => social.presence
                            [38] => social.profile
                            [39] => social.updates
                            [40] => upcoming.category
                            [41] => upcoming.country
                            [42] => upcoming.events
                            [43] => upcoming.events.bestinplace
                            [44] => upcoming.groups
                            [45] => upcoming.metro
                            [46] => upcoming.state
                            [47] => upcoming.user
                            [48] => upcoming.venue
                            [49] => weather.forecast
                            [50] => xml
                            [51] => yahoo.identity
                            [52] => yap.setsmallview
                        )

                )

        )

)