<?php
$host="localhost"; // Host name
$servername = "localhost";
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="song"; // Database name

$conn = new mysqli($servername, $username, $password,$db_name);
$tname=$_POST['tag'];

// Check connection
if ($conn->connect_error) {
    	die("Connection failed: " . $conn->connect_error);
} else{
//echo "Connected successfully "."<br />\r\n";
}
	$jsonData      = array();
	$jsonTempData  = array();
$sql = "SELECT * FROM `audio` WHERE TYPE='$tname'";//" ORDER BY index DESC";
	$result = $conn->query($sql);

if ($result->num_rows > 0) {
while(($rowb = $result->fetch_assoc())) {
			$jTempData  = array();
      		$jTempData['id']         	=$rowb["NO"];
			$jTempData['name']         	=$rowb["NAME"];
      		$jTempData['score']         =$rowb["SCORE"];
      		$jTempData['rate']         	=$rowb["RATING"];
			$jsonData[]=$jTempData;
	}
	}else {
			$jTempData  = array();
    			$jTempData['id']         	="no";
			$jTempData['song']         	="noooo";
      		$jTempData['song']         	="noo";
      		$jTempData['song']         	="no";
			$jsonData[]=$jTempData;
}
$conn->close();

$outputArr['song'] = $jsonData;
// Encode Array To JSON Data
print_r( json_encode($outputArr));
?>