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@xxxxxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Sunday, April 27, 2008 10:02 PM
Subject: Re: 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@xxxxxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Sunday, April 27, 2008 9:15 AM
Subject: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
