I need to build a digital dictionary with with audio files associated with each word. I currently have a table stored in my MySQL database with with various data columns: words, parts of speech, phonetic transcriptions, and absolute paths that lead to audio files stored on the disk.

I would like to be able to query all the data in the table and get it all to display in a table on my webpage. The problem I'm having is that with the omegle.2yu.co code below, my column of file paths displays as text, not as audio files.

<?php
$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
}
} else {
echo "0 results";
}

mysqli_close($conn);
?>
Any suggestions how to get audio in my table omeglz cells?

Hello,

Please note that this is a forum for our hosting and in general we do not offer web developing services or have the knowledge to answer most of the questions on this matter. You might find more information in web developers' forums instead. Thank you for your understanding.

Best Regards,
Damon Felix
ModeratorsTeam
Freehostia.com

_________________
Damon Felix
ModeratorsTeam
Freehostia.com

Your <div class="nav> element is above your <audio> element.

You can see this easily by adding background: black to .nav in your styles - you will see that the audio controls disappear.

You can fix this in several ways, including adding margin-top to push your content below your header, or adding z-index to your <audio> element to raise it above the header elements. Then you will be able to click the Play button and it will work. (I tested this in the Chrome DevTools.)

However, it looks like your header has other design issues (make your window smaller for one example of how it breaks), so you probably want to make other changes to the header design too.

he answer was right in my face the whole time. Because I was already in a foreach loop for a query that included the joined images table I didn't have to query a second time. I already had the code that checked for an 'm' for mp3. I just had to echo out the controls for audio object with the $posts['image'] there to grab the audio from my database.

elseif (!empty($post['ID']) && ($post['type']== 'm')) {
echo '<audio controls>';
echo '<source
src="data:audio/mp3;base64,'.base64_encode($post['image']).'"‌​>';
echo '</audio>';
}