Re: [PHP-DB] playing longblob media
[email protected] (Philip Thompson)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
On Apr 27, 2008, at 9:15 AM, Ron wrote:
> 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
Just like any other field type. Doesn't matter to PHP what the field
type is...
<?php
$sql = "SELECT `longblob_fieldname` FROM `table` WHERE (`id` = '$id')
LIMIT 1";
$result = mysql_query ($sql);
if (mysql_num_rows ($result)) {
$contents = mysql_result ($result, 0);
}
?>
~Philip