| 1 |
6daefa8c
|
Petr Lukašík
|
<HTML>
|
| 2 |
|
|
<HEAD>
|
| 3 |
|
|
<META content=text/html; http-equiv=Content-Type>
|
| 4 |
|
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
|
| 5 |
|
|
<TITLE>Nastaveni hesel s obrazky</TITLE>
|
| 6 |
|
|
</HEAD>
|
| 7 |
|
|
<body>
|
| 8 |
|
|
<h2><center> Nastaveni hesel s obrazky </center></h2>
|
| 9 |
|
|
<form action="../index.php3">
|
| 10 |
|
|
<input type=submit value="Zpet na hlavni stranku nastroju">
|
| 11 |
|
|
</form>
|
| 12 |
|
|
<hr>
|
| 13 |
|
|
<?
|
| 14 |
|
|
if (! @$spojeni = Pg_Connect("user=vadmin dbname=vseved2"))
|
| 15 |
|
|
{
|
| 16 |
|
|
echo ("Nepodarilo se pripojit do databaze!<br>\n");
|
| 17 |
|
|
echo ("</BODY>");
|
| 18 |
|
|
echo ("</HTML>");
|
| 19 |
|
|
exit;
|
| 20 |
|
|
}
|
| 21 |
|
|
|
| 22 |
|
|
if ($res = Pg_Exec ($spojeni, "SELECT id, fk_obor, fk_heslo, obr_hesla, gen_obr FROM obrhesla ORDER BY id") )
|
| 23 |
|
|
{
|
| 24 |
|
|
$pocet = Pg_NumRows ($res);
|
| 25 |
|
|
echo ("<table border><tr><td><b><center> Obor </center></b></td><td><b><center> Heslo </center></b></td><td><b><center> Obrazek </center></b></td><td><b><center> Soubor </center></b></td><td><b><center> Nastroje </center></b></td></tr>\n");
|
| 26 |
|
|
for ($i = 0; $i < $pocet; $i++)
|
| 27 |
|
|
{
|
| 28 |
|
|
List ($id, $obor, $idhesla, $obr, $obrsoub) = Pg_Fetch_Row($res, $i);
|
| 29 |
|
|
echo ("<tr><td>");
|
| 30 |
|
|
List ($nazevo) = Pg_Fetch_Row ( Pg_Exec ($spojeni, "SELECT nazev FROM c_obor WHERE (obor='$obor')"), 0);
|
| 31 |
|
|
echo ($nazevo);
|
| 32 |
|
|
echo ("</td><td>");
|
| 33 |
|
|
List ($nazevh) = Pg_Fetch_Row (Pg_Exec ($spojeni, "SELECT webnazev FROM ezetdat WHERE (ident='$idhesla')"), 0);
|
| 34 |
|
|
echo ($nazevh);
|
| 35 |
|
|
echo ("</td><td>");
|
| 36 |
|
|
$typ = $obr == "t" ? "Urceny s heslem" : "Jednotny";
|
| 37 |
|
|
echo ($typ);
|
| 38 |
|
|
echo ("</td><td>");
|
| 39 |
|
|
echo ($obrsoub);
|
| 40 |
|
|
echo ("</td><td>");
|
| 41 |
|
|
echo ("<a href=\"./edit.php?polozka=$id\"> upravit </a>");
|
| 42 |
|
|
echo ("</td></tr>");
|
| 43 |
|
|
}
|
| 44 |
|
|
echo ("</table>");
|
| 45 |
|
|
}
|
| 46 |
|
|
Pg_Close ($spojeni);
|
| 47 |
|
|
?>
|
| 48 |
|
|
</body>
|
| 49 |
|
|
</html>
|