Databases
StackOverflow2013
Postsdbo
POmov or m4v video embedding (data retrieved from mysql database via php)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmov or m4v video embedding (data retrieved from mysql database via php)
    primarykey
    data
    text
    <p>I am designing a site for an ad production company that want to be able to upload location scouting and casting videos. I have figured out how to get the data out of sql and into the browser with proper headers.</p> <p>Now my issue is - what is the best way to display video at present. I need it to work on iPhones, iPads, Safari and Firefox. I don't care about IE at all.</p> <p>I don't mind restricting them to uploading in only one video format if that helps. Meaning Quicktime .mov only or .m4v only - whatever works. Can't use Flash as iPhones and iPads are involved.</p> <p>I also have no issue accommodating each different browser with different code. I just need to know which method is best for which platform/browser.</p> <p>EDIT:</p> <p>I have figured out how to display the video from the database in the computer browsers I care about (excludes MSIE). Now I need to figure out the iPhone. To test, I put the files into the server's files system and they all play from there via the html5 video tag. So the iPhone is capable of playing the clips' formats. The issue is apparently passing that data to the iPhone from mySQL... Currently, my php file that retrieves the binary data and sends it to the browser specifies the following headers:</p> <pre><code>header("Content-length: $audioLength"); header('Content-Range: bytes 0-'.$audioLength.'/'.$audioLength); header("Content-type: ".$mimeType); </code></pre> <p>where $audioLength is the file size in bytes captured on upload<br> $mimeType is the mime type as reported by the browser at upload - both values are passed to the retrieve_audio.php script form the database along with the binary data.</p> <p>What other headers may be necessary? How would I find out what the difference is between getting the file from the filesystem versus the database?</p> <p>Is is possible the issue is that the iPhone doesn't retrieve the data until you press the play button? As a last resort, I could have the PHP code write the file(s) to the filesystem, but that is duplication of data that I would like to avoid, if possible... </p> <p>Thanks,</p> <p>M</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USManca Weeks
    1. USManca Weeks
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POmov or m4v video embedding (data retrieved from mysql database via php)
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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