|
|
網址:https://pipe.netyea.com/state-1113.html
展示圖:
網站帖子 亂數抓取 相關文章 CODE
- // 亂數抓取相關文章
- function get_state_subject($tag){
- global $db;
-
- if ($tag!="") {
- $tag_name_i_array = explode(",",$tag);
- $sm_taglists="";
- $hid_array = "";
- $hid_string="";
- $hid_len=0;
-
- for($i=0;$i<count($tag_name_i_array);$i++){
- //抓取文章TAG
- $sql_tag="SELECT * FROM net_state WHERE tag like "%$tag_name_i_array[$i]%"";
- $query_tag=$db->query($sql_tag);
- while ($row_statetag=$db->fetch_array($query_tag)) {
- $hid_string .= $row_statetag['hid'].",";
- }
- }
- $hid_array = explode(",",$hid_string);
- // 刪除重複hid
- $uni_hid_array = array_unique($hid_array);
- // 重新排列字串
- $uni_str = implode(",", $uni_hid_array);
-
- $hid_uni = explode(",",$uni_str);
- // 過濾陣列空值
- $hid_uni = array_filter($hid_uni);
- // 計算數量
- $hid_len = count($hid_uni)-1;
- $result_array = array();
-
- if (count($uni_hid_array) != 0) {
- $sm_taglists = '<div class="container"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="table">';
- if ($hid_len>=8) {
- $hid_len = 8;
- // 隨機抓8個HID
- $random_keys = array_rand($hid_uni, $hid_len);
- //var_dump($random_keys);
- $i=1;
- foreach ($random_keys as $key) {
- $result_array[] = $hid_uni[$key];
- $sql_tag_Related="SELECT * FROM net_state WHERE hid='".$hid_uni[$key]."'";
- $row_tag_Related=$db->fetch_array($db->query($sql_tag_Related));
- if ($i%2==1) {
- $sm_taglists .= '<tr class="tagodd"><td><a href="'.NY_ROOT_PATH.'/state-'.$row_tag_Related['hid'].'.html">'.$i.'. '. $row_tag_Related['subject'].'</a></td></tr>';
- } else {
- $sm_taglists .= '<tr class="tageven"><td><a href="'.NY_ROOT_PATH.'/state-'.$row_tag_Related['hid'].'.html">'.$i.'. '. $row_tag_Related['subject'].'</a></td></tr>';
- }
- $i++;
- }
- } else {
- for($i=0;$i<=$hid_len;$i++) {
- $sql_tag_Related="SELECT * FROM net_state WHERE hid='".$hid_uni[$i]."'";
- $row_tag_Related=$db->fetch_array($db->query($sql_tag_Related));
- if ($i%2==1) {
- $sm_taglists .= '<tr class="tagodd"><td><a href="'.NY_ROOT_PATH.'/state-'.$row_tag_Related['hid'].'.html">'.($i+1).'. '. $row_tag_Related['subject'].'</a></td></tr>';
- } else {
- $sm_taglists .= '<tr class="tageven"><td><a href="'.NY_ROOT_PATH.'/state-'.$row_tag_Related['hid'].'.html">'.($i+1).'. '. $row_tag_Related['subject'].'</a></td></tr>';
- }
- }
- }
-
- $sm_taglists .= "</table></div>";
- } else {
- }
- return $sm_taglists;
- }
- }
複製代碼
文章來源:NetYea 網頁設計
|
|