采集入库

header('content-type:text/html;charset=utf-8');
$url="http://www.sina.com.cn/";
$res=file_get_contents($url);
$str='#<div class="main-nav" data-sudaclick="blk_mainnav">.*</div>#isU';
preg_match($str,$res,$rs);
$str1='#<a href=".*" .*>(.*)</a>#isU';
preg_match_all($str1,$rs[0],$res);
$dsn = "mysql:host=localhost;dbname=username";
$db = new PDO($dsn, 'root', '');
foreach($res[1] as $key=>$val){
   $count = $db->exec("insert into user values(null,'".$val."')");
}
if($count){
   echo "添加成功";
}