Facebook图形API超时问题

Question

我需要每天从我的 Facebook 页面中提取数据（例如点赞、发帖、分享等），但是我的脚本只能获取最多 2 或 3 个 Facebook 页面的数据，并且遇到了一些错误而停止了。

我的脚本：

include '../webroot/fb/facebook.php';
        //Get Facebook SDK Object
        $config = array(
                'appId'  => 'codeapl',
                'secret' => 'secret',
                'cookie' => true);
        $facebook = new Facebook($config);
        $this->Pag->recursive = -1;
        $pages=$this->Pag->find('all');
        foreach ($pages as $page)
        {
            //Info page
            $this->Pag->id=$page['Pag']['id'];
            $params = array('method' => 'fql.query',
                'query' =>  "SELECT pic FROM page WHERE page_id='".$page['Pag']['idpage']."'",);
            $result = $facebook->api($params);
            $this->request->data['Pag']['image']= $result[0]['pic'];
            $this->Pag->save($this->request->data);

            //Statistique
            $page_id=$page['Pag']['id'];
            $idpage=$page['Pag']['idpage'];
            $params = array('method' => 'fql.query',
                'query' =>  "SELECT fan_count,talking_about_count,pic FROM page WHERE page_id='$idpage'",);

            $result = $facebook->api($params);
            $this->loadModel('Statistique');
            $this->Statistique->create();
            $this->request->data['Statistique']['likes']= $result[0]['fan_count'];
            $this->request->data['Statistique']['talk']= $result[0]['talking_about_count'];
            $this->request->data['Statistique']['pag_id']= $page_id;

            $params = array('method' => 'fql.query',
                'query' => "select message,share_count,comments,likes from stream where source_id='$idpage' and is_published=1 limit 1000");
            $result = $facebook->api($params);
            $message=0;
            $comment=0;
            $shar=0;
            $like=0;
            foreach ($result as $value) 
            {
                $message++;
                $shar=$shar+$value['share_count'];
                if(isset ($value['likes']['count']))
                    $like=$like+$value['likes']['count'];
                $comment=$comment+$value['comments']['count'];
            }

            $this->request->data['Statistique']['posts']=$message;
            $this->request->data['Statistique']['likepost']=$like;
            $this->request->data['Statistique']['comments']=$comment;
            $this->request->data['Statistique']['char']=$shar;
            $this->Statistique->save($this->request->data);


            //pays
            $params = array('method' => 'fql.query',
                'query' =>  "SELECT value FROM insights WHERE
                    object_id='$idpage' AND metric='page_fans_country'
                    AND end_time=end_time_date('2013-04-14T07:00:00+0000') AND period=period('lifetime')",);
            $result = $facebook->api($params);
            $this->loadModel('Payspage');
            foreach ($result[0]['value'] as $key => $value)
            {
                $pays_id=$this->requestAction("/pays/setpays/$key");
                $this->Payspage->create();
                $data['Payspage']['pay_id']=$pays_id;
                $data['Payspage']['pag_id']=$page_id;
                $data['Payspage']['nombre']=$value;
                $this->Payspage->save($data);
            }
        }

错误是：

Error: Maximum execution time of 60 seconds exceeded    
File: C:\wamp\www\pub\app\webroot\fb\base_facebook.php  
Line: 971

- Ti Amo Laky

Answer 1

你的查询看起来很大，而Facebook API并不总是那么快。因此，

• 要么在PHP.ini文件中将set_time_limit延迟从60秒改为更长时间，
• 要么将查询切分成较小的部分。

一个更大的查询并不总是更好。较小的查询将允许您尽快获得第一批结果，并让您更早地处理它或通知用户有关进展情况（考虑使用AJAX）。

- Stéphane Bruckert

Answer 2

您可以在您的 PHP 函数中使用此代码 set_time_limit(1000000);。

- Ryodo