#1 · Zasláno:
25. 3. 2007, 22:20:13 · Upravil/a: Cup
ucebnicovy priklad ... a nekona jak by mel ... nevidite prosim chybu??? ... vubec nic to neudela ... je mrtvej jak kdyby s tim phpeckem nebyl vubec propojenej
<!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1250">
<title>Poznejte vína ve vybrane oblasti</title>
</head>
<body bgcolor="white">
<?php
include 'db.inc';
include 'error.inc';
function clean ($input, $maxlength)
{
$input = substr($input, 0, $maxlength);
$input = EscapeShellCmd($input);
return ($input);
}
function displayWinesList($connection, $query, $regionName)
{
if (!($result = @ mysql_query ($query, $connection)))
showerror();
$rowsFound = @ mysql_num_rows($result);
if ($rowsFound > 0)
{
echo "vína z oblasti $regionName <br>";
echo "
<table>
<tr>
" .
"
<th>ID vína</th>" .
"
<th>Název vína</th>" .
"
<th>Typ</th>" .
"
<th>Ročník</th>" .
"
<th>vinařství</th>" .
"
<th>Popis</th>" .
"
</tr>";
while ($row = @ mysql_fetch_array($result))
{
echo "
<tr>" .
"
<td>" . $row["wine_id"] . "</td>" .
"
<td>" . $row["wine_name"] . "</td>" .
"
<td>" . $row["type"] . "</td>" .
"
<td>" . $row["year"] . "</td>" .
"
<td>" . $row["winery_name"] . "</td>" .
"
<td>" . $row["description"] . "</td>" .
"
</tr>";
}
echo "
</table>";
}
echo "Zadaným kriteriím vyhovělo $fowsFound nalezených záznamů<br>";
}
$scriptName = "7-3_vypis_vin_z_databeze.php";
if (empty($regionName))
{
?>
<form action="<?=$scriptName;?>" method="GET">
<br>Zadejte požadovanou vinařskou oblast:
<input type="text" name="regionName" value="Všechny">
(zapisem všechny zobrazíte vsechny oblasti)
<br>
<input type="submit" value="Zobrazit vína">
</form><br>
<a href="index.php">Domů</a>
<?php
}
else
{
$regionName = clean($regionName, 30);
if (!($connection = @ mysql_connect($hostname, $username, $password)))
die ("nemohu se připojit");
if (!mysql_select_db($databasename, $connection))
showerror();
$query = "SELECT w.wine_id,
w.wine_name,
w.description,
w.type,
w.year,
wry.winery_name
FROM winery wry, region r, wine w
WHERE wry.region_id = r.region_id
AND w.winery_id = wry.winery_id";
if ($regionName != "Všechny" )
$query .= " AND r.region_name = "$regionName"";
$query .= " ORDER BY w.wine_name";
displayWinesList($connection, $query, $regionName);
mysql_close($connection);
}
?>
</body>
</html>