<?php
use DByte\DB;
DB::$c = $pdo;
ob_flush();
flush();
$row_break_counter = 0;
for ($i = 0; $i < $nrows; $i++) {
$row = mysqli_fetch_array($result);
extract($row);
if ($row_break_counter == 0) {
echo "<div class=\"row\">";
}
$row_break_counter = $row_break_counter + 1;
echo "<div class=\"col-lg-4\">";
$ColID = DB::column('SELECT ColID FROM `Sounds` WHERE SoundID = ' . $SoundID);
$SiteID = DB::column('SELECT SiteID FROM `Sounds` WHERE SoundID = ' . $SoundID);
$DirID = DB::column('SELECT DirID FROM `Sounds` WHERE SoundID = ' . $SoundID);
$small_spectrogram = DB::column('SELECT ImageFile FROM `SoundsImages` WHERE ImageType="spectrogram-small" AND SoundID = ' . $SoundID);
$small_spectrogram_path = "sounds/images/{$ColID}/{$DirID}/{$small_spectrogram}";
if (!is_file("{$absolute_dir}/{$small_spectrogram_path}")) {
$small_spectrogram_path = "images/notready-small.png";
}
echo "<a href=\"db_filedetails.php?SoundID={$SoundID}\" title=\"Click for file details and more options\">\n\t\t<img src=\"{$small_spectrogram_path}\" width=\"300\" height=\"150\" style=\"margin-top: 20px;\"><br>\n\t\t{$SoundName}</a>";
if (isset($Date_h) && $Date_h != "") {
echo "<br>{$Date_h} | {$Time}";
}
if (!isset($show_tags)) {
$show_tags = 0;
}
flush();
