Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The "magic" file used has nothing to do with Apache. It is used as <a href="http://en.wikipedia.org/wiki/Magic_number_%28programming%29" rel="nofollow">table of file signatures</a> and is, depending on your system, either a "magic" file distributed with PHP (<code>magic</code> or <code>magic.mime</code> in PHP's directory, most of the time), or the system's "magic" file (used by the <a href="http://linux.die.net/man/1/file" rel="nofollow"><code>file</code> command</a> on Unix).</p> <p>You can also ask to use a specific "magic" file like this:</p> <pre><code>&lt;?php $finfo = new finfo(FILEINFO_MIME, "/usr/share/misc/magic.mgc"); ?&gt; </code></pre> <p>You can either change the system's "magic" file or make your custom one. </p> <p>The <a href="http://www.garykessler.net/library/file_sigs.html" rel="nofollow">standard file signatures</a> for MPEG-4 audio and video are:</p> <pre><code>00 00 00 18 66 74 79 70 33 67 70 35 ....ftyp 3gp5 MP4 MPEG-4 video files 00 00 00 18 66 74 79 70 6D 70 34 32 ... ftyp mp42 M4V MPEG-4 video/QuickTime file 00 00 00 20 66 74 79 70 4D 34 41 20 ... ftyp M4A M4A Apple Lossless Audio Codec file </code></pre> <p>You may want to check first if these are in your "magic" file.</p> <p>From what I remember, m4a (audio) and m4v (video) may have the same mp4 signature (due to bad encoders), so you can't always differenciate one from the other using the "magic" file. You may then put some PHP code to determine, based on file extension (like Windows does), if it's video or audio mp4.</p>
    singulars
    1. This table or related slice is empty.
    1. POPHP finfo detecting m4a audio as video
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UStricasse
    1. UStricasse
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPHP finfo detecting m4a audio as video
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthanks. so in this case, would you suggest I edit the existing magic file, or use another approach?
      singulars
      1. PO
      1. USmomo
    2. CO@BigMoMo I would make a copy and check using the instructions I added above.
      singulars
      1. PO
      1. UStricasse
    3. CO+1 for detail, thanks
      singulars
      1. PO
      1. USmomo
 

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