Re: question about playlist

"Neil Smith [MVP Digital Media]" wrote:

On Tue, 14 Aug 2007 09:22:02 -0700, Alberto
<Alberto@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Please, I have a question about playlist

I have a dynamic playlist, playlist_1.asx, created by a php script from a
mysql table.
The playlist work for a video streaming website

the mysql table contain information about:

Title_movie = varchar (ex: my first movie)
Name_file = varchar (ex: clip_1.wmv)
Time_start = time (ex: 07:30:00)
Time_length = time (ex: 00:30:00)


In a website page: show_video.php I call the playlist with
<OBJECT id = "player"
CLASSID .........
<Param Name = "autostart".....
<Param Name = "URL" value = "playlist_1.asx"...
</OBJECT>

Now I want to show, in the php page show_video.php, near the player, an
HTML table, like a datagrid, that show the information (Title_movie) about 5
movie near to the playing movie, and when change the movie, contextually
change the information in the table.

Change the information in the *database* table, or in the HTML table ?

I think you're asking to change the HTML content of the table. In that
case, you can use an HTML IFrame instead, and set its
src="show_video.php"

Or you can use one of the AJAX libraries like `Prototype` or `JQuery`
to query the show_video.php page using XMLHTTP request (so the
complete web page doesn not refresh). Look up any generic examples of
"Web 2.0" for this functionality, it need not apply to video as it's
providing just HTML/XML content.

Also, what event do you want use to trigger the change ? That the user
clicks a link ? The video ends ? We need explicit examples to propose
idea ;-)


Cheers - Neil
------------------------------------------------
Digital Media MVP : 2004-2007
http://mvp.support.microsoft.com/mvpfaqs


Ok Neil
Tanks for your help

yes a'm asking to change HTML table
You have gived me a little help:
The solution is indipendent from the playlist, because (with your help) now
I create a new XML file,

from a mysql table, and this file give me a data for the HTML table.

Example:
in my mysql table I have 8 records
Name_file .....Time_start .... Time_length ....Title_movie
1 clip1.wmv ..... 07:00:00 ........ 00:09:59........... title1
2 clip2.wmv...... 07:10:00 ........ 00:49:59........... title2
3 clip3.wmv ..... 08:00:00 ........ 00:59:59........... title3
4 clip4.wmv ..... 09:00:00 ........ 00:59:59........... title4
5 clip5.wmv ..... 10:00:00 ........ 00:59:59........... title5
6 clip6.wmv ..... 11:00:00 ........ 00:59:59........... title6
7 clip7.wmv ..... 12:00:00 ........ 00:59:59........... title7
8 clip8.wmv...... 13:00:00 ........ 00:59:59........... title8

Now I create an XML file (with dynamic data from mysql table) with php (I
know to

make this)
My XML file have
.......
<Time_start>07:00:00</Time_start>
<Time_length>00:09:59<Time_length>
<Title_movie>title1</Title_movie>

<Time_start>07:10:00</Time_start>
<Time_length>00:49:59<Time_length>
<Title_movie>title2</Title_movie>

ecc ...
.........
Now in my php page I want to write an HTML tabe that show (at 7.00.00 o'
clock )
row 1 = title1
row 2 = title2
row 3 = title3
row 4 = title4
row 5 = title5

and at 09.00.00 o' clock show (again):
row 1 = title1
row 2 = title2
row 3 = title3
row 4 = title4
row 5 = title5

BUT at 10.00.00 o'clock show
row 1 = title5
row 2 = title6
row 3 = title7
row 4 = title8
row 5 = title1

So the trigger the change to the day time whith the Time_start
I have to show a palimpsest for users to access the page (at any day time)
I know this in php but not in real time (like ajax or javascript)
Also I will like to show the current movie playing must have the title
highlighted in the HTML row table
I searched for prototype and Web 2 but I diden't find for my problem
Regards

.

Relevant Pages

  • Re: Problems Creating the Code to Open Images Within a Template PHP Page
    ... ste wrote: ... I'm just beginning to learn PHP and MySQL, ... What I want to do is, from a HTML gallery of thumbnails, be able to open a larger version of each thumbnail image in a nice pretty formatted HTML page. ...
    (comp.lang.php)
  • Re: [PHP] HTML pages are faster then php?
    ... [PHP] HTML pages are faster then php? ... as far as I know html page will download faster then the same page made with php getting the same info from mysql, ...
    (php.general)
  • mysql add script
    ... USING PHP & MYSQL BY DAVID TANSLEY. ... <HTML> ...
    (php.general)
  • Re: Umfrage zur Fahrradnutzung - jetzt auch online
    ... als PDF macht, wo doch HTML, PHP, mySQL und Co. existieren. ...
    (de.rec.fahrrad)
  • Re: I am totally stumped..with this on..LOAD_FILE Mysql+PHP= FSCK!!
    ... What I am trying to do is to upload files and stuff them in a mysql database. ... I copied the temporary file to somewhere else, and then handed it to MySQL..THAT WORKED.. ... Is there a way to force a close on the file..maybe that's the problem Mysql is opening a file that is not flushed to disk maybe? ... I gew the feeling its maintaining its own picture of file objects, and doesn't actually flush to the disk unless you do a copy or close php.. ...
    (comp.lang.php)