search.php

1、上传所有文件至服务器目录。 2、使用 MYSQL 管理工具

<?PHP
error_reporting(7);

if ($HTTP_GET_VARS['HTTP_POST_VARS']['keyword'] == $HTTP_POST_VARS['keyword']) {
  unset($HTTP_POST_VARS['keyword']);
}

if ($HTTP_POST_VARS['keyword']) {
	$keyword = trim($HTTP_POST_VARS['keyword']);
} else if ($HTTP_GET_VARS['keyword']) {
	$keyword = trim($HTTP_GET_VARS['keyword']);
}

if ($HTTP_GET_VARS['HTTP_POST_VARS']['startnum'] == $HTTP_POST_VARS['startnum']) {
  unset($HTTP_POST_VARS['startnum']);
}

if ($HTTP_POST_VARS['startnum']) {
	$keyword = intval($HTTP_POST_VARS['startnum']);
} else if ($HTTP_GET_VARS['action']) {
	$keyword = intval($HTTP_GET_VARS['startnum']);
}
if ($startnum<0 or !isset($startnum)) {
  $startnum = 0;
}

if ($HTTP_GET_VARS['HTTP_POST_VARS']['type'] == $HTTP_POST_VARS['type']) {
  unset($HTTP_POST_VARS['type']);
}

if ($HTTP_POST_VARS['type']) {
	$type = trim($HTTP_POST_VARS['type']);
} else if ($HTTP_GET_VARS['type']) {
	$type = trim($HTTP_GET_VARS['type']);
}

if ((!isset($type) or $type=="")) {
  $type = "musicname";
}

$templatesused = '';

//############################ 按照歌曲名字搜索 #################################
if ($type=="musicname") {
  $templatesused = 'error_nokeyword,search_message_nomusic,search_music_lists_listen,search_music_lists';
  $templatesused .= ',search_music,search';
  include("./global.php");

  if (!$permissions['cansearch']) {
      show_nopermission();
  }

  if ($keyword=="") {
    eval("standarderror(\"".gettemplate("error_nokeyword")."\");");
    exit;
  } else if (strlen($keyword)<2) {
    eval("standarderror(\"".gettemplate("error_shortkeyword")."\");");
    exit;
  } else {
    $musics = $DB_site->query("SELECT * 
                               FROM ".$table["musiclist"]." 
                               WHERE MusicName LIKE '%".addslashes($keyword)."%' 
                               ORDER BY ID DESC 
                               LIMIT $startnum,101");

    if ($music=$DB_site->fetch_array($musics)) {
      $num = 1;
      $firstcolor = $recmdMusicFirstColorOne;
      $secondcolor = $recmdMusicFirstColorTwo;
      $musicid = $music['ID'];
      $musicname = $music['MusicName'];
      $hits = $music['Hits'];
      $singer = $music['Singer'];
      if ($music['FileName']!="") {
        eval("\$listenlink = \"".gettemplate('search_music_lists_listen')."\";");
      } else {
        $listenlink = "暂无";
      }
      eval("\$listmusics = \"".gettemplate('search_music_lists')."\";");

      while ($num<100 and $music=$DB_site->fetch_array($musics)) {
        $num++;
        if (($num%2)==0) {
          $firstcolor = $recmdMusicSecondColorOne;
          $secondcolor = $recmdMusicSecondColorTwo;
        } else {
          $firstcolor = $recmdMusicFirstColorOne;
          $secondcolor = $recmdMusicFirstColorTwo;
        }
        $musicid = $music['ID'];
        $musicname = $music['MusicName'];
        $hits = $music['Hits'];
        $singer = $music['Singer'];
        if ($music['FileName']!="") {
          eval("\$listenlink = \"".gettemplate('musiclist_album_lists_listen')."\";");
        } else {
          $listenlink = "暂无";
        }
        eval("\$listmusics .= \"".gettemplate('search_music_lists')."\";");
      }
      if ($num=100 and $music=$DB_site->fetch_array($musics)) {
        $nextnum = $startnum+100;
        $keywordurl = urlencode($keyword);
        eval("\$nextinfo = \"".gettemplate('searchnextinfo')."\";");
      }
      eval("\$searchlists = \"".gettemplate('search_music')."\";");
    } else {
      eval("standarderror(\"".gettemplate("search_message_nomusic")."\");");
      exit;
    }
    $DB_site->free_result($musics);
    eval("dooutput(\"".gettemplate("search")."\");");
  }

}

//############################ 按照专辑名字搜索 #################################
if ($type=="albumname") {
  $templatesused = 'error_nokeyword,error_shortkeyword,search_message_noalbum,search_album_lists';
  $templatesused .= ',search_album,search';
  include("./global.php");

  if (!$permissions['cansearch']) {
      show_nopermission();
  }

  if ($keyword=="") {
    eval("standarderror(\"".gettemplate("error_nokeyword")."\");");
    exit;
  } else if (strlen($keyword)<2) {
    eval("standarderror(\"".gettemplate("error_shortkeyword")."\");");
    exit;
  } else {
    $albums = $DB_site->query("SELECT * 
                               FROM ".$table["special"]." 
                               WHERE Name LIKE '%".addslashes($keyword)."%' 
                               ORDER BY SpecialID DESC 
                               LIMIT $startnum,101");

    if ($album=$DB_site->fetch_array($albums)) {
      $num = 1;
      $firstcolor = $recmdMusicFirstColorOne;
      $secondcolor = $recmdMusicFirstColorTwo;
      $id = $album['SpecialID'];
      $name = $album['Name'];
      $language = $album['Language'];
      $times = $album['PublishTime'];
      $hits = $album['Hits'];
      $artid = $album['NClassID'];
      $artname = $album['NClassName'];
      $classname = $album['SClassName'];
      $musicscount = $DB_site->query_first("SELECT COUNT(*) AS musics 
                                            FROM ".$table["musiclist"]." 
                                            WHERE SpecialID=".$album['SpecialID']);
      $musicscount = $musicscount['musics'];
      eval("\$listalbums = \"".gettemplate('search_album_lists')."\";");

      while ($num<100 and $album=$DB_site->fetch_array($albums)) {
        $num++;
        if (($num%2)==0) {
          $firstcolor = $recmdMusicSecondColorOne;
          $secondcolor = $recmdMusicSecondColorTwo;
        } else {
          $firstcolor = $recmdMusicFirstColorOne;
          $secondcolor = $recmdMusicFirstColorTwo;
        }
        $id = $album['SpecialID'];
        $name = $album['Name'];
        $language = $album['Language'];
        $times = $album['PublishTime'];
        $hits = $album['Hits'];
        $artid = $album['NClassID'];
        $artname = $album['NClassName'];
        $classname = $album['SClassName'];
        $musicscount = $DB_site->query_first("SELECT COUNT(*) AS musics 
                                              FROM ".$table["musiclist"]." 
                                              WHERE SpecialID=".$album['SpecialID']);
        $musicscount = $musicscount['musics'];
        eval("\$listalbums .= \"".gettemplate('search_album_lists')."\";");
      }
      if ($num=100 and $album=$DB_site->fetch_array($albums)) {
        $nextnum = $startnum+100;
        $keywordurl = urlencode($keyword);
        eval("\$nextinfo = \"".gettemplate('searchnextinfo')."\";");
      }
      eval("\$searchlists = \"".gettemplate('search_album')."\";");
    } else {
      eval("standarderror(\"".gettemplate("search_message_noalbum")."\");");
      exit;
    }
    $DB_site->free_result($albums);
    eval("dooutput(\"".gettemplate("search")."\");");
  }

}

//############################ 按照歌手名字搜索 #################################
if ($type=="singer") {
  $templatesused = 'error_nokeyword,error_shortkeyword,search_message_noalbum,search_album_lists';
  $templatesused .= ',search_album,search';
  include("./global.php");

  if (!$permissions['cansearch']) {
      show_nopermission();
  }

  if ($keyword=="") {
    eval("standarderror(\"".gettemplate("error_nokeyword")."\");");
    exit;
  } else if (strlen($keyword)<2) {
    eval("standarderror(\"".gettemplate("error_shortkeyword")."\");");
    exit;
  } else {
    $albums = $DB_site->query("SELECT * 
                               FROM ".$table["special"]." 
                               WHERE NClassName LIKE '%".addslashes($keyword)."%' 
                               ORDER BY SpecialID DESC 
                               LIMIT $startnum,101");

    if ($album=$DB_site->fetch_array($albums)) {
      $num = 1;
      $firstcolor = $recmdMusicFirstColorOne;
      $secondcolor = $recmdMusicFirstColorTwo;
      $id = $album['SpecialID'];
      $name = $album['Name'];
      $language = $album['Language'];
      $times = $album['PublishTime'];
      $hits = $album['Hits'];
      $artid = $album['NClassID'];
      $artname = $album['NClassName'];
      $classname = $album['SClassName'];
      $musicscount = $DB_site->query_first("SELECT COUNT(*) AS musics 
                                            FROM ".$table["musiclist"]." 
                                            WHERE SpecialID=".$album['SpecialID']);
      $musicscount = $musicscount['musics'];
      eval("\$listalbums = \"".gettemplate('search_album_lists')."\";");

      while ($num<100 and $album=$DB_site->fetch_array($albums)) {
        $num++;
        if (($num%2)==0) {
          $firstcolor = $recmdMusicSecondColorOne;
          $secondcolor = $recmdMusicSecondColorTwo;
        } else {
          $firstcolor = $recmdMusicFirstColorOne;
          $secondcolor = $recmdMusicFirstColorTwo;
        }
        $id = $album['SpecialID'];
        $name = $album['Name'];
        $language = $album['Language'];
        $times = $album['PublishTime'];
        $hits = $album['Hits'];
        $artid = $album['NClassID'];
        $artname = $album['NClassName'];
        $classname = $album['SClassName'];
        $musicscount = $DB_site->query_first("SELECT COUNT(*) AS musics 
                                              FROM ".$table["musiclist"]." 
                                              WHERE SpecialID=".$album['SpecialID']);
        $musicscount = $musicscount['musics'];
        eval("\$listalbums .= \"".gettemplate('search_album_lists')."\";");
      }
      if ($num=100 and $album=$DB_site->fetch_array($albums)) {
        $nextnum = $startnum+100;
        $keywordurl = urlencode($keyword);
        eval("\$nextinfo = \"".gettemplate('searchnextinfo')."\";");
      }
      eval("\$searchlists = \"".gettemplate('search_album')."\";");
    } else {
      eval("standarderror(\"".gettemplate("search_message_noalbum")."\");");
      exit;
    }
    $DB_site->free_result($albums);
    eval("dooutput(\"".gettemplate("search")."\");");

/*
    if ($music=$DB_site->fetch_array($musics)) {
      $num = 1;
      $firstcolor = $recmdMusicFirstColorOne;
      $secondcolor = $recmdMusicFirstColorTwo;
      $musicid = $music['ID'];
      $musicname = $music['MusicName'];
      $hits = $music['Hits'];
      if ($music['FileName']!="") {
        eval("\$listenlink = \"".gettemplate('search_music_lists_listen')."\";");
      } else {
        $listenlink = "暂无";
      }
      eval("\$listmusics = \"".gettemplate('search_music_lists')."\";");

      while ($num<100 and $music=$DB_site->fetch_array($musics)) {
        $num++;
        if (($num%2)==0) {
          $firstcolor = $recmdMusicSecondColorOne;
          $secondcolor = $recmdMusicSecondColorTwo;
        } else {
          $firstcolor = $recmdMusicFirstColorOne;
          $secondcolor = $recmdMusicFirstColorTwo;
        }
        $musicid = $music['ID'];
        $musicname = $music['MusicName'];
        $hits = $music['Hits'];
        if ($music['FileName']!="") {
          eval("\$listenlink = \"".gettemplate('musiclist_album_lists_listen')."\";");
        } else {
          $listenlink = "暂无";
        }
        eval("\$listmusics .= \"".gettemplate('search_music_lists')."\";");
      }
      if ($num=100 and $music=$DB_site->fetch_array($musics)) {
        $nextnum = $startnum+100;
        $keywordurl = urlencode($keyword);
        eval("\$nextinfo = \"".gettemplate('searchnextinfo')."\";");
      }
      eval("\$searchlists = \"".gettemplate('search_music')."\";");
    } else {
      eval("standarderror(\"".gettemplate("search_message_nosinger")."\");");
      exit;
    }
    $DB_site->free_result($musics);
    eval("dooutput(\"".gettemplate("search")."\");");
*/
  }

}
?>