PHP& MySQL Video Playlist (JW Player)

I think I am totally loss as to where things go:

[php]

[/php]

Please direct me in terms of how I have stuff set up above.

Well, this is the latest that I am trying:
[php]

                <script type="text/javascript">
                        jwplayer("vEdit_VideoContainer").setup({
                            flashplayer: "../../../mediaplayer_5-9/player.swf",
                            'frontcolor': '000000',
                            'lightcolor': 'D0A72B',
                            'screencolor': 'd4cfcf',
                            'autostart': 'true',
                            'controlbar': 'bottom',
                            'repeat': 'always',
                            'volume': '75',
                            'shuffle': 'true',
                            'autoHide': "always",		
                            'playlist.position': "bottom",		
                            
                            'height': 300,
                            'width': 400,
							'playlistsize': 60,		
							
                            'stretching': 'uniform',
                            //stretching options: uniform,fill,exactfit,bestfit,none		
                           // 'skin':'../../../mediaplayer_5-9/skins/beelden/beelden.zip',
                            //avilable skins:beelden, bekle, five, minima, modieus,skins, stijl
                          //$albums['albumName'];							  	 
                           <?php echo $playlist;?>
						  
                        });
                    </script>
<?php echo $playlist;?>[/php]

But nothing works yet.

No, not in PHP. Since the drop-down is server side and we load the data in that, you have to build the playlst for the preview inside of Javascript, NOT PHP… You have to build it into the playlist FROM the textfields in Javascript. I can help more later. I have to load your code on my system to play with it…

I got confused because you put $ on the variables in the Javascript. I thought variables in Javascript did not need the $.

Oh, sorry sorry sorry… Yes, I was in a rush… Actually had work to do today and got in a hurry…

Yes, you are correct, no $… Let me know if you get any questions…

I’ll get back to it tomorrow. Have a good night.

Early bird today :slight_smile:

Here’s the latest, but still NOW WORKING.

[php]
function videoChanged(){
var VideoDataArray = document.getElementById(‘videoSelect’).value.split(’|’);

document.getElementById(‘videoName’).value = VideoDataArray[0];
document.getElementById(‘videoDescription’).value = VideoDataArray[1];
document.getElementById(‘videoLocation’).value = VideoDataArray[2];
document.getElementById(‘lastUpdated’).value = VideoDataArray[3];
document.getElementById(‘videoImage’).value = VideoDataArray[4];

var playlist=’{file: “…/…/…/VIDEOS/’ + videoLocation + '”, image: “…/…/…/THUMBS/’ + image + '”, title: “’ + videoName + '”, description: “’ + videoDescription + '”, title: “’ + videoName + '” }’;

<?php $query = mysql_query('SELECT * FROM videos WHERE videoName = videoName LIMIT 1'); while ($row = mysql_fetch_array($query)){ $location = $row['videoLocation']; $description = $row['videoDescription']; $videoName = $row['videoName']; $image = $row['videoImage']; }?>

onChange=“jwplayer().load(‘playlist’)”;
}[/php]

I am not sure how to connect the javascript Vars withthe php ones.

Okay, I will look at it in a few minutes…

(We are talking about just the video-admin-PREVIEW part, correct?)

I think you meant it is NOT working not NOW working, LOL…

I also think it is just the PHP/JS issue and I will change it and let you know.
(I will be using the live versions, so do change them for a bit…)

Yeah, we are in the video Admin part.

Please note that I changed the structure of the image field in the videos database. videoImage

Well, the PHP part should be JS. I will try to fix it up. The structure of the database is not an issue…
Basically, I will have to learn one part of JW that I never tried. It was in that link I sent to you. And, I have it still open, so, give me a bit of time…

OK, cool.

I went ahead and tried to implement the playlist selection to the player on the videos.php, NOT the videoAdmin.php This is the landing page and is not part of the admin section.

I tried using the stuff from the old site since for this page I would not need to worry about the input boxes.So the script I took from the old page looks as follow:

Jasvascript:
[php]function createPlayer(theFile) {

var so = new SWFObject(‘mediaplayer_5-9/player.swf’,‘ply’,‘470’,‘470’,‘9’,’#000000’);
so.addParam(‘allowfullscreen’,‘true’);
so.addParam(‘allowscriptaccess’,‘always’);
so.addParam(‘wmode’,‘opaque’);

//so.addVariable(‘playlistfile’,’ ');
so.addVariable(‘playlist’,‘bottom’);
so.addVariable(‘frontcolor’,‘cccccc’);
so.addVariable(‘lightcolor’,‘66cc00’);
//so.addVariable(‘skin’,‘http://www.longtailvideo.com/jw/upload/stylish.swf’);
so.addVariable(‘backcolor’,‘111111’);
so.addVariable(‘playlistsize’,‘200’);
so.write(‘placeholder’);
}[/php]

and the Dropdown list stuff:
[php]<?php

Galería de Videos <?php // $albums['albumName']; $query = mysql_query('SELECT * FROM video_albums') or die (mysql_error()); while ($row = mysql_fetch_array($query)){ $name = $row['albumName']; $albumPlaylist = $row['playlist']; //get data //$albumName = $row['albumName']; //get data echo ''.$name.'
'; } ?>

[/php]

This would have worked, except that in this line:[php]echo ‘’.$name.’
’; [/php] in option value=’.$albumPlaylist. seems that JSON playlists are not allowed, which in this case is what we have in the database. If I would put something like value=videoplaylist.XML it would have worked. But this would not come from the DB.

I burned myself out trying to get this one and the videoAdmin.php pages to work. My hands are already aching… Yikes!

Hmmm, everytime I try a new attack at it, it fails. Seems that the JW player needs to buffer before I can press on any buttons. I have the code for posting a video, but, for some reason it doesn’t do what JW says it will…

I am going to make up a new page for testing without most of the other code and see if that works.

It looks simple, but, just keeps not working… A puzzle for a Friday night… LOL

I hear you, man. Ialso thought this would be a slam dunk. But I guess that’s the fun part. As Tom Hanks said in A League of Their Own – One of the freaking funniest movies of all time:[size=14pt] “The hard is what makes it good. If it was easy, anybody would do it.”[/size]

Of course, Hanks-- by the way, my freaking favorite actor of all time, was talking about baseball, but it’s such a smart quote that can be applied pretty much everywhere.

And don’t forget [size=11pt]"There’s no crying in Baseball."[/size] LOL LOL LOL

LOL, “There’s NO crying in program’n!!!”

I might have part of it figured out, staying home to work on it tonight… Later…

Are you sure there’s no crying in programming? LOL

LOL, a little… I am working on it now… (Along with a movie…) Hope to have something in an hour or so…

I am attempting to create a playlist on the fly based on the example shown in the documentation: (http://www.longtailvideo.com/support/jw-player/jw-player-for-flash-v5/16026/loading-a-playlist-into-the-player)

jwplayer(“presentation”).setup({
flashplayer: “/javascripts/jwplayer/player.swf”,
height: 270,

[code]…

The error I receive is:TypeError: Result of expression ‘s’ [undefined] is not an object.which seems to be caused by var playlist = jwplayer().getPlaylist();[/code]

Thanks for the Link Paddy.

Ernie, that looks like something cool we can comeback and play with later when we have everything set.

Sponsor our Newsletter | Privacy Policy | Terms of Service