如何在PHP中的foreach循环中组合两个查询 - How to combine two queries in a foreach loop in PHP?

How to combine two queries in a foreach loop in PHP?

Facebook API可以为页面提供用户管理员。假设它返回以下数组。不幸的是，它没有返回它的名称或url。

这将显示一个页面ID列表

$results = $facebook->api('/fql', array('q'=>'SELECT page_id, type FROM page_admin WHERE uid = me()'));
foreach($results['data'] as $result) {
    echo $result['page_id'], '<br />';
}

使用下面的命令，我回显页面ID的名称。

$pagename = $facebook->api('/fql', array('q'=>'SELECT name FROM page WHERE page_id = 230127303706132'));
echo $pagename['data'][0]['name'];

我的问题是如何以有效的方式列出页面名称
我的猜测是，我必须将查询放入foreach循环中

try this
$fql=https://graph.facebook.com/fql?q=SELECT name FROM page WHERE page_id in(SELECT page_id, type FROM page_admin WHERE uid = me())&access_token=xxxxxxxx;
$page_names =json_decode(file_get_contents($fql));
print_r($page_names);
It will show an array of page names.

首先获取page_ids

$results = $facebook->api('/fql', array('q'=>'SELECT page_id, type FROM page_admin WHERE uid = me()'));
$page_ids = array();
foreach($results['data'] as $result) {
    $page_ids[] = $result['page_id'];
}

然后获取页面名称

$pagenames = $facebook->api('/fql', array('q'=>'SELECT name FROM page WHERE page_id IN (' . join(',', $page_ids) .')' ));
// list all page names
foreach($pagenames['data'] as $result) {
    echo $result['name'], '<br />';
}

在一个查询中获取

$pagenames = $facebook->api('/fql', array('q' => 'SELECT name FROM page WHERE page_id IN (SELECT page_id FROM page_admin  WHERE  uid=me())'));
// list all page names
foreach($pagenames['data'] as $result) {
    echo $result['name'], '<br />';
}