PHP& MySQL Video Playlist (JW Player)

[jj-dr]

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.

[jj-dr]

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

[jj-dr]

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?

[jj-dr]

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

[ErnieAlex]

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.   

[jj-dr]

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.

[jj-dr]

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 Code: [Select]

<!--LOAD EXTERNAL FILE-->
<script type="text/javascript">
$(document).ready(function(){
$('#videoPopUp').load('blueimp-jQuery-File-Upload-c40eb03/index.html');
});
</script>
<!--END LOAD EXTERNAL FILE-->

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.

[ErnieAlex]

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... 

[jj-dr]

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).

[jj-dr]

Hey Ernie, back in action. Check your PM.

[ErnieAlex]

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 )

[jj-dr]

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!

[jj-dr]

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
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 Code: [Select]

http://maranatha.web44.net/videos.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

[ErnieAlex]

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...

[ErnieAlex]

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...)