lyrics is $lyrics “;
if(isset($str1)==”)
{
$str1=”where title like ‘%$title%’ or title_mr like ‘%$title%'”;
}
else
{
$str1=$str1.”and title like ‘%$title%’ or title_mr like ‘%$title%'”;
}
}
if($lyrics!=”)
{
//echo “
lyrics is $lyrics “;
if(isset($str1)==”)
{
$str1=”where l_id=’$lyrics'”;
}
else
{
$str1=$str1.”and l_id=’$lyrics'”;
}
}
if($singer!=”)
{
//echo “
Singer is $singer”;
if(isset($str1)==”)
{
$str1=”where s_id=’$singer'”;
}
else
{
$str1=$str1.” and s_id=’$singer'”;
}
}

if($music!=”)
{
//echo “
Music director is $music”;
if($str1==”)
{
$str1=”where m_id=’$music'”;
}
else
{
$str1=$str1.” and m_id=’$music'”;
}
}

if($songtype!=”)
{
//echo “
Song type is $songtype”;
if($str1==”)
{
$str1=”where songtype=’$songtype'”;
}
else
{
$str1=$str1.” and songtype=’$songtype'”;
}
}

$sql=”select * from songs “.$str1.” “;
$statement = ” songs “.$str1;

$sqlres=mysqli_query($conn,$sql);

$sqlcount = “select count(*) from songs “.$str1;
$rs_result1 = mysqli_query($conn,$sqlcount);
$row = mysqli_fetch_row($rs_result1);
$total_records = $row[0];

$nor=$total_records;
//echo’‘;
//echo $searchresult.’ – ‘;
//echo “$searchstr ( $nor songs )”;
//echo’

‘;
?>