Dynamic Playlist in Clipbucket

sherazkhan · July 21, 2012, 9:37am

Hi all,
I am using flow player in homepage of my website for a static playlist. Now i am working on dynamic playlist which will pick all the uploaded videos from database and play continously them. For this, i have written this code

playlist: [
//{url: ‘http://blip.tv/file/get/KimAronson-TwentySeconds59483.flv’, duration: 20}
/<?php
// Set up server connection and open database, ready it for queries…
$hostname=‘mysql16.000webhost.com’;
$username = “a3675993_12”;
$password = “ak75979836”;
$dbname = “a3675993_12”;
$dbConn = mysql_connect( $hostname, $username, $password );
@mysql_select_db($dbname);
//$PlaylistName=“Test Playlist1”; // Temporary test playlist for testing…
$query=“SELECT * from cb_12video=’”. $PlaylistName ."’"; // Query the database and load the current playlist
$result = mysql_query ( $query, $dbConn);
$row = mysql_fetch_row($result);
$PlaylistData = $row[1]; // NOTE: this is MY database setup $row{0}= playlist name , $row[1]= playlist data (Full playlist)
mysql_close($dbConn); // close database connection…
?>/

When i activate this code, the flowplayer does not show on the homepage… Can anybody help me for developing playlist code? For more information and stydy you can visit my website
http://www.scenicchannel.com
Waiting for a good response from all members…

ErnieAlex · July 21, 2012, 7:15pm

Please do not double post on the same subject. And, please place your code inside of the PHP tags where needed. I deleted your other post. Also, for your own security, you should not post your passwords to your database. I suggest that you change the database password ASAP. Normally, for your UserName, Password and database name, you just replace them with ******'s in your post. Now, a look at the code:

Well, it appears that your query is bad. If it is shown as is in your live code. The current query:
[php]$query=“SELECT * from cb_12video=’”. $PlaylistName ."’"; does not make sense.[/php]

I think you want it to be something like this:
[php]$query=“SELECT * from cb_12 WHERE video=’”. $PlaylistName ."’"; [/php]

I am not sue if that is what you are asking, but, I will guess that is the problem.
Good luck, let us know if you solve it…

sherazkhan · July 21, 2012, 7:35pm

Thanks for the reply and guidance. Infact I made a static playlist on the homepage on www.scenicchannel.com. I have made a folder and all videos were uploaded through FTP client. path of videos were given and the static playlist was on the air. Now i am working on a next step to make the playlist dynamic. So i am testing the above code on the www.nailazulfiqar.tk website. But all the code when I added in the playlist, the player disabled on the website. I dont know what and where the issue is coming.
You can see a comparison between both websites.
www.scenicchannel.com (Main Website)
www.nailazulfiqar.tk (testing website)

So waiting for suggestions…

ErnieAlex · July 21, 2012, 7:52pm

Well, it looks like there is a lot of code for both these pages.

I suggest a site vs site comparison of the live pages. In this manner, you can see the differences in each.
To do this, simply bring up both sites and VIEW-SOURCE of each. Then, put the code side-by-side and look
at the differences. Since PHP is done behind the scenes, SERVER-SIDE, you will be looking at the OUTPUT
of PHP and HTML combined with CSS. So, you will be able to see the “RESULTS” of your code, not your code.
Did that make sense? Then, you can see why the video is not working and where you made a mistake.

Then, look back to the PHP code to see where it outputs the bad area of the live code and fix it…

Hope that made sense. Try it and let us know if you still can’t figure it out.