Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>So if you have an AMR file (I haven't tested this, so you'll have to try this out) you will need to extract the AMR audio and convert it to MP3. Unfortunately it appears to be rather rare in Java, but a (rather painful) Google search turned up this link: <a href="http://www.benmccann.com/blog/extracting-amr-audio-from-android-3gp-files/" rel="nofollow">http://www.benmccann.com/blog/extracting-amr-audio-from-android-3gp-files/</a> which claims to demonstrate extracting the audio from a 3gpp video file, so they at least have an AMR parser. I would look at the underlying library they use, isobox4j (discussed at <a href="http://groups.google.com/group/android-developers/browse_thread/thread/245c9de4132c2ab0?fwc=1" rel="nofollow">http://groups.google.com/group/android-developers/browse_thread/thread/245c9de4132c2ab0?fwc=1</a>) and see if you can either:</p> <ol> <li>Extract the audio in the phone app, convert to mp3 and then upload the mp3 (probably the easiest option, frankly: keeps the server simple).</li> <li>Extract the audio on the server and convert to mp3 before streaming the mp3 to the web page (probably harder, frankly).</li> </ol> <p>Good luck.</p> <p>EDIT: or you could hope the client has an appropriate browser plugin: the broken quicktime mark indicates quicktime doesn't have a codec for it.</p> <p>EDIT 2: You probably need to set a content-type for the plugin so it knows what to do. For AMR try adding</p> <pre><code>header("Content-type: audio/amr"); </code></pre> <p>before the echo statement in your PHP and if that isn't enough add a mime type to your embed like this:</p> <pre><code>&lt;object data="sound.php?id=110 width='391' height='298'"&gt; &lt;embed src='sound.php' type="audio/amr" width='391' height='298'&gt;&lt;/embed&gt;'ERROR' &lt;/object&gt; </code></pre> <p>See if that works.</p> <p>EDIT: try this. Not sure if the $row['file'] is considered a string or an array, but the trim might do what you need.</p> <pre><code>&lt;?php header('Content-type: audio/amr'); $query = mysql_query("SELECT * FROM media WHERE media_id= '$idd'"); $row = mysql_fetch_array($query); echo trim($row['file']); exit; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POUploading an audio recording to mysql and playing in website
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBen McCann
    1. USFemi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUploading an audio recording to mysql and playing in website
      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
    1. COWhen i pull the file on to my desktop it plays through both real player and quicktime
      singulars
      1. PO
      1. USJames
    2. COSo either your browser plugins aren't properly configured, or you need to use the right <object> tag to get it to play. See http://support.apple.com/kb/ta26485 for QuickTime embed details
      singulars
      1. PO
      1. USFemi
    3. COMy object is fine with mp3 (although they play through windows media player) updated code to show embedding
      singulars
      1. PO
      1. USJames
 

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