Search code examples
phpjavascriptjplayer

echo php result in the javascript code


i'm trying to echo some result in php in the javascript but it keeps not working messing up the interface of the javascript player

that's the full javascript :

<script type="text/javascript">
//<![CDATA[
$(document).ready(function(){

    new jPlayerPlaylist({


        jPlayer: "#jquery_jplayer_1",
            cssSelectorAncestor: "#jp_container_1"
        }, [
            {
                title:"Name",
                mp3:"audio.mp3",
            },      

        ], {
            swfPath: "js",
            supplied: "oga, mp3",
            wmode: "window"
        });
    });
    //]]>
    </script>

i want to replace this :

            {
                title:"Name",
                mp3:"audio.mp3",
            },      

with this :

    while(
    $row = mysql_fetch_assoc($result)) { 
    $sender = $row['sender'];
    $sender_name_query = mysql_query("SELECT fullname FROM users WHERE id = '$sender'");
    $sender_name = mysql_fetch_object($sender_name_query);
    $sender_fullname = $sender_name->fullname;
    echo '{<br/>title:"' . $sender_fullname . '",<br/>mp3:"link",<br/>},';  
}   

it's a while loop i need it to get all the results

can anyone pls help in how to replace it ? thanks


Solution

  • yet another solution. You could do:

    <?php
        $playlist = array();
    
        while($row = mysql_fetch_assoc($result)) { 
            $sender = $row['sender'];
            $sender_name_query = mysql_query("SELECT fullname FROM users WHERE id = '$sender'");
            $sender_name = mysql_fetch_object($sender_name_query);
            $sender_fullname = $sender_name->fullname;
            $playlist[] = (object) array(
                'title' => $sender_fullname,
                'mp3' => 'audio.mp3'
            );  
        }   
    ?>
    
    <script type="text/javascript">
        //<![CDATA[
        $(document).ready(function(){
            new jPlayerPlaylist({
                jPlayer: "#jquery_jplayer_1",
                cssSelectorAncestor: "#jp_container_1"
            }, 
            <?php echo(json_encode($playlist));?>,
            {
                swfPath: "js",
                supplied: "oga, mp3",
                wmode: "window"
            });
        });
        //]]>
    </script>