Returning JSON from a PHP function

Question

I want to transform this PHP function.. that should return JSON data.

<?php
$query = 'SELECT * FROM `' . mix_player::table() . '` a';
if (isset($_GET['cat']) || isset($_GET['order'])) 
    if (isset($_GET['cat'])) {
        $query .= ' INNER JOIN `' . mix_player::table_cat_rel() . '` b '
            . "ON (a.`id` = b.`idtrack`) WHERE `idcat` = '" . $wpdb->escape($_GET['cat']) . "'";

        $random = $wpdb->get_var('SELECT `random`, `order` FROM `' . mix_player::table_categories() . "` WHERE `id` = '"
            . $wpdb->escape($_GET['cat']) . "'");

        if (!$random)
            $order = $wpdb->get_var(NULL, 1);
    }

    if (isset($_GET['order']))
        $order = $_GET['order'];

    if ($order != '') {
        if (isset($_GET['cat']))
            $query .= ' AND ';
        else
            $query .= ' WHERE ';

        $tracks = mix_player::order_list($query, $order);
    }

} else {
    $random = '0';
}

$query .= ' ORDER BY `id` ASC';

if (isset($tracks) || ($tracks = $wpdb->get_results($query, ARRAY_A))) {
    // option "shuffle = true" not always working into mix. Do it our own way...
    if ($random == 1) { // shuffle tracks?
        list($usec, $sec) = explode(' ', microtime());
        mt_srand((float) $sec + ((float) $usec * 100000));
        $nrows = count($tracks);
        for ($i = 0; $i < $nrows; $i++) {
            $j = mt_rand(0, $nrows - 1);  // pick j at random
            $row = $tracks[$i]; // swap i, j
            $tracks[$i] = $tracks[$j];
            $tracks[$j] = $row;
        }
    }

    foreach ($tracks as $row) {


        $artist = (mix_player::entities($row['artist']));
        echo ($artist);


        $title = (mix_player::entities($row['title']));

        echo ($title);

        $url =(xspf_player::entities($row['url']));
        echo ($url);        

}
}
?>

to display like this json file :

{"title":"title", "artist":"artist","media":"url media.mp3","color":"#56B0E8" },

Can you help me?

Thanks in advance.

just fill an array and the json_encode it

fusion3k
– fusion3k

2016-02-22 11:32:49 +00:00
Commented Feb 22, 2016 at 11:32 — fusion3k
– fusion3k, Commented Feb 22, 2016 at 11:32

fusion3k · Accepted Answer · 2016-02-22 11:40:20Z

1

You can simply create an array and populate it with your desired values, then return it as JSON:

function tracks2json( $tracks )
{
    $retval = array();
    foreach( $tracks as $row )
    {
        $array = array();
        $array['artist'] = mix_player::entities($row['artist']);
        $array['title']  = mix_player::entities($row['title']);
        $array['media']  = 'url '.xspf_player::entities($row['url']);
        $array['color']  = '#56B0E8';
        $retval[]        = $array;
    }
    return json_encode( $retval );
}

if( isset($tracks) || ($tracks = $wpdb->get_results($query, ARRAY_A)) )
{
    // Your MySQL routine here

    $json = tracks2json( $tracks );

}

answered Feb 22, 2016 at 11:40

fusion3k

11.7k4 gold badges27 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Paradiva Over a year ago

Works well thank you very much But there is a problem ,it Show 3 SLASHES .. when i use-------- echo json_encode($json); ............ ,\"media\":\"url http:\\\/\\\/

fusion3k Over a year ago

@Paradiva if you have copied exactly my code, returning value is already json encoded!

Paradiva Over a year ago

Is it possible to assist in modifying myplaylist.php file to become a JSON file , such as found in jsonplaylist but dynamic --- URL mediafire.com/download/jh14xe6kr4t9he9/playlist_file.rar –

Milap · Accepted Answer · 2016-02-22 12:47:38Z

0

echo json_encode(array("title"=>$title,"artist"=>$artist,"url"=>$url));

edited Feb 22, 2016 at 12:47

Milap

7,2398 gold badges28 silver badges47 bronze badges

answered Feb 22, 2016 at 11:39

Sachin Gawai

3811 gold badge4 silver badges15 bronze badges

1 Comment

Paradiva Over a year ago

thank you .. but there is a probleme of SLASHES (( http:\/\/ ... {\"title\":"" ))

Collectives™ on Stack Overflow

Returning JSON from a PHP function

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related