<!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>