全站采集程序
时间:2006-09-06 来源:鱼儿游
把歌手。歌手档案。专集。介绍图片等下载来。
还有歌词。这网站没有音乐文件的。
(\d+)页/",$makeFile,$pages);#page num
for ($p=1;$p(.{1,100})/",$makeFile,$name);#special name
preg_match_all("/singer_cd\.asp\?pyab=(.{1,30})>(.{1,50})/",$makeFile,$singer);#singer
preg_match_all("/([0-9]{1,4})/",$makeFile,$num);#music num
for ($j=0;$jqueryFirstRow($SQL);
if ( $Row['songerID'] == 0 )
{
$SQL = " INSERT INTO xl_songer SET songerName='".addslashes($singer[2][$j])."',str='".$singer[1][$j]."',musicNum='".$num[1][$j]."',specialNum='1',createDate='".time()."' ";
$DB->query($SQL);
$songerID = $DB->_GetInsertID();
}
else
{
$SQL = " UPDATE xl_songer SET musicNum=musicNum+".$num[1][$j].",specialNum=specialNum+1 WHERE songerName='".addslashes($songerName[1][$j])."' ";
$DB->query($SQL);
$songerID = $Row['songerID'];
}
#insert special
$SQL = " INSERT INTO xl_special SET str='".$name[1][$j]."',specialName='".addslashes($name[2][$j])."',songerID='$songerID',songerName='".addslashes($singer[2][$j])."',musicNum='".$num[1][$j]."',createDate='".time()."' ";
$DB->query($SQL);
UpdateOrderID('special');#get special last ID
$specialID = $lastOrderID;
echo $SQL."
";
}
}
}
}
}
?>
query($SQL);
while ( $Row = $DB->queryArray($Result) )
{
$url = "http://www.xuxule.com/cd.asp?cdID=".$Row['str'];
$File = @file_Get_contents($url);
if ( $File )
{
#save picture
preg_match("/width=\"70\"(.*)border=1/s",$File,$pic2);
preg_match("/href=(.{1,110}) target=_blank/",$pic2[1],$pic);
$pic = sava_pic($pic[1],$Row['str']);
preg_match("/专辑介绍(.*) /s",$File,$description2);#description
preg_match("/(.*)/s",$description2[1],$description);#description
preg_match("/出版年月(.*)&/s",$File,$date3);#date
$st = preg_match("/:(.*)/s",$date2[1],$date);#date
$date[1] = trim($date[1]);
}
else
{
preg_match("/:(.*)/s",$date3[1],$datex);#date
$date[1] = trim($datex[1]);
}
preg_match("/发行公司:(.{1,100})/",$File,$company);#company
preg_match("/专辑类别:(.{1,100})/",$File,$language);#language
preg_match("/专辑曲目(.*)b_back/s",$File,$music2);#music num
preg_match_all("/&songNo=(\d+) class=c>(.{1,100})/",$music2[1],$music);#music num
preg_match_all("/class=nolyric>(.{1,100})/",$music2[1],$music_no);#music num
for ( $i=0;$iquery($SQL);
$lyricID = $DB->_GetInsertID();
$lyricFile = @file_Get_contents("http://www.xuxule.com/lyric.asp?cdID=$Row[str]&songNo=".$music[1][$i]);
if ( $lyricFile )
{
preg_match("/width=500>(.*)(.*)/s",$lyric3[1],$lyric2);#lyric
preg_match("/(.*)/s",$lyric2[1],$lyric);#lyric
$lyric[1] = str_replace("","",$lyric[1]);
$SQL = " UPDATE xl_lyric SET lyric='".addslashes(trim($lyric[1]))."' WHERE lyricID='$lyricID' ";
$DB->query($SQL);
}
}
for ( $j=0;$jquery($SQL);
}
#insert into SQL
$SQL = " UPDATE xl_special SET picture='$pic',
description='".addslashes($description[1])."',
company='".addslashes(trim($company[1]))."',
date='".addslashes(trim($date[1]))."',
language='".addslashes(trim($language[1]))."'
WHERE specialID='$Row[specialID]' ";
$DB->query($SQL);
echo $SQL."
";
}
}
?>
(出处:CodeFans转载)
还有歌词。这网站没有音乐文件的。
(\d+)页/",$makeFile,$pages);#page num
for ($p=1;$p(.{1,100})/",$makeFile,$name);#special name
preg_match_all("/singer_cd\.asp\?pyab=(.{1,30})>(.{1,50})/",$makeFile,$singer);#singer
preg_match_all("/([0-9]{1,4})/",$makeFile,$num);#music num
for ($j=0;$jqueryFirstRow($SQL);
if ( $Row['songerID'] == 0 )
{
$SQL = " INSERT INTO xl_songer SET songerName='".addslashes($singer[2][$j])."',str='".$singer[1][$j]."',musicNum='".$num[1][$j]."',specialNum='1',createDate='".time()."' ";
$DB->query($SQL);
$songerID = $DB->_GetInsertID();
}
else
{
$SQL = " UPDATE xl_songer SET musicNum=musicNum+".$num[1][$j].",specialNum=specialNum+1 WHERE songerName='".addslashes($songerName[1][$j])."' ";
$DB->query($SQL);
$songerID = $Row['songerID'];
}
#insert special
$SQL = " INSERT INTO xl_special SET str='".$name[1][$j]."',specialName='".addslashes($name[2][$j])."',songerID='$songerID',songerName='".addslashes($singer[2][$j])."',musicNum='".$num[1][$j]."',createDate='".time()."' ";
$DB->query($SQL);
UpdateOrderID('special');#get special last ID
$specialID = $lastOrderID;
echo $SQL."
";
}
}
}
}
}
?>
query($SQL);
while ( $Row = $DB->queryArray($Result) )
{
$url = "http://www.xuxule.com/cd.asp?cdID=".$Row['str'];
$File = @file_Get_contents($url);
if ( $File )
{
#save picture
preg_match("/width=\"70\"(.*)border=1/s",$File,$pic2);
preg_match("/href=(.{1,110}) target=_blank/",$pic2[1],$pic);
$pic = sava_pic($pic[1],$Row['str']);
preg_match("/专辑介绍(.*) /s",$File,$description2);#description
preg_match("/(.*)/s",$description2[1],$description);#description
preg_match("/出版年月(.*)&/s",$File,$date3);#date
$st = preg_match("/:(.*)/s",$date2[1],$date);#date
$date[1] = trim($date[1]);
}
else
{
preg_match("/:(.*)/s",$date3[1],$datex);#date
$date[1] = trim($datex[1]);
}
preg_match("/发行公司:(.{1,100})/",$File,$company);#company
preg_match("/专辑类别:(.{1,100})/",$File,$language);#language
preg_match("/专辑曲目(.*)b_back/s",$File,$music2);#music num
preg_match_all("/&songNo=(\d+) class=c>(.{1,100})/",$music2[1],$music);#music num
preg_match_all("/class=nolyric>(.{1,100})/",$music2[1],$music_no);#music num
for ( $i=0;$iquery($SQL);
$lyricID = $DB->_GetInsertID();
$lyricFile = @file_Get_contents("http://www.xuxule.com/lyric.asp?cdID=$Row[str]&songNo=".$music[1][$i]);
if ( $lyricFile )
{
preg_match("/width=500>(.*)(.*)/s",$lyric3[1],$lyric2);#lyric
preg_match("/(.*)/s",$lyric2[1],$lyric);#lyric
$lyric[1] = str_replace("","",$lyric[1]);
$SQL = " UPDATE xl_lyric SET lyric='".addslashes(trim($lyric[1]))."' WHERE lyricID='$lyricID' ";
$DB->query($SQL);
}
}
for ( $j=0;$jquery($SQL);
}
#insert into SQL
$SQL = " UPDATE xl_special SET picture='$pic',
description='".addslashes($description[1])."',
company='".addslashes(trim($company[1]))."',
date='".addslashes(trim($date[1]))."',
language='".addslashes(trim($language[1]))."'
WHERE specialID='$Row[specialID]' ";
$DB->query($SQL);
echo $SQL."
";
}
}
?>
(出处:CodeFans转载)
相关阅读 更多 +