Re: [jPlayer] How do i get j player to load a playlist from mysql database

575 views

Skip to first unread message

Mohamed Alam

unread,

Jun 27, 2012, 7:42:47 AM6/27/12

to jpl...@googlegroups.com

<?php ob_start();?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Sunnada Cultural Center</title>

$(document).ready(function(){

$(document).bind("contextmenu",function(e){

return false;

});

</script>

function Play (file) {

//var path = '<embed src="media/' + file + '.mp3" autostart="true" loop="false" hidden="true" height="0" width="0">';

//document.getElementById (file).innerHTML = path + '<img src="images/stop.gif" style="cursor:pointer;" onclick="Stop(' + "'" + file + "'" + ')">';

}

</script>

normal_image = new Image();

normal_image.src = "images/play.png";

mouseover_image = new Image();

mouseover_image.src = "images/share.png";

function swap(){

if (document.images){

for (var x=0;

x<swap.arguments.length;

x+=2) {

document[swap.arguments[x]].src = eval(swap.arguments[x+1] + ".src");

}

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}

}

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

</script>

function playSound(soundfile) {

document.getElementById("dummy").innerHTML=

"<embed src=\""+soundfile+"\" hidden=\"true\" autostart=\"true\" loop=\"false\" />";

}

</script>

//<![CDATA[

$(document).ready(function(){

// Local copy of jQuery selectors, for performance.

var my_jPlayer = $("#jquery_jplayer"),

my_trackName = $("#jp_container .track-name"),

my_playState = $("#jp_container .play-state"),

my_extraPlayInfo = $("#jp_container .extra-play-info");

// Some options

var opt_play_first = false, // If true, will attempt to auto-play the default track on page loads. No effect on mobile devices, like iOS.

opt_auto_play = true, // If true, when a track is selected, it will auto-play.

opt_text_playing = "Now playing", // Text when playing

opt_text_selected = "Track selected"; // Text when not playing

// A flag to capture the first track

var first_track = true;

// Change the time format

$.jPlayer.timeFormat.padMin = false;

$.jPlayer.timeFormat.padSec = false;

$.jPlayer.timeFormat.sepMin = " min ";

$.jPlayer.timeFormat.sepSec = " sec";

// Initialize the play state text

my_playState.text(opt_text_selected);

// Instance jPlayer

my_jPlayer.jPlayer({

ready: function () {

$("#jp_container .track-default").click();

timeupdate: function(event) {

my_extraPlayInfo.text(parseInt(event.jPlayer.status.currentPercentAbsolute, 10) + "%");

play: function(event) {

my_playState.text(opt_text_playing);

pause: function(event) {

my_playState.text(opt_text_selected);

ended: function(event) {

my_playState.text(opt_text_selected);

swfPath: "js",

cssSelectorAncestor: "#jp_container",

supplied: "mp3",

solution:"flash,html",

wmode: "window"

});

// Create click handlers for the different tracks

$("#jp_container .track").click(function(e) {

my_trackName.text($(this).text());

my_jPlayer.jPlayer("setMedia", {

mp3: $(this).attr("href")

});

if((opt_play_first && first_track) || (opt_auto_play && !first_track)) {

my_jPlayer.jPlayer("play");

}

first_track = false;

$(this).blur();

return false;

});

//]]>

</script>

</head>

<?php

include("elements/header.php");

<?php

include("elements/leftmenu1.php");

</ul>

</div>

<?php

include("elements/browseblock.php");

<!--<div class="browseblock">

<ul>

<li class="strong1">Browse -: </li>

<li><a href="#">Free Download /</a></li>

<li><a href="#">Concert Excerpts / </a></li>

<li><a href="#">Bhajans / Slokas /</a></li>

<li><a href="#">Varna /</a></li>

<li><a href="#">Krithi /</a></li>

<li><a href="#">Tillana /</a></li>

</ul>

</div>-->

<br/>

<h1>Download / Play Tracks >></h1>

</div>

</div>

<!--<div id="recenttracksholder">

--><div id="recenttracks">

<h2>Most Recent Tracks >></h2>

</div>

<?php

$qry=@mysql_query("select track_name,track_link,track_duration,track_price,artist_name,category_name,track_id_pk from tbl_track,tbl_category,tbl_artist where category_id_pk=category_id_fk and artist_id_pk=artist_id_fk and track_status=0 order by track_id_pk desc limit 3") or die(mysql_error());

//$rows=mysql_fetch_array($qry);

$count=0;

while($rows=mysql_fetch_array($qry))

{

$count++;

</div>

<ul>

<li>

<a href="music/<?php echo $rows['track_link'];?>"

<?php

if($count==1)

{

echo "class=\"track track-default\"";

}

else

{

echo "class=\"track\"";

}

?> id="track" class="jp-play" tabindex="1" >

</a>

</li>

<li><a href="music/<?php echo $rows['track_link'];?>" id="track"

class="jp-stop" tabindex="1">

</a></li>

</ul>

</div>

<!--<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=10,0,0,0" width="30" height="30" id="player1">

align="" TYPE="application/x-shockwave-flash"

pluginspage="http://www.macromedia.com/go/getflashplayer"

src="http://localhost/sunaadanew/audioplay.swf">

</embed>

</object>-->

<a href="music1/<?php echo $rows['track_link'];?>" title="play" target="_blank">

</a>

</a>

</div>

<?php

}

</div>

<h2>Most Popular Tracks >></h2>

<?php

//$rows=mysql_fetch_array($qry);

while($rows=mysql_fetch_array($qry))

{

</div>

<!--<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=10,0,0,0" width="30" height="30" id="player1">

align="" TYPE="application/x-shockwave-flash"

pluginspage="http://www.macromedia.com/go/getflashplayer">

</embed>

</object>-->

<a href="music/<?php echo $rows['track_link'];?>" title="play">

</a>

</a>

</div>

<?php

}

</div>

<?php

include("elements/rightmenu.php");

<?php /*?><div id="recording">

</div><?php */?>

<h5>Press Release</h5>

<?php

$sql = @mysql_query("SELECT news_article_name FROM tbl_newshighlights

ORDER BY news_id_pk desc")

or die(mysql_error());

while($rows = mysql_fetch_array($sql))

{

<?php echo $rows['news_article_name']; ?></a></p>

<?php

}

</marquee>

</div>

<br />

</div>

</div>

</div>

</div>

<?php

include("elements/footer.php");

</div>

</body>

</html>

<?php ob_flush();?>

On Wed, Jun 27, 2012 at 2:52 PM, kenzoo <k.ony...@student.leedsmet.ac.uk> wrote:

Hey guys,

Can any one help please, i am trying to get j player to load files i have saved on my database, i have a playlist saved on my database and the files are coming back as getplaylist.xml and now i am trying to get the xml to play in using jplayer

This is the xml File
<?php include('config.php');

$query = "SELECT * FROM songs ORDER BY song_id ASC";
$result = mysql_query($query);
$count = mysql_num_rows($result);
$i=1;
echo "[";
while($row=mysql_fetch_array($result)){
    $artist = $row['artist_id'];
    $title = $row['song_title'];
    $video = $row ['video'];
    $audio = $row ['audio'];
    $poster = $row['album_cover'];


    if($count==$i){
        echo"{
        Title: \"".$title."\",
        Artist: \"".$artist."\",
        mp4: \"/media/video/".$video.".mp4\",
        ogv: \"/media/video/".$video.".ogv\",
        webm: \"/media/video/".$video.".webm\",
        m4a: \"/media/audio/".$audio.".m4a\",
        ogg: \"/media/audio/".$audio.".ogg\"
            }
        ";
    }else{
        echo"{
        Title: \"".$title."\",
        Artist: \"".$artist."\",
        mp4: \"/media/video/".$video.".mp4\",
        ogv: \"/media/video/".$video.".ogv\",
        webm: \"/media/video/".$video.".webm\",
        m4a: \"/media/audio/".$audio.".m4a\",
        ogg: \"/media/audio/".$audio.".ogg\"
            },
        ";
    }
    $i++;
}
echo "]";

?>

can any one please help me with the code to load the xml playlist
i am using this code and its not working

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

        var myPlaylist = new jPlayerPlaylist({
        jPlayer: "#jquery_jplayer_N",
        cssSelectorAncestor: "#jp_container_N"
    },[

        {
            title: "Over",
            artist: "Drake",
            mp4: "/media/video/Drake%20-%20Over.mp4",
            ogv:"/media/video/Drake%20-%20Over.ogv",
            webm:"/media/video/Drake%20-%20Over.webm",
            poster: "/media/images/drake.jpg"

        }

    ], {
        playlistOptions: {
            enableRemoveControls: true,
            autoPlay: true
        },
        size: {
            width:"100%",
            height:"100%"
        },
        swfPath: "js",
        supplied: "mp3, m4a, ogg, oga, webma, wav, mp4, m4v, ogv, webm, webmv"
    });
    myPlaylist.select(0);
    myPlaylist.play();
    function getPlaylist()    {
        $.ajax(    {
                type: "POST",
                url: "getplaylist.php",
                dataType:"text",
                async: true,
                success: function(data)
            {
            $.each(data,function(index,value){
                myPlaylist.add(value); // add each element in data in myPlaylist
            });
            }
        });
    }

    $('#clickthis').on('click',function(event){
        getPlaylist();
    });

});
</script>

--
You received this message because you are subscribed to the Google Groups "jPlayer: HTML5 Audio & Video for jQuery" group.
To view this discussion on the web visit https://groups.google.com/d/msg/jplayer/-/vTquOmfv2bgJ.
To post to this group, send email to jpl...@googlegroups.com.
To unsubscribe from this group, send email to jplayer+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/jplayer?hl=en.

Reply all

Reply to author

Forward

0 new messages