Re: [PHP-DB] playing longblob media
[email protected] (Philip Thompson)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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" <[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 >>> >>> > > -- > 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