yii 采集,入库，展示

    function actionIndex()
    {
         $db = new \yii\db\Query();//初始化数据库
         $db = \Yii::$app->db;//初始化数据库
        //清空数据库
         $db->createCommand()->delete('caiji')->execute();
        $url = "http://www.cnblogs.com/news/";
        $content = file_get_contents($url);
          //print_r($content);die;
        //$reg = '#<div class="post_item_body">.*<h3>.*<a class="titlelnk" href="(.*)" target="_blank">(.*)</a>.*</h3>.*<p class="post_item_summary">#isU';
         $reg='#<div class="post_item_body">.*<h3>.*<a class="titlelnk" href="(.*)" target="_blank">(.*)</a>.*</h3>.*<p class="post_item_summary">#isU';
        preg_match_all($reg,$content,$arr);
        $url = $arr[1];//网址
        $desc=$arr[2];//标题
        //var_dump($arr);die;
        foreach ($desc as $key => $val) {
            //print_r($url[$key]);
            $data['url'] = $url[$key];
            $data['desc'] = $val;
            // var_dump($data);die;
            $temp[] = $data;
            $res = $db->createCommand()->insert('caiji', $data)->execute();
        }
            // print_r($temp);die;
        //查询数据库
         $data = $db->createCommand('SELECT * FROM caiji')->queryAll();
        // print_r($data);die;
        return $this->render('index',['data'=>$data]);
    }

}
?>