PHP& MySQL Video Playlist (JW Player)

[jj-dr]

Here’s an update:

found a nice pop window scritpt that I am using:http://yensdesign.com/2008/09/how-to-create-a-stunning-and-smooth-popup-using-jquery/

Here’s the link to the jQuery File Upload official site: http://blueimp.github.com/jQuery-File-Upload/

Installation is easy. Customization a bit harder. Locally, It uploads images (JPG, PNG, GIF) without any issues. However I am getting an error message in web server. I was able to customize the upload folder. However, I had to rename the upload folder back to its original name to make it work on the web server. For now that’s not a big deal.

Here’s a link for my test page. In the meantime, the image uploader files is pulled as an include into the pop up window. But I will change that at some point because it’s kind of heaving on the page this way.

[ErnieAlex]

Well, if you get the smooth nice looking pop-up to work with the nice looking upload and make it all into a simple add-on, I would love to have that in my pile of tools. I do a little uploading, but, wouldn’t mind making it better looking…

Heading out. Will check in when I get back…

[jj-dr]

I am a little confused when you say to another playlist… two playlist on the same page? (see bellow). So we will have
a) Video Scrollable list (only video names)
b) Playlist? (dropdown)
C) Albums Playlist (dropdown?)

Can you make distinction between these playlists, and can you explain with more detail?

I found this nice scrollable menu and I am using it: http://www.queness.com/resources/html/scrollmenu/index.html

Also you mentioned about creating list that’s not editable.

Check it out my updated file:http://maranatha.web44.net/DB_Videos/administrar/playlistAdmin.php and let me know if I am in the right path.

Some thoughts on the playlist ADMIN section. I foresee this as extremely easy.

First, copy your VideoAdmin page and rename it as PlaylistAdmin.

Change the page so it does not allow changes to the Video list.

Add a second list like the current Video items, but for Playlist’s.

On the side, add a scrollable list. (This will show the playlist’s videos by name only)
Once a video is selected on the left drop-down, it is added in the right list.
When a playlist is selected in the middle drop-down, the playlist info is displayed as the video ones are now.
If add-new playlist is selected, you can enter new info and the right-video list is cleared.
Somewhere there will be a CREATE-THIS-PLAYLIST button which can be press once all of the video have been added. If the user wants to alter a current playlist, they select it and then will be able to click on a video and move it up or down or delete it. That is easy to do with buttons that are enabled and disabled.

[ErnieAlex]

Okay, I envision something like the video ADMIN section. It that you have:
(This is in place and mostly live from looking at your sample!)

Video-Dropdown showing current video list and “Add-new-video”
An UPload area for uploading pictures/videos
Text areas for video-name, video-description, video-location
Buttons for UPDATE, CLEAR, DELETE

Now, for the ALBUM area (which I call a PLAYLIST) you will need ALL of the above items
along with new ones for the actual ALBUM data. I suggested combining the two pages
into one with the video section same as now only on left side and the new similar area
on the right for ALBUM’s. Something like this:

Video-Scroll-list (with MultiSelect option) showing the currents video list WITHOUT “add new”
Album DropDown with “Add New Album”
Text areas for Album-Name, Album-description, etc…
Buttons for UPDATE, CLEAR, DELETE

Also, once we get the album loading into the player correctly, we can add a third section
to the bottom of ADMIN page that will DEMO the currently selected ALBUM so the user can
make sure it works before saving it into the database.

Now, that is what I envision. You are skilled at adding nice graphics and I am jealous. I am sure
you will come up with a very nice layout for the combined Video/Album/Demo ADMIN page.
Can’t wait to see it in live use…

[jj-dr]

Thanks Alex. Moving Along. I sent you a Private Message. Check it out.

[jj-dr]

HI Ernie.

I am still confused. Basically, I need to know the order the things will go. I am not sure if you gave me things in order and that’s adding to my confusing.

1. I thought we would have a scroll list first listing all the videos – by name only.

2. Then I thought once we clicked on a of the videos on the scroll, all the relevant info would be posted on the 2nd box ( EDIT VIDEOS) and that this would not be dropdown list, and if so what’s the point of the scroll list on the first box. And here users would be able to edit the selected video.

3. Then on a third box would list albums EDIT PLAYLISTS/ALBUMS

I just need to know the flow as to what goes first, second, third, etc.

Take a look at the latest lay out: http://localhost/MARANATHA_tv/PHPVIDEOS/administrar/playlistAdmin.php#

[ErnieAlex]

First, the link was a localhost version so I could not look at it.

Next, the video and album ADMIN sections are really two separate units.

The Video ADMIN is for uploading videos (creating a new one actually), editting name/description and deleting.

The Album ADMIN is for creating/editting/deleting Album’s only, nothing really to do with the video list.

So, either have separate pages for Video and Album ADMIN pages OR, combine them on one page in two blocks with one on the left and one on the right. I thought since they are not really large, that both would fit on one page. This is really your project, so I was letting you do it how you would like it. If you want me to create a sample for both, I can do that for you. Or, I could just drum up a picture of both with paint to show you my picture of it in my mind. What do you need? I am here tonight working on a site, so should respond…

[jj-dr]

OK, that was part of the confusion.

Sorry about the wrong link. It’s the same as before: http://maranatha.web44.net/DB_Videos/administrar/playlistAdmin.php

Take a look and let me know if I am in the right path. Thanks.

[jj-dr]

I think I am starting to get it: http://maranatha.web44.net/DB_Videos/administrar/playlistAdmin.php#

[ErnieAlex]

Yes, looks like you are getting there. I noted that the middle list of videos is a bit sensitive. Also, I think you will need the left and right side to be a bit further apart. It gives me the feeling it is all lumped together. I think you need to put a more noticeable border around both so it is more separated into videos and albums. Did that make sense. Also, the list of videos on the video side does not match up with the ones inside the scroll list on the album side.

But, it looks like it is starting to come together.

[jj-dr]

Good.

Don’t worry about style for now as I decided to leave that to end so I can concentrate on making all the parts working together first. For now I just want things to be functional.

I promise everything will lo great once is all set.

Thank you… I will keep you posted.

[ErnieAlex]

LOL almost 700 views, 12 pages and counting…

I downloaded that Jquery file uploader. It looks way more fancy than I need, but, I really like the
way it displays and loads and the controls work very nice! Thanks for that link. Not something I ever
search for and I think I will start using it once I study it some. Always nice to run into better code!

Waiting for your next update… (or, question, lol…)

[jj-dr]

Man, my computer died. I mean, it died on me. It won’t turn on. I think my mother board got a short circuit… I am researching to get a new one, or maybe is the Power Supply… hard to tell.

This will slow us down for a week or so. I will keep you posted when I am back in action. I am writing from my wife’s laptop.

[jj-dr]

Hey Ernie, I ordered a new motherboard and should be getting before the end of the week.

I have downloaded the from from the server to an OLD back-up PC I have. So, I guess there be no time wasted. I Will get back in the groove of things tomorrow.

HAPPY HOLIDAY!

[ErnieAlex]

LOL, Glad you are back in business… Working on a lady’s webpage today, but, hope to look at that code you dropped in my lap tonight. (The download form and the pop-up stuff) I have a need for the upload form and I think that smooth one you sent is very nice. Just have to make it into a pop-up type. Thinking that combining the two will be very nice…

Let me know when you are ready for more on our project. Looks like it is coming together nice!
(Hope you are getting paid for all that work!)

[jj-dr]

LOL, my paid is the learning I am getting

I am doing this for the church I attend. It was my initiative to build them a website. Lot’s of work, but I can’t complain. I love helping others whenever I can.

Not working the project today, but early tomorrow I am all in.

Take care.

[jj-dr]

Just so you know, I am already working on the project.

[ErnieAlex]

LOL… Not me, I am working on a paying job. But, will keep an eye out for an update…

[jj-dr]

OK, I think most of the stuff is in place… doesn’t look pretty, but it’s in place. Something is trowing off my CSS layout a bit, but I wouldn’t worry about that for now.

I am having issues with importing the external file of the Pop Up file uploader. Well, the main file loads fine but it doesn’t work when pulling files. I think all this has to do with file path.

I am using the pop up window script by Yen designs (http://yensdesign.com/2008/09/how-to-create-a-stunning-and-smooth-popup-using-jquery/). And I am using a small jQuery script that loads the div (videoPopUp). This is the Image Uploader. I tried using php iclude() before but not luck.

But if if click on the video uploader directly, it works fine: http://maranatha.web44.net/DB_Videos/administrar/jQuery-File-Upload_by_blueimp/jqueryFileUpload.php

I am sending you the FTP info (via PM) so you can check things out.

Let me know where do we go from here… http://maranatha.web44.net/DB_Videos/administrar/playlistAdmin.php#

[ErnieAlex]

Okay, I will look at the code in a little while, I have to leave for an hour.
I looked quickly at the admin page. The video side looks good. Just one comment. The UPLOAD-VIDEO link that brings up the upload screen should only show when the drop-down has selected “ADD-NEW-VIDEO”. The user should not see the upload link until the are create a new video to add to the pile.

One other issue, will the administrator need to know where the video’s are stored? (The Location?) If not, perhaps the videos should just be stored in one folder called “Videos”. If you think there will be a lot of videos, like hundreds, then the location should be there. It is hard to say if one or several folders are needed until the site is working and they actually are using it. You might have to have another ADMIN section to organize video folders later on. Until then, I would think one big folder of videos is fine. The other parts are all saved in the database.

Now, to the Album side… You need to add the buttons to add/delete albums. And, take out the actual display of the playlist. The administrator does not actually need to see the code for the video playlist. That would be hidden from them. You and I need to see it temporarily until the code is done. But, the actual playlist doesn’t mean anything to the person creating them. Lastly, the list on the far right shows the playlists. It was supposed to be a list of the videos available. Hmmm, this entire section needs some tweaking. Basically, it needs an easier way to pick out videos to add to the album-playlist. Perhaps a “Add Video to ALbum” button like the upload-new-video. Where the list on the far right will be the “finished” list of all the videos already selected… When you select an album to edit, the list on the far right would take the video names out of the current playlist for that album an list them. Then, you can delete a video, move them in order, etc… Gee I hope that made sense! Well, think about it and I will get back to you in an hour or two…