Page 1 of 1

Storing video files and playing

Posted: Wed Jan 14, 2009 10:59 am
by andrewj
Hi,

How do i store video files in SQL can i do with BLOB? if so how can i play it online?

Advance thanks

Re: Storing video files and playing

Posted: Wed Jan 14, 2009 11:44 am
by Christopher
You can store any kind of data in a BLOB. Search around for examples of adding and getting BLOB data from your database. And, in general to have PHP generate a response that is not HTML you use the header() method to set the MIME type of the data and then echo/dump the content.

Re: Storing video files and playing

Posted: Wed Jan 14, 2009 11:47 am
by andrewj
hi

I'm a novice :( data is beign saved in the DB, can you please explin in detail as how to do the rest?

Advance big thanks

Re: Storing video files and playing

Posted: Wed Jan 14, 2009 11:52 am
by Christopher
See the manual for the header() function about setting 'Content-type'.

Re: Storing video files and playing

Posted: Wed Jan 14, 2009 12:05 pm
by andrewj
ok i got that can u please tell step by step as how i should proceed. i can send audio to the database. next?

advance thanks