Capture the album name of all users in Sohu video

Capture the album name of all users in Sohu video. If the records are all obtained, it is convenient to retrieve the relevant keywords of the video album. But because the number of users is too many, a thread runs without knowing how many years to run. Multi-channel simultaneous fetching can be achieved by setting multiple tables and ID segments. Multiple channels can be segmented simultaneously by modifying the start and end of the $user_id. Sleep (1) is for personal testing only and can be modified Header ("content-type:text/html; Charset=utf-8 "); Set_time_limit (0); $col _title = ";//Title $col _url = ";//url number $user _id = 26;//Start Crawl user number MySQL Pre-operation $mysqli = new Mysqli ("P:localhost", ' Root ', ' ', ' sohutv '); if ($mysqli->connect_errno) { printf ("Connect failed:%s\n", $mysqli->connect_error); Exit (); } $mysqli->set_charset ("UTF8"); $sql = "INSERT into album (Userid,title,url) VALUES (?,?,?)"; $stmt = $mysqli->prepare ($sql); $stmt->bind_param ("SSS", $user _id, $col _title, $col _url); Loop crawl while (true) { $url = "http://my.tv.sohu.com/user/a/playlist/ta/list.do?userId=". $user _id; $temp _html = file_get_contents ($url); $temp _json = Json_decode ($temp _html); $column _no = $temp _json->{' data '}->{' count '}; if ($column _no) { Var_dump ($temp _json->{' data '}); $temp _array = $temp _json->{' data '}->{' list '}; for ($i =0; $i < $column _no; $i + +) { $temp _obj = $temp _array[$i]; Var_dump ($temp _obj); $col _title = $temp _obj->{' title '}; $col _url = substr ($temp _obj->{' url '}, 25,-6); $stmt->execute (); } } Sleep 1 seconds Sleep (1); $user _id++; } /* Access mode Http://my.tv.sohu.com/pl/URL number. shtml */ ?> Copy Code

