items.php

来自「Shopping Cart」· PHP 代码 · 共 50 行

<?
require("Cart.php");
DBinfo();
Brand();
Root();
mysql_connect("$DBHost","$DBUser","$DBPass");

if ($UID !=   "") {
$result=mysql(  "$DBName",  "SELECT * FROM Users WHERE User='$UID'");
$num=mysql_num_rows($result);
if ($num ==   "0") {
$dt=date(  "YmdHis");
$UID=  "$dt$REMOTE_ADDR";
$date=date(  "z");
mysql(  "$DBName",  "INSERT INTO Users VALUES ('$UID','$date')");
Header(  "Location: $PHP_SELF?CA=$CA&UID=$UID");
}
}

if ($UID ==   "") {
$dt=date(  "YmdHis");
$UID=  "$dt$REMOTE_ADDR";
$date=date(  "z");
mysql(  "$DBName",  "INSERT INTO Users VALUES ('$UID','$date')");
Header(  "Location: $PHP_SELF?CA=$CA&UID=$UID");
}


commonHeader("$Company","Select an item");
$result=mysql("$DBName","SELECT * FROM Items WHERE Category='$CA' ORDER BY ItemName");
fontFace("Arial","Select an item:<br><br>");
echo "<ul>";
while ($row  =  mysql_fetch_row($result)) {
$IS=$row[0];
$IN=$row[1];
$ID=$row[2];
$IC=$row[3];
$Ca=$row[4];
$SC=$row[5];
$II=$row[6];
fontFace("Arial","<li><a href='$Relative/description.php?II=$II&UID=$UID'>$IN</a>");
if ($ID != "") {
fontFace("Arial"," - $ID"); }
echo "</li>";
        }
echo "</ul>";

commonFooter($Relative,$UID);
?>