<?php
include 'config.php';
if(isset($_REQUEST['categoryMusic']))
{
	$rowTongThuMuc = SelectAll('YoutubeThuMucAmNhac', true);
	if($rowTongThuMuc > 0)
	{
		$tongThuMuc = SelectAll('YoutubeThuMucAmNhac', false);
		while($res = mysqli_fetch_array($tongThuMuc))
		{
			$list[] = array('Id' => $res['Id'], 'NameCategory' => $res['NameCategory']);
		}
		if(isset($list))
		{
			echo json_encode($list);
		}
		else
		{
			echo "false";
		}
	}
	else
	{
		echo "false";
	}
}
if(isset($_REQUEST['select']))
{
	$where = "`ThuMucHinhNen` LIKE '%".mysql_real_escape_string($_REQUEST['ThuMucHinhNen'])."%' ORDER BY `Id` DESC";
	$rowTongMusic = SelectAll('YoutubeThumbVideo', true, $where);
	if($rowTongMusic)
	{
		$list_image = array();
		$result = SelectAll('YoutubeThumbVideo', false, $where);
		while($res = mysqli_fetch_array($result)) 
		{
			$list_image[] = $res['UrlImage'];
		}
		shuffle($list_image);
		foreach($list_image as $item)
		{
			?>
			<img src="<?php echo $item; ?>"/>
			<?php
		}
	}
	else
	{
		echo "false";
	}
}
if(isset($_REQUEST['thumuchinhnen']))
{
	$group = "GROUP BY `ThuMucHinhNen`";
	$rowTongMusic = SelectAll('YoutubeThumbVideo', true, "", $group);
	if($rowTongMusic)
	{
		$result = SelectAll('YoutubeThumbVideo', false, "", $group);
		while($res = mysqli_fetch_array($result)) 
		{
			$list[] = $res['ThuMucHinhNen'];
		}
		if(isset($list))
		{
			echo implode(",",$list);
		}
		else
		{
			echo "false";
		}
	}
	else
	{
		echo "false";
	}
}
if(isset($_REQUEST['thumuc']))
{
	$where = "`ThuMucHinhNen` LIKE '%".mysql_real_escape_string($_REQUEST['thumuc'])."%' ORDER BY `Id` DESC";
	$rowTongMusic = SelectAll('YoutubeThumbVideo', true, $where);
	if($rowTongMusic)
	{
		$list_image = array();
		$result = SelectAll('YoutubeThumbVideo', false, $where);
		while($res = mysqli_fetch_array($result)) 
		{
			$list_image[] = $res['UrlImage'];
		}
		shuffle($list_image);
		echo implode(",",$list_image);
	}
	else
	{
		echo "false";
	}
}
if(isset($_REQUEST['thumuc_quocgia']))
{
	$where = "`NameQuocGia` LIKE '%".mysql_real_escape_string($_REQUEST['thumuc_quocgia'])."%' ORDER BY `Id` DESC";
	$rowTongMusic = SelectAll('YoutubeThumbQuocGia', true, $where);
	if($rowTongMusic)
	{
		$list = array();
		$result = SelectAll('YoutubeThumbQuocGia', false, $where);
		while($res = mysqli_fetch_array($result)) 
		{
			$list[] = array('Id' => $res['Id'], 'NameQuocGia' => $res['NameQuocGia']);
		}
		if(isset($list))
		{
			echo json_encode($list);
		}
		else
		{
			echo "false";
		}
	}
	else
	{
		echo "false";
	}
}
?>