php金山词霸api-PHP源码

error_reporting(E_ALL^E_NOTICE);
ini_set("max_execution_time",300); 
header(&＃39;Content-Type:text/html; charset=utf-8&＃39;); 
try{
$pdo_cOnn=new PDO(&＃39;mysql:host=localhost;dbname=iciba_data&＃39;,&＃39;root&＃39;,&＃39;&＃39;);
}catch(PDOException $e){
	echo &＃39;conn error&＃39;.$e->getMessage();
}
$pdo_conn->exec(&＃39;set names utf8;&＃39;);

for($i=0;$i>-990;$i--)
{
	$time=date("Y-m-d",strtotime("$i day"));
	$cOntent=file_get_contents(&＃39;http://open.iciba.com/dsapi/?date=&＃39;.$time);
	$arr=json_decode($content,$assoc=true);
	if(!empty($arr))
	{
		echo &＃39;&＃39;;
		print_r($arr);
		echo &＃39;&＃39;;
		$arr[content]=addslashes($arr[content]);
		$arr[note]=addslashes($arr[note]);
		$arr[translation]=addslashes($arr[translation]);
		if(!empty($arr[tags]) and is_array($arr[tags]))
		{	$tags=&＃39;&＃39;;
			$num=0;
			foreach($arr[tags] as $tag)
			{
				$qu_tag="select count(id) from i_tags where id=$tag[id]";
				$re_tag=$pdo_conn->query($qu_tag);
				$result = $re_tag->fetchColumn();
				if($result==0)
				{
					$ta_ins="insert into i_tags(id,name)values(&＃39;$tag[id]&＃39;,&＃39;$tag[name]&＃39;)";
					$pdo_conn->exec($ta_ins);
				}
				if($num==0)
				{
					$tags.=$tag[name];		
				}else
				{
					$tags.=&＃39;|&＃39;.$tag[name];
				}
				$num++;
			}
		}
		$tags=empty($tags)?&＃39;&＃39;:$tags;
		 $query="insert into i_sentence	(sid,tts,content,note,love,translation,picture,picture2,
		 caption,dateline,s_pv,sp_pv,tags,fenxiang_img)values
		(&＃39;$arr[sid]&＃39;,&＃39;$arr[tts]&＃39;,&＃39;$arr[content]&＃39;,&＃39;$arr[note]&＃39;,&＃39;$arr[love]&＃39;,&＃39;$arr[translation]&＃39;,
		&＃39;$arr[picture]&＃39;,&＃39;$arr[picture2]&＃39;,&＃39;$arr[caption]&＃39;,&＃39;$arr[dateline]&＃39;,&＃39;$arr[s_pv]&＃39;,&＃39;$arr[sp_pv]&＃39;,
		&＃39;$tags&＃39;,&＃39;$arr[fenxiang_img]&＃39;)";
		  
		try{
			$pdo_conn->exec($query);
		}catch(PDOException $e){
			echo &＃39;exec error&＃39;.$e->getMessage();
		}
	}
	
}

以上就是php金山词霸api的内容，更多相关内容请关注PHP中文网（www.php1.cn）！