æ¥çåæï¼ââhttp://www.sijitao.net/1511.htmlââ
â æè¿æ个任å¡æ¯éè¦ææ£æ¥ä¸äºç½ç«ï¼å¦æ纯æå·¥æ£æ¥çè¯ï¼æè§æ¢è´¹æ¶åæ èãæ以æå°±æ³ç¨ééãæè·¯å ¶å®å¾ç®åï¼å æç½ç«çæºç ééä¸æ¥ï¼ç¶åç¨æ£å表达å¼å»å¹é 符åçé¾æ¥ï¼æåææ é¢åç½åå ¥åºãåæãå 为æ使ç¨æå¤çæ¯phpï¼æ以æç®ç¨phpåç½é¡µééã
第ä¸æ¥ï¼é¾æ¥æ°æ®åºï¼ååºéè¦æ£æ¥çç½ç«åæ£åã
æ°æ®åºè¿éæç¨äºpostgresqlï¼æ°æ®åºå表已ç»æè¦æ±å»ºå¥½ãå 为é»è®¤é ç½®çç¯å¢æ¯centosç³»ç»å nginxãmysqlåphpï¼æ以é¦å æ¯é ç½®ç¯å¢ãé ç½®å ·ä½ä¸å¨è¿éå¤è¯´ï¼ä¸æ¬¡æ»ç»ãç¯å¢é 置好åå¨phpä¸ç¨pg_connectè¿æ¥æ°æ®åºï¼è¿éæè¿æ¥äºä¸¤ä¸ªä¸åçæ°æ®åºã
[code language="php"]
$conn_1=pg_connect("host=xxx.xxx.xxx.xxx port=5432 dbname=mydb1 user=postgres password=xxxxxx") ;
$conn_2=pg_connect("host=xxx.xxx.xxx.xxx port=5432 dbname=mydb2 user=postgres password=xxxxxx") ;
[/code]
第äºæ¥ï¼ååºç½é¡µæºç ï¼å¯¹æºç è¿è¡åæ¥å¤çã
ä¸åç½ç«ç¼ç æ ¼å¼ä¸ä¸æ ·ï¼éè¦å æç¼ç ç»ä¸è½¬æ¢æutf-8ï¼ä¸ç¶ä¹åå ¥åºä¼åºç°ä¹±ç ã
[code language="php"]
//è·åç½é¡µæºç
//$url='http://www.sijitao.net/' ;
$str = file_get_contents($url);
//使ç¨preg_matchåæ£å表达å¼ååºç¼ç
$wcharset = preg_match("/<meta.+?charset=[^\w]?([-\w]+)/i",$str,$temp) ? strtolower($temp[1]):"" ;
//ç¼ç 转æ¢
if($wcharset){
$str=iconv("$wcharset", "UTF-8", $str) ;
}[/code]
è¿éæè¿ä½¿ç¨str_ireplace()å½æ°å¯¹åå°çæºç åäºäºå符æ¿æ¢ï¼ä¸ç¶æåç¨æ£åå¹é ç½åçæ¶åä¼åºç°é®é¢ã
第ä¸æ¥ï¼å¹é å¤çåçæºç å符串ï¼å¯¹å¹é çæ°æ®å ¥åºã
[code language="php"]
$pat = "/<a(.*?)href=\"($preg)\"(.*?)>(.*?)<\/a>/is";
preg_match_all($pat, $str, $m);
$cnt=count($m[2]) ;
for($i=0;$i<$cnt;$i++){
if(strip_tags($m[2][$i])){
$url=strip_tags($m[2][$i]) ;
$url=$m[2][$i] ;
}
if(strip_tags($m[4][$i])){
$title=strip_tags($m[4][$i]) ;
}
else{
$title="There's Something Errors!" ;
}
//ç¼å代ç ï¼å¯¹titleåurlè¿è¡å
¥åºæä½ã
}
}