- <?php
- function insert($href='',$pattern='',$novel='',$author='')
- {
- $href = "http://www.kenshuge.com/Html/Book/4/4410/Index.shtm";
- $hrefb = strrev($href);
- $hrefb = strstr($hrefb,'/');
- $hrefb = strrev($hrefb);
- $pattern = '/\<a\s+href="([^"]+)"\s*title="([^"]+)"\s*\>(.+?)\<\/a\>/i';
- $url = curl_init($href);
- curl_setopt($url,CURLOPT_RETURNTRANSFER,true);
- try{
- $pdo = New PDO('mysql:location=localhost;dbname=test','testuser','mytest');
- $pdo->query('set names utf8');
- }catch( PDOException $e ){
- echo $e->getMessage();
- }
- $string = curl_exec($url);
- $string = iconv('gbk', 'utf-8', $string);
- preg_match_all( $pattern, $string, $array );
- $stmt = $pdo->prepare("insert into novel (`novelName`,`author`,`chapterName`,`chapterinfo`,`chapterLink`) values(?,?,?,?,?) ;");
- $j = count($array[1]);
- echo '<table border="1" width="1250">';
- $novel = '异界全职业大师';
- $author = '庄毕凡';
- for ($i = 0; $i < $j; $i++) {
- $link = $hrefb.$array[1][$i];
- $info = $array[2][$i];
- $title = $array[3][$i];
- $stmt->bindParam(1, $novel) ;
- $stmt->bindParam(2, $author);
- $stmt->bindParam(3, $title);
- $stmt->bindParam(4, $info);
- $stmt->bindParam(5, $link);
- $rst = $stmt->execute();
- $color = $rst ? 'green' : 'red';
- echo '<tr><td>';
- echo '<font color="'.$color.'">';
- echo $link;
- echo '</font>';
- echo '</td><td>';
- echo '<font color="'.$color.'">';
- echo $info;
- echo '</font>';
- echo '</td><td>';
- echo '<font color="'.$color.'">';
- echo $title;
- echo '</font>';
- echo '</td></tr>';
- if (strstr($title,'大结局')!==false) {
- break;
- }
- }
- echo '</table>';
- curl_close($url);
- }
- insert();
看到CURL采集就写了个采集某站的小说列表的函数,带插入数据库
应该还行,结合Linux再扩展一下就可以做个类似的booksky.org那样的站了
视频地址:http://bbs.lampbrother.net/read-htm-tid-122008.html
相关热门文章
给主人留下些什么吧!~~
评论热议