Re: [PHP-DB] playing longblob media

hi yves,

not sure how large the file is, but i'm assuming a caller would not 
leave a voicemail longer than a minute. max maybe 30 secs. is there a 
query to get the size of a data in a certain row/column?

thank you

regards
ron

Yves Sucaet wrote:
> So how large is the file/BLOB? How many seconds/minutes of data does it 
> contain? The previous author was right: you can retrieve BLOB fields 
> just like any other fields. The problem is sending them back to the client.
> 
> Yves
> 
> ----- Original Message ----- From: "Ron" <[email protected]>
> To: <[email protected]>
> Sent: Sunday, April 27, 2008 10:02 PM
> Subject: Re: [PHP-DB] playing longblob media
> 
> 
>> i'm trying to play a WAV file, this file is a voicemail file generated 
>> by asterisk pbx. it is stored in mysql and i would like users to be 
>> able to check their voicemail via web using php script that will 
>> retrieve it from the db as a wav format already. thank you
>>
>> Yves Sucaet wrote:
>>> What kind of media are you trying to retrieve? Are you trying to 
>>> retrieve the MySQL data and stream that through your script to the 
>>> client? How big is the BLOB?
>>>
>>> If nothing else, you'll need to adapt the MIME-type in the header of 
>>> your HTTP-message.
>>>
>>> HTH,
>>>
>>> Yves
>>>
>>> ----- Original Message ----- From: "Ron" <[email protected]>
>>> To: <[email protected]>
>>> Sent: Sunday, April 27, 2008 9:15 AM
>>> Subject: [PHP-DB] playing longblob media
>>>
>>>
>>>> Hi,
>>>>
>>>> How can i retrieve via php a media stored in a mysql database as 
>>>> longblob?
>>>>
>>>> I'd like to be able to retrieve the media and stream it.
>>>>
>>>> TIA
>>>>
>>>> regards,
>>>> ron
>>>>
>>>> -- 
>>>> PHP Database Mailing List (http://www.php.net/)
>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>
>>>>
>>>
>>>
>>>
>>
>> -- 
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
> 
> 
>