📄 mainpage.htm
字号:
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p> </p>
<?php$host="";$dbusername="root";$dbpassword="";$database="books";$x=mysql_connect($host,$dbusername,$dbpassword);$x2=mysql_select_db($database);if (empty($category)) { $category=0;}$childval=$category;//$catline[]=" "; $query = "select categoryid, name from category where categoryid=\"" . $childval ."\""; $result=mysql_query($query); if ($row=mysql_fetch_array($result)) { $catid[1]=$row["categoryid"]; $catname[1]=$row["name"]; }while (!($childval==0)){ $query="select parentcategoryid from category where categoryid=\"".$childval."\""; $result=mysql_query($query); if ($row=mysql_fetch_array($result)) { $childval= $row["parentcategoryid"]; $query = "select categoryid,name from category where categoryid=\"" . $childval ."\""; $result=mysql_query($query); if ($row=mysql_fetch_array($result)) { $catid[]=$row["categoryid"]; $catname[]=$row["name"]; } }}for ($i=count($catname); $i>0;$i--){//$categoryid=$catid[count($catname)];echo "<A href=mainpage.php?category=".$catid[$i]."&customerid=".$customerid.">".$catname[$i] . "</a> >> ";} ?><table width="900" border="0" cellpadding="3" cellspacing="1">
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>
<form name="form1" method="post" action="">
<div align="right">Search
<input type="text" name="search" size="20">
<select name="searchfor">
<option>ALL</option>
<option>by Album</option>
<option>by Artist</option>
<option>by year of release</option>
</select>
<input type="submit" name="Submit" value="Submit">
</div>
</form>
</td>
<td><a href="asdvancesearch.htm">advance</a></td>
</tr>
</table>
<hr>
<table width="90%" border="0" align="center" cellspacing="1" cellpadding="3">
<tr>
<td>
<h2> Subcategories </h2> <table width="100%" border="0" cellspacing="1" cellpadding="3">
<?$query="select categoryid,name,description from category where parentcategoryid=\"".$category."\"";$result=mysql_query($query);while ($row = mysql_fetch_array($result)){echo " <tr>
";echo " <td height=\"5\">
";echo " <p><b><a href=\"mainpage.php?category=".$row["categoryid"]."&customerid=".$customerid."\">".$row["name"]."</a></b></p>
";echo " </td>
";echo " <td width=\"400\" height=\"5\">
";echo " <p><b>". $row["description"]."</b></p>
";echo " </td>
";echo " </tr>
";}?> </table><h2>Category Products...</h2> <table width="100%" border="1" align="center" cellspacing="1" cellpadding="3">
<tr><td><b> Product </b></td><td><b> Author </b></td><td><b> Description </b></td><td><b> Price </b></td><td colspan=2><b> Action </b></td></tr><?$query="select productid,name, author, description,price from products where category=\"".$category."\"";$result=mysql_query($query);while ($row = mysql_fetch_array($result)){echo " <tr>
";echo " <td>
";echo " <p><b>".$row["name"]."</b></p>
";echo " </td>
";echo " <td>
";echo " <p><b>".$row["author"]."</b></p>
";echo " </td>
";echo " <td>
";echo " <p>". $row["description"]."</p>
";echo " </td>
";echo " <td>
";echo " <p>". $row["price"]."</p>
";echo " </td>
";echo " <td width=\"120\">
";echo " <A target=\"_blank\" href=\"addtocart.php?customerid=".$customerid.
"&productid=".$row["productid"]."\">Add to cart</a>";echo " </td>
";echo " <td width=\"120\">
";echo " <A target=\"_blank\" href=\"removefromcart.php?customerid=".$customerid.
"&productid=".$row["productid"]."\">Remove from cart</a>";echo " </td>
";echo " </tr>
";}?> </table>
</td>
<td width="17%">
<?php echo " <p><a href=\"personalsettings.php?customerid=".$customerid."&category=".$category ."\">Personal Settings</a></p>
";echo " <p><a href=\"viewshoppingcart.php?customerid=".$customerid."&category=".$category ."\">View shopping cart</a></p>
";?> <p><a href="login.htm">log out</a></p>
</td>
</tr>
</table>
<p> </p>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -