Databases
StackOverflow2013
Postsdbo
POHow to play stream audio from a BLOB in php?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to play stream audio from a BLOB in php?
    primarykey
    data
    text
    <p>I have this smartReadFile() php function that allows to play an audio stream from a file. How would you modify this function so it queries mysql database BLOB instead of reading a specific file?</p> <pre><code>function smartReadFile($location, $filename, $mimeType = 'audio/octet-stream') { if (!file_exists($location)) { header ("HTTP/1.1 404 Not Found"); return; } $size = filesize($location); $time = date('r', filemtime($location)); $fm = @fopen($location, 'rb'); if (!$fm) { header ("HTTP/1.1 505 Internal server error"); return; } $begin = 0; $end = $size - 1; if (isset($_SERVER['HTTP_RANGE'])) { if (preg_match('/bytes=\h*(\d+)-(\d*)[\D.*]?/i', $_SERVER['HTTP_RANGE'], $matches)) { $begin = intval($matches[1]); if (!empty($matches[2])) { $end = intval($matches[2]); } } } if (isset($_SERVER['HTTP_RANGE'])) { header('HTTP/1.1 206 Partial Content'); } else { header('HTTP/1.1 200 OK'); } header("Content-Type: $mimeType"); header('Cache-Control: public, must-revalidate, max-age=0'); header('Pragma: no-cache'); header('Accept-Ranges: bytes'); header('Content-Length:' . (($end - $begin) + 1)); if (isset($_SERVER['HTTP_RANGE'])) { header("Content-Range: bytes $begin-$end/$size"); } header("Content-Disposition: inline; filename=$filename"); header("Content-Transfer-Encoding: binary"); header("Last-Modified: $time"); $cur = $begin; fseek($fm, $begin, 0); while(!feof($fm) &amp;&amp; $cur &lt;= $end &amp;&amp; (connection_status() == 0)) { print fread($fm, min(1024 * 16, ($end - $cur) + 1)); $cur += 1024 * 16; } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USChris
    1. USMarcin S.
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POHow to play stream audio from a BLOB in php?
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COInstead of fopen, do query/fetch?
      singulars
      1. POHow to play stream audio from a BLOB in php?
      1. USExplosion Pills
    2. COIn my opinion, you should fetch file from db to temporary file and stream this file. It can take cache functionality also. But continuous reading from database, I really do not know. I do not think it is good idea, specially, if more than one user can be streaming one file...
      singulars
      1. POHow to play stream audio from a BLOB in php?
      1. USFanda
    3. COThank you for the suggestions. I'm not very familiar with php but I'll definitely give it a shot. So I would have: $result = @mysqli_query($dbc, $query); $row = mysqli_fetch_array($result); $fm = $row['file']; How about this line that contains $filename? header("Content-Disposition: inline; filename=$filename");
      singulars
      1. POHow to play stream audio from a BLOB in php?
      1. USMarcin S.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload