<?php

    include_once ('includes/variables.php');

    $connect->set_charset('utf8');

    if(isset($_GET['cat_id']))
    {
        $query = "SELECT * FROM tbl_category c, tbl_radio n WHERE c.cid = n.category_id AND c.cid = '".$_GET['cat_id']."' ORDER BY n.radio_name ASC";
        $resouter = mysqli_query($connect, $query);

    }
    else if(isset($_GET['latest']))
    {
        $limit = $_GET['latest'];
        $query = "SELECT * FROM tbl_category c, tbl_radio n WHERE c.cid = n.category_id ORDER BY n.radio_name ASC LIMIT $limit";
        $resouter = mysqli_query($connect, $query);
    }
    else
    {
        $query = "SELECT * FROM tbl_category ORDER BY category_name ASC";
        $resouter = mysqli_query($connect, $query);
    }

    $set = array();

    $total_records = mysqli_num_rows($resouter);
    if($total_records >= 1){

      while ($link = mysqli_fetch_array($resouter, MYSQLI_ASSOC)){

        $set['Json'][] = $link;
      }
    }

     header( 'Content-Type: application/json; charset=utf-8' );
     echo $val= str_replace('\\/', '/', json_encode($set));

?>