-
Notifications
You must be signed in to change notification settings - Fork 0
/
artist20000.php
executable file
·111 lines (96 loc) · 4.21 KB
/
artist20000.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
<?php
$servername = "localhost";
$username = "root";
$password = "dongdong";
$dbname = "yii2basic";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$conn->set_charset("utf8");
//105万到110万
for ($i=15001; $i <= 20000; $i++) {
$url = "http://music.163.com/artist?id=$i";
$urlContent = file_get_contents($url);
$userInfos = explode("=", $url);
$fileName = $i.".txt";
file_put_contents('./artist/'.$fileName, $urlContent);
$transContent = file_get_contents('./artist/'.$fileName);
$namePatt = '/class=\"sname f-thide sname-max\" title=".*\">/';
preg_match($namePatt, $transContent, $match);
if (empty($match)) {
echo "artist=".$i." not exists"."\n";
unlink('./artist/'.$fileName);
continue;
}
$nameInfo = $match[0];
$nameInfo = str_replace("class=\"sname f-thide sname-max\" title=\"", "", $nameInfo);
$nameInfo = str_replace("\"", "", $nameInfo);
$nameInfo = str_replace(">", "", $nameInfo);
$nameArrs = explode(" - ", $nameInfo);
$artistName = $nameArrs[0];
$aliasName = !empty($nameArrs[1]) ? $nameArrs[1] : "无";
$artistId = $i;
$password = "123456";
$stmt = $conn->prepare("INSERT INTO artist(artistid, artistname, aliasname, password)
VALUES(?, ?, ?, ?)");
$stmt->bind_param("isss", $artistid, $artistname, $aliasname, $password);
$artistid = $artistId;
$artistname = $artistName;
$aliasname = $aliasName;
$password = $password;
$artistInsert = $stmt->execute();
if($artistInsert) {
echo "artist $i info insert success"."\n";
} else {
echo "artist $i info insert failed"."\n";
unlink('./artist/'.$fileName);
continue;
}
/*通过预处理方式新增歌曲信息*/
$songPatt = '/<textarea style="display:none;">.*/';
preg_match($songPatt, $transContent, $match);
$str = (string)($match[0]);
$newStr = str_replace("style=\"display:none;\"", "", $str);
$newStr = str_replace("<textarea >", "", $newStr);
$newStr = str_replace("</textarea>", "", $newStr);
$arrs = json_decode($newStr);
$subSong = array();
$song = array();
$stmtSong= $conn->prepare("INSERT INTO artistsong
(songId, songName, albumId, artistId, score, mvid)
VALUES(?, ?, ?, ?, ?, ?)");
$stmtSong->bind_param("isiisi", $songId, $songName, $albumId, $artistId, $score, $mvid);
$stmtAlbum= $conn->prepare("INSERT INTO artistalbum
(albumId, albumName, artistId)
VALUES(?, ?, ?)");
$stmtAlbum->bind_param("isi", $zjId, $zjName, $artistId);
foreach ($arrs as $key => $value) {
$songId = $value->id;
$songName = $value->name;
$albumId = $value->album->id;
$artistId = $artistId;
$score = $value->score;
$mvid = $value->mvid;
$sCreate = $stmtSong->execute();
$zjId = $value->album->id;
$zjName = $value->album->name;
$artistId = $artistId;
$aCreate = $stmtAlbum->execute();
if ($sCreate && $aCreate) {
echo "songid ".$value->id." and albumid".$value->album->id." insert success"."\n";
} elseif ($sCreate && !$aCreate) {
echo "songid ".$value->id." insert success but albumid".$value->album->id." insert failed"."\n";
} elseif (!$sCreate && $aCreate) {
echo "songid ".$value->id." insert failed but albumid".$value->album->id." insert success"."\n";
} else {
echo "songid ".$value->id." and albumid".$value->album->id." insert failed"."\n";
}
}
unlink('./artist/'.$fileName);
echo "***************"."\n";
}
mysqli_close($conn);
?>