<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-us">
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="main.css" />
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
<meta http-equiv="content-script-type" content="text/javascript"/>
</head>
<body>
<!-- The contents starts here. -->
<h1>beer shop</h1>
<?php
$link=@mysqli_connect('localhost','krichel','');
if(!$link) {
print "shop is closed today, sorry!\n";
}
print "<form action=\"".$_SERVER['PHP_SELF']."\">\n";
print "<table>\n";
mysqli_select_db($link,'krichel');
$result=@mysqli_query($link,"SELECT * from beers ORDER BY price desc");
while($columns=@mysqli_fetch_array($result)) {
print "<tr>\n";
print "<td>".$columns[0]."</td>\n";
print "<td>".$columns[1]."</td>\n";
print "<td><input type=\"text\" size=\"3\" name=\"b".$columns[2]."\"/></td> \n";
print "</tr>\n";
}
print "</table>\n";
print "<div><input name=\"submit\" type=\"submit\" value=\"I order\"/></div>\n";
print "</form>\n";
?>
<p id="validator">
<a href="http://validator.w3.org/check?uri=referer">
<img style="border-width: 0pt" alt="Valid XHTML 1.0!" height="31"
width="88" src="http://dlib.info/valid-xhtml10.png"/>
</a>
</p>
</body>
</html>