/web nhacdj.vn php/code/Client/searhSuggess.php

<?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>