Re: [PHP] Streaming video BLOBs from MySQL

2005-04-18 Thread Richard Lynch
On Thu, April 14, 2005 12:40 pm, J J said: > I have a case where video files (mov, flv, etc) have > been stored in a MySQL database as blobs. Doc: Don't do that. > I'm loading them into a flash video player and > everything works fine except it takes longer it seems > and it doesn't allow streami

Re: [PHP] Streaming video BLOBs from MySQL

2005-04-16 Thread Drewcore
i would approach this from another angle... why not store the videos as regular files on your server, then store the filenames as varchar (or something similar - whatever suits you best) on your database. then you can just pull up the filename from the db, and then load it the old fashioned way...

Re: [PHP] Streaming video BLOBs from MySQL

2005-04-16 Thread Ryan A
On 4/17/2005 2:08:43 AM, Chris Boget ([EMAIL PROTECTED]) wrote: > > If I make one pass and get 1mb of the blob...the > > > browser is simply going to load that 1mb only, right? > > > How do I keep looping and refreshing the users > > > browser, or in this case, flash player? > > > Thanks for a

Re: [PHP] Streaming video BLOBs from MySQL

2005-04-16 Thread Chris Boget
> If I make one pass and get 1mb of the blob...the > browser is simply going to load that 1mb only, right? > How do I keep looping and refreshing the users > browser, or in this case, flash player? > Thanks for any ideas! Look into flush(); thnx, Chris -- PHP General Mailing List (http://www.p

Re: [PHP] Streaming video BLOBs from MySQL

2005-04-16 Thread J J
Hmmm... not sure how this is done. I see someone added an example that they use substring to load 10mb of data at a time from the blob. The part I don't understand is how they loop the statements and continue to stream data to the user. If I make one pass and get 1mb of the blob...the browser is

Re: [PHP] Streaming video BLOBs from MySQL

2005-04-15 Thread Marek Kilimajer
J J wrote: I have a case where video files (mov, flv, etc) have been stored in a MySQL database as blobs. I'm loading them into a flash video player and everything works fine except it takes longer it seems and it doesn't allow streaming the actual video. If I load the same videos with a direct lin

[PHP] Streaming video BLOBs from MySQL

2005-04-14 Thread J J
I have a case where video files (mov, flv, etc) have been stored in a MySQL database as blobs. I'm loading them into a flash video player and everything works fine except it takes longer it seems and it doesn't allow streaming the actual video. If I load the same videos with a direct link to the