<?php
$ex=1;
  include "config.php";
  $query = "SELECT executor_name FROM executors WHERE executor_id=$ex";
  // Выполняем SQL-запрос
  $result = mysql_query($query);
  // Проверяем успешность выполнения SQL-запроса
  if(!$result) exit(mysql_error());
  $executors = mysql_fetch_assoc($result);
  //Определяем загаловок страницы
  echo "<center><FONT class=text>".$executors['executor_name'].":</FONT></center><br>";
  $ex=1;
$query = "SELECT image_name FROM executors WHERE executor_id=$ex";
$result = mysql_query($query);
if(!$result)
{
    echo"Ошибка!<br/>".mysql_error();
}
else
{
    if ($row = mysql_fetch_assoc($result)) {
        if ($row['image_name'] != '') {
   include "get.php";
        } else {
            echo "Фото нет";
        }
    } else {
        echo "Пользователя нет";
    }
}
    // Формируем SQL-запрос
  $query = "SELECT song_name,song_id FROM songs WHERE executor_num=$ex";
  // Выполняем SQL-запрос
  $result = mysql_query($query);
  // Проверяем успешность выполнения SQL-запроса
  if(!$result) exit(mysql_error());
  // В цикле выводим песни
while($songs = mysql_fetch_assoc($result))
{
echo "<a class=song_link href=songs_design.php?num=".$songs['song_id']." alt=".$songs['song_name'].">".$songs['song_name']."</a><br>";
}  
?>

<?php
  include "config.php";
  // Извлекаем MP3-файл из базы данных
  $query = "SELECT * FROM executors WHERE executor_id=$ex";
  $img = mysql_query($query);
  if(!$img) exit(mysql_error());
  $executors = mysql_fetch_assoc($img);
$filename = $executors['image_name'];
      
$extension = strtolower(array_shift(array_reverse(explode(".",$filename))));
function content_type($filename) {
  $extension = strtolower(array_shift(array_reverse(explode(".",$filename))));
$mime_types = array(
  "html" => "text/html",
  "txt" => "text/plain",
  "bmp" => "image/bmp",
  "gif" => "image/gif",
  "jpg" => "image/jpeg",
  "jpe" => "image/jpeg",
  "png" => "image/png",
  "ico" => "image/x-icon",
  "swf" => "application/x-shockwave-flash",
  "xml" => "text/xml",
  "xsl" => "text/xml",
  "doc" => "application/msword",
  "xls" => "application/msexcel",
  "xlc" => "application/msexcel",
  "xll" => "application/msexcel",
  "xlm" => "application/msexcel",
  "xlw" => "application/msexcel",
  "pdf" => "application/pdf",
  "ps"  => "application/postscript",
  "eps" => "application/postscript",
  "ai"  => "application/postscript",
  "asp" => "application/x-asp",
  "bak" => "application/x-backup",
  "bz2" => "application/x-bzip2",
  "cgi" => "application/x-cgi",
  "tgz" => "application/x-compressed-tar",
  "core" => "application/x-core-file",
  "csh" => "application/x-cs",
  "dvi" => "application/x-dvi",
  "exe" => "application/x-executable",
  "gtar" => "application/x-gtar",
  "xhtml" => "application/xhtml+xml",
  "xht" => "application/xhtml+xml",
  "class" => "application/x-java=byte-code",
  "jar" => "application/x-jar",
  "js" => "application/x-javascript",
  "pl" => "application/x-perl",
  "perl" => "application/x-perl",
  "php" => "application/x-php",
  "php3" => "application/x-php",
  "php4" => "application/x-php",
  "pyc" => "application/x-python-bytecode",
  "py"  => "application/x-python",
  "rar" => "application/x-rar-compressed",
  "rpm" => "application/x-rpm",
  "sh"  => "application/x-sh",
  "tar" => "application/x-tar",
  "tcl" => "application/tcl",
  "tex" => "application/tex",
  "man" => "application/x-troff-man",
  "zip" => "application/zip",
  "ac3" => "audio",
  "au"  => "audio/basic",
  "snd"  => "audio/basic",
  "mid" => "audio/midi",
  "midi" => "audio/midi",
  "kar" => "audio/midi",
  "mpga" => "audio/mpeg",
  "mp2" => "audio/mpeg",
  "mp3" => "audio/mpeg",
  "ogg" => "audio/x-ogg",
  "ra"  => "audio/x-realaudio",
  "wav" => "audio/x-wav",
  "tif" => "image/tiff",
  "tiff" => "image/tiff",
  "djv" => "image/vnd.djvu",
  "djvu" => "image/vnd.djvu",
  "rtf" => "text/rtf",
  "sgml" => "text/sgml",
  "sgm" => "text/sgml",
  "avi" => "video/x-msvideo");
  if(isset($mime_types[$extension])) {
    return $mime_types[$extension];
  }
  else {
    return "application/octet-stream";
  }
}
$maxage = 86400;
       header("Cache-Control: max-age=$maxage");
       header("Expires: ". date('r', time() + $maxage));
       header("Content-Type: ".content_type($filename));
       header("Content-Length: ".strlen($executors['image_content']));
       header("Content-Disposition: filename=\"$filename\"");
echo $executors['image_content'];
?>