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" <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
