Re: playing longblob media

On Apr 28, 2008, at 9:22 AM, Ron wrote:

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

Assuming you're storing the data as binary, you *should* be able to do a strlen() on the output to get the *file* size. ~Philip

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" <ron@silverbackasp.com> To: <php-db@lists.php.net> 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" <ron@silverbackasp.com> To: <php-db@lists.php.net> 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

--PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

"Personally, most of my web applications do not have to factor 13.7 billion years of space drift in to the calculations, so PHP's rand function has been great for me..." ~S. Johnson