/web nhacdj.vn php/code/Client/searhSuggess.php
PHP | 168 lines | 162 code | 6 blank | 0 comment | 20 complexity | 1de8335d57a88a6813bd1b6bea30caed MD5 | raw file
- <?php
- session_start();
- error_reporting(E_ALL ^ E_NOTICE);
- require("../XBTeam/functions.php");
- require("../XBTeam/se7en.php");
- require_once('../ksecurity.php');
- $connection = mysql_connect("$host" , "$user" , "$pass");
- $db = mysql_select_db($dbase , $connection) or die( "Unable to select database" );
- $security = new K_Security;
- $kw = $_POST["keyword"];
- $kw = $security->cleanXSS($kw);
- $query_song = "SELECT a.*,c.singerID,c.singerName,c.singerKw FROM song AS a LEFT OUTER JOIN singer AS c ON a.singerID = c.singerID WHERE a.sKw LIKE '%$kw%' OR a.sName LIKE '%$kw%' AND sType!='youtube' AND sStatus != '0' ORDER BY sName limit 5";
- $result_song = mysql_query ($query_song);
- ?>
- <div class="vietcom-suggest">
- <div id="wrap-suggest">
- <!-- noresult music -->
- <div class="sg_music">
- <div class="sg_l">Music</div>
- <div class="sg_r">
- <ul>
- <?
- if(@mysql_num_rows($result_song)>0){
- while ($row_song=@mysql_fetch_array($result_song)){
- $sName = $row_song["sName"];
- $artist = mysql_query("SELECT * FROM singer WHERE singerID = ".$row_song['singerID']."");
- $artist_row = mysql_fetch_array($artist);
- ?>
- <li>
- <div class="sg_info">
- <a title="<?=$sName?>" class="sg_name" href="<?php echo $server;?><?php echo CovertVn($row_song['sName']);?>-s<?=$row_song['sID']?>.html"><?=$sName?></a>
- <?=$artist_row['singerName']?>
- </div>
- </li>
- <?}} else {?>
- <li>
- <div class="sg_info">
- <a class="sg_name"></a>Không tim thấy kết quả nào
- </div>
- </li>
- <?}?>
- </ul>
- </div>
- </div>
- <!-- endnoresult music -->
-
- <!-- noresult video -->
- <div class="sg_video">
- <div class="sg_l">Video</div>
- <div class="sg_r">
- <ul>
- <?
- function video_image($url){
- $image_url = parse_url($url);
- if($image_url['host'] == 'www.youtube.com' || $image_url['host'] == 'youtube.com'){
- $array = explode("&", $image_url['query']);
- return "http://img.youtube.com/vi/".substr($array[0], 2)."/mqdefault.jpg";
- } else if($image_url['host'] == 'www.vimeo.com' || $image_url['host'] == 'vimeo.com'){
- $hash = unserialize(file_get_contents("http://vimeo.com/api/v2/video/".substr($image_url['path'], 1).".php"));
- return $hash[0]["thumbnail_small"];
- }
- }
- $query_video = "SELECT a.*,c.singerID,c.singerName,c.singerKw FROM song AS a LEFT OUTER JOIN singer AS c ON a.singerID = c.singerID WHERE a.sKw LIKE '%$kw%' AND sType='youtube' AND sStatus != '0' ORDER BY sName DESC limit 3";
- $result_video = mysql_query ($query_video);
- if(@mysql_num_rows($result_video)>0){
- while ($row_video=@mysql_fetch_array($result_video)){
- $sNamess = $row_video["sName"];
- ?>
- <li>
- <div class="sg_thumb">
- <a title="<?=$sNamess?>" href="<?php echo $server;?><?php echo CovertVn($row_video['sName']);?>-s<?=$row_video['sID']?>.html">
- <img src="<?=video_image($row_video["sLink"])?>" alt="<?=$sNamess?>">
- </a>
- </div>
- <div class="sg_info">
- <a title="<?=$sNamess?>" class="sg_name" href="<?php echo $server;?><?php echo CovertVn($row_video['sName']);?>-s<?=$row_video['sID']?>.html"><?=$sNamess?></a>
- <?=$singerName?>
- </div>
- </li>
- <?}}else{?>
- <li>
- <div class="sg_info">
- <a class="sg_name"></a>Không tim thấy kết quả nào
- </div>
- </li>
- <?}?>
- </ul>
- </div>
- </div>
- <!-- endnoresult video -->
-
- <!-- noresult album -->
- <div class="sg_album">
- <div class="sg_l">Album</div>
- <div class="sg_r">
- <ul>
- <?
- $query_album = "SELECT * FROM album WHERE albumKw LIKE '%$kw%' OR albumName LIKE '%$kw%' ORDER BY albumName limit 3";
- $result_album = mysql_query ($query_album);
- if(@mysql_num_rows($result_album)>0){
- while ($row_album=@mysql_fetch_array($result_album)){
- $artist = mysql_query("SELECT * FROM artist WHERE artistID = ".$row_album['artistID']."");
- $artist_row = mysql_fetch_array($artist);
- ?>
- <li>
- <div class="sg_thumb">
- <a title="<?=$row_album['albumName']?>" href="<?php echo $server;?>album/<?=$row_album['albumID']?>/<?php echo CovertVn($row_album['albumName']);?>.html">
- <img src="<?=$row_album['albumPicture']?>" alt="<?=$row_album['albumName']?>">
- </a>
- </div>
- <div class="sg_info">
- <a title="<?=$row_album['albumName']?>" class="sg_name" href="<?php echo $server;?>album/<?=$row_album['albumID']?><?php echo CovertVn($row_album['albumName']);?>.html"><?=$row_album['albumName']?></a>
- <?=$artist_row['artistName']?>
- </div>
- </li>
- <?}}else{?>
- <li>
- <div class="sg_info">
- <a class="sg_name"></a>Không tim thấy kết quả nào
- </div>
- </li>
- <?}?>
- </ul>
- </div>
- </div>
- <!-- endnoresult album -->
- <!-- noresult artist -->
- <div class="sg_album">
- <div class="sg_l">Artist</div>
- <div class="sg_r">
- <ul>
- <?
- $query_member = "SELECT * FROM member WHERE mUsername LIKE '%$kw%' OR mFullname LIKE '%$kw%' OR mID LIKE '%$kw%' ORDER BY mID limit 3";
- $result_member = mysql_query ($query_member);
- if(@mysql_num_rows($result_member)>0){
- while ($row_member=@mysql_fetch_array($result_member)){
- ?>
- <li>
- <div class="sg_thumb">
- <a title="<?=$row_member['mUsername']?>" href="<?php echo $server;?><?=CovertVn($row_member['mUsername'])?>-urs<?=$row_member['mID']?>.html">
- <img src="<?=$row_member['link_avatar']?>" alt="<?=$row_member['mUsername']?>">
- </a>
- </div>
- <div class="sg_info">
- <a title="<?=$row_member['mUsername']?>" class="sg_name" href="<?php echo $server;?><?=CovertVn($row_member['mUsername'])?>-urs<?=$row_member['mID']?>.html"><?=$row_member['mUsername']?></a>
- </div>
- </li>
- <?}}else{?>
- <li>
- <div class="sg_info">
- <a class="sg_name"></a>Không tim thấy kết quả nào
- </div>
- </li>
- <?}?>
- </ul>
- </div>
- </div>
- <!-- endnoresult artist -->
- </div> <!-- End Wrap Suggest-->
- <!-- View All Result -->
- <div class="sg_more">
- <a title="Xem tất cả kết quả tìm được" href="<?=$homelink?>tim-kiem.html?q=<?=$kw?>"><b><i class="icon-chevron-sign-right"></i> Xem tất cả kết quả tìm được</b></a>
- </div>
- </div>