PHP& MySQL Video Playlist (JW Player)

Hi Ernie.

The admin person doesn’t need to know the location. I added because you had mentioned it in one of your previous posts.

I am not sure how to add the upload button when “add new video” has been selected. This is something that I would normally know how to do in PHP using if statements, but since we are generating the form field through Javascript I am at loss here.

I will keep tweaking for all your suggestions. Check your PM.

Back in the groove of things… Check your PM for an important message, courtesy of your local sponsor ;D

Hi Ernie. I came across this field “populating” tutorial:
http://remysharp.com/2007/09/18/auto-populate-multiple-select-boxes/

Here’s the demo: http://remysharp.com/wp-content/uploads/2007/09/select-chain.php

Is something like this that we are trying to achieve?

Or Perhaps this is a better example: http://www.marghoobsuleman.com/mywork/jcomponents/image-dropdown/samples/objectOriented.html

Here’s the download page: http://www.marghoobsuleman.com/jquery-image-dropdown

Yes, but, I think that is basically what we are doing right now.
I haven’t had much time lately to work with your FTP and code.
Hopefully, I will have some free time a little later.

OK… I am getting the layout to behave better. Essentially, I had to download a different version of the image uploader for the jQuery UI. The previous one was using the Boostrap interface.

I am not sure what the Boostrap interface is, but once I downloaded the one with jQuery UI, I regained control of my Layout.

Good morning Ernie.

Just so you know, I am waiting on your feedback http://maranatha.web44.net/DB_Videos/administrar/playlistAdmin.php.

Most of the items are in place. Once we have all the parts connected together, I will then proceed to skin it and make it loo nice and clean.

Two issues I haven’t been able to solve:
1) Upload Link/button should appear when Add New Video Is Selected
2) Upload Script is not working… It’s has to do because of the way is included. Right now, I use Javascript (jQuery) to load the Uploder into a DIV. I tried PHP Include() before, but still nothing happens.

[php]

[/php]

I am sure these are minor issues for you. If you have any further feedback let me know. I know you are probably busy, but I just wanted to keep you posted on current status.

I looked at the new version. It’s getting there! I will be able to look at the video-upload some tonight.

One thing I noted it that the right-hand section is for album creation. It still says create new video not album, so those have to be changed.

Also, the video list in the middle? Was that going to be a full list of all videos or just the ones selected for use in creating an album? If just for album-creation, then perhaps it should be inside the right square.

Having troubles with my own work, but, hope to clear it all up this afternoon. Will let you know when I am available…

Well, I am following your suggestion on the video list. But I would thing, it would only make sense to display the Videos of the currently selected album. In this case then we would make these work more like a single unit, perhaps the videos below the album, or what not, etc.

I am still a bit confused at the concept and basically I am deferring to your implementation. Then once I see it working, we can tweak, unless that would be a pain to do later.

I think at the time of upload, we can give the admin user the the choice to add it to an existing album or create a new one on the spot (and perhaps allow multiple video uploads, as the video uploader clearly supports that).

Hey Ernie, back in action. Check your PM.

Well, seems like a mix up in separating videos and albums. Let’s refresh our memories back to the beginning of the project…

Videos are uploaded by the administrator. This involves a small video-admin page. All it does it allow for uploading videos, renaming them and deleting them. That’s all that section does. It needs, basically, what you have in place. A list of videos that currently exist. An option for selecting one and deleting it. An option for uploading a new video and renaming that video. An option for selecting one and renaming it.
I think you have all that in place, correct? Perhaps this should be on a separate page from the album section.

Albums are created by the administrator. This involves a similar album-admin page. All it does is allow for creating new albums, deleting old ones and editing their names and descriptions. That’s all that section does. It needs, basically, what you have in place. A list of all albums that currently exist. An option for selecting one and deleting it. An option for creating a new album. When creating a new album, a list of all videos to select from would appear along with a album name and description. An option to select an album and add/delete videos in it’s list. I think you have most of that in place.

So, I think combining the two pages was a mistake as you are getting confused on how they work together on one page. If it is confusing you, it would confuse the administrator, too. So, let’s go back and have these on two separate pages. You can make them any way you like later on, but, let’s get them working first…

Later this afternoon, I will look at the code in detail with the FTP info you sent. But, your task would be to separate the two admin pages and let me know when they are ready in separate versions. Then, we will finish the Video-Admin page first as that is 99% done…

Let me know when they are separated and ready to view… ( I’m back at it, too! LOL )

OK, I will separate them, and if need be we can always join them at the end of the project.

I should be able to give you two rough samples fairly soon… Let’s Roll!

OK, this is where we are:

  1. I separted videos and playlist admin pages and they have a new server location:
    video Admin: http://maranatha.web44.net/administrar/dbvideos/_CP/videoAdmin.php
    [b]Playlist Admin:[/bhttp://maranatha.web44.net/administrar/dbvideos/_CP/playlistAdmin.php]]http://maranatha.web44.net/administrar/dbvideos/_CP/playlistAdmin.php

Lists are not connected to the Sample players.

2 The Main video page has been moved to the root folder: [php]http://maranatha.web44.net/videos.php[/php]

I made these folder changes to comply with the actual placement according to the website’s content.

You can check all the stuff via the FTP. Once we start connecting some of the stuff, we will start posting code here so others can follow.

Again, just basic layouts are presented. Let me know what you think

Okay, let’s look at the Video Edit demo first…

First, looks pretty good. A couple comments, not sure if they are important…But… (LOL)

If you have an “Update New Video” button, then you do not need the last entry in the video list to be there. I would remove the Add-New-Video from the dropdown.

Is the Jquery file upload working right now? I didn’t try it yet. Get it all working and I will upload a video.

As far as the “preview” I would just make this ONE video only. I should only show the SELECTED video from the list. When the user (ADMIN) selects a video to view or to update the description, it should put that video and description into the preview area.

Get these working along with the Jquery upload and let me know when it is complete. I will play with it some then.

Video Admin nearly done from what I see! Now onto the Album area…

Okay, a quick look at the Album-Admin page and now I see your confusion. I will make some further comments later tonight after looking at your layout online. (FTP) I have a list started and it will take some work to figure out the changes. But, after looking at the real code, I will have a better attack plan.

So, first, finish up the Video-Admin page. Then, if you have some time, here are a few first-look comments on the Album-Admin page.

(Note, I am saying Video-Admin and Album-Admin from now to tell them apart. The “Playlist” is just an internal term we will use for the actual JW Player text that is used only by the database…)

Album-Admin, first same as the video side, if you have a button to Create-New-Album, then you don’t need it in the drop down list. (Perhaps it should actually be a button?)

The drop-down should be “Select your album” not video. This drop down should contain any “ALBUMS” that have been created so far, not videos. (Pulled from the database of course)

To explain Albums further so we are on the same road… There is only three main parts to the Album-Admin page. First, the list of Albums already created. When one is selected, there would be Album-Name, Album-Description and the list of videos that were placed into it. Then, we have to add some buttons for several options such as deleting a video from the album or adding a new video to the album. (Remember, the album will be what we are actually going to play in the player page for people other than the ADMIN.)

Okay, now the confusion part… The middle square of the Album-Admin is the “album” section. It allows the admin to select an album to work on or create a new one. Once one is selected or created, it should list the list of videos that are available and the list of videos currently used in the Album. So, actually, you need two lists. One that contains ALL of the videos that have been uploaded and a second which is just the ones previously selected for the current Album. So, there is some work needed there…

I am curious if you have ever used tables must in HTML. I think that it would make some of this easier to display. But, I am weak in CSS and see you use it well. Just a thought…

Well, will look at the file layout and talk to you more later… (Enough for you to play with for now…)

LOL, you are pretty funny, heh, LOL… you are asking me to do the things that I am actually struggling with like selecting The current video and loading into the player.

I also need your help with the jQuery uploader. Well, it works when you go to it directly:
http://maranatha.web44.net/administrar//dbvideos/_CP/blueimp-jQuery-File-Upload-c40eb03 and not from the admin page.

I think is path issue, but I always struggle with these when pulling things using includes.

I am not quite sure to select only the current video bacuse I don’t have a post variable to compare the videoID field. But, isn’t that going to be done when connecting the player to the playlist (I REALLY nned your help here).

The UPLOAD link is supposed to appear when “Add New Video is selected” but I tried and failed misserably on this stuff.

Okay, LOL, one step at a time. Let’s look at the file uploading…

Do you really need to use that fancy upload include? I think it is pretty! That’s for sure and I will use it in the future, so do not mind learning if you wish. Or, we could just use a simple uploader instead.

I guess it boils down to one question, who is going to use it. If they upload one video at a time and seldom upload a lot of video then we do not need it. If you expect a lot of videos being uploaded, then, we should use it. Years ago ( LOL ! ), I sent you code to upload one video at a time. I have used that routine often and it seems to work good.

Let me know on your opinion on this and I will ATTACK for you! Baby steps…

Well there will be tons of videos upload. SO I’d love to keep it. Again, it works… it’s just a matter of including it the right way, I haven’t been able to do it.

On the though of removing the “Add New Videos” from the list:
Well, if we do that, what happen then to the Title and description? These options are not part of the jQuery uploader… just a thought.

I hear you on the Jquery upload, I will study it for you soon… (tonight for sure!)

On the Video-Admin, the ADD NEW VIDEO would be the Jquery…

On the Album-Admin, there is nothing to upload… To create an Album, this would be a button to create a new one not to load anything. As videos are added the “playlist” in the database would be uploaded with the details needed to play it. But, nothing to upload… Did that make sense?

Let’s get the Video-Admin completely working. I will work on the Jquery upload and look at what you have first. You can look at getting the JW-Player to use the data from the video list. (Basically need to place the name and description into a playlist and update the player with it.) Will let you know when I learn the upload code…

cool.

Sponsor our Newsletter | Privacy Policy | Terms of Service