Untitled

<html>
<head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  <title>VĂ˝pis dat z databĂˇze</title>
  <style>
  a {text-decoration:none;}
  </style>
</head>
<body>
<h2 align="center">Seznam uĹľivatelĹŻ - vyberte druh Ĺ™azenĂ ve zvolenĂ©m sloupci</h2>
<table width="70%" border="1" align="center">
<tr>
<th>Jméno <a href="serazovani.php?raz=1a">&darr;&darr;</a> <a href="serazovani.php?raz=1b">&uarr;&uarr;</a></th>
<th>Level<a href="serazovani.php?raz=2a">&darr;&darr;</a> <a href="serazovani.php?raz=2b">&uarr;&uarr;</a></th>
<th>Rasa<a href="serazovani.php?raz=3a">&darr;&darr;</a> <a href="serazovani.php?raz=3b">&uarr;&uarr;</a></th>
<th>Povolání<a href="serazovani.php?raz=4a">&darr;&darr;</a> <a href="serazovani.php?raz=4b">&uarr;&uarr;</a></th></tr>

<?php
$DBhost = "localhost";  //Umístění MySQLu
$DBuser = "user";  	//Login do MySQLu
$DBpass = "pass";	//Pass do MySQLu
$DBname = "characters"; //Název characters DB

$id_spojeni = mysql_pconnect($DBhost, $DBuser, $DBpass);
if (!$id_spojeni) die("SpojenĂ s MySQL databĂˇzĂ se nezdaĹ™ilo.");

$vysledek_vybrani = mysql_select_db($DBname, $id_spojeni);
if (!$vysledek_vybrani) die("DatabĂˇzi se nepodaĹ™ilo vybrat.");

mysql_query("SET CHARACTER SET utf8");

switch ($raz):
        case "1a": case "1b": $klic = "name";    break;
        case "2a": case "2b": $klic = "level"; break;
        case "3a": case "3b": $klic = "race";    break;
        case "4a": case "4b": $klic = "class";    break;
        default  :            $klic = "name";
endswitch;

switch ($raz):
    case "1a": case "2a": case "3a": case "4a":  $sql = ("SELECT * FROM $DBname.characters WHERE online='1' ORDER BY $klic ASC");  break;      //vezstupne
    case "1b": case "2b": case "3b": case "4b":  $sql = ("SELECT * FROM $DBname.characters WHERE online='1' ORDER BY $klic DESC"); break;      //sestupne
    default:                                     $sql = ("SELECT * FROM $DBname.characters WHERE online='1' ORDER BY $klic ASC");
endswitch;

$vysledek = mysql_query($sql, $id_spojeni);
if (!$vysledek) die("NepodaĹ™ilo se poslat SQL dotaz do databĂˇze.");


while ($radek = mysql_fetch_array($vysledek)):
       $a = $radek["name"];
       $b = $radek["level"];
       $c = $radek["race"];
       $d = $radek["class"];
       echo "<tr><td>".$a."</td><td>".$b."</td><td>".$c."</td><td>".$d."</td></tr>";
endwhile;

mysql_close($id_spojeni);

?>
</table>
<p align="center"><a href="menu.html">ZpÄ›t do hlavnĂho MENU</a></p>
</body>
</html>