You are here: Re: [PHP] Streaming video BLOBs from MySQL « PHP « IT news, forums, messages
Re: [PHP] Streaming video BLOBs from MySQL

Posted by Marek Kilimajer on 10/04/01 11:14

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 link to the
> http:// file system (/videos/file.flv) it loads in
> super-fast and allows streaming.
>
> I'm guessing mysql and/or php doesn't actually release
> the BLOB until it's loaded it completely.
>
>
> So, is there a way to actually have PHP read the BLOB
> and stream it as it's loading? Is there an fstream()
> option like the fread()?

use mysql's SUBSTRING() function in a loop

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация