Play a Mysql Blob (wave) file?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • estes53
    New Member
    • May 2007
    • 1

    Play a Mysql Blob (wave) file?

    I am trying to pull a wave/riff file from mysql and make it playable.

    Below is the php which is not working and I have been told that it will not work without referencing a second page, which I want to avoid.

    Anyone know of a Java app that would do it?

    Code-

    $query = 'SELECT `easy1_a_v`.`so und`
    FROM easy1_a_v
    ORDER BY `easy1_a_v`.`ne wlang` ASC';
    $result = mysql_query($qu ery) or die('Query failed: ' . mysql_error());

    echo "<CENTER><H1><t able BORDER=\"4\" CELLPADDING=\"2 \" CELLSPACING=\"2 \" WIDTH=\"50%\">\ n";
    while ($line = mysql_fetch_arr ay($result, MYSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
    echo "\t\t<td><e mbed src=($col_value )
    width=\"200\" height=\"240\" href=(col_value ) target=\"quickt imeplayer\"></td>\n";
    }
    echo "\t</tr>\n";
    }
    echo "</table></H1></CENTER>\n";

    Result-

    <Big empty space where the audio player icon would normally be>...

    ...��WAVEfmt��� U�[1]�À]...

    ...<a lot of RIFF (BLOB from mysql) code>...

    ...ÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿ) width="200" height="240" href=(col_value ) target="quickti meplayer">

    Thanx, Alan
Working...