} print ">" . $prodb->result("name") . "</option>"; } ?> </select></td></tr> <tr><td><input type="radio" name="type" value="product"<?php if (isset($error) && $_POST[type] == 'product') { print " checked=\"checked\""; } elseif (isset($moddb) && $moddb->result("type") == 'product') { print " checked=\"checked\""; } ?> ></td><td>Product <select name="product"><option value=""></option><?php $prodb = new dbi(); $prodb->query("select * from product_category where site = '" . SITE . "' order by name asc"); while ($prodb->loop()) { print "<option value=\"" . $prodb->result("id") . "\""; if (isset($error) && $_POST[type] == "product" && $prodb->result("id") == $_POST[product] || !isset($error) && isset($moddb) && $moddb->result("type") == "product" && $moddb->result("type_id") == $prodb->result("id")) { print " selected=\"selected\""; } print ">" . $prodb->result("name") . "</option>"; } ?> </select></td></tr> </table> </td></tr> <tr bgcolor="#990000"><td colspan="2" align="center"><input type="submit" value="Update"></td></tr> </table> </form> <?php }
} } $db = new dbi(); if (isset($_GET['category'])) { $results = mysql_query("select name from product_category where id = '" . $_GET['category'] . "'", $dbh); $bar_title = "Products for '" . mysql_result($results, 0, "name") . "'"; $db->query("select * from product where category = '{$_GET['category']}' and user = '******' order by sort, description asc"); } else { $results = mysql_query("select email from account where id = '" . $_GET['user'] . "'", $dbh); $bar_title = "Products for '" . mysql_result($results, 0, "email") . "'"; $db->query("select product_category.site,product.* from product inner join product_category on product_category.id = product.category where user = '******'user']}' order by sort, description asc"); } print "<table align=\"center\" cellpadding=\"2\" cellspacing=\"0\">"; print "<tr class=\"bar\"><td>{$bar_title}</td><td align=\"right\"><a href=\"product.php?" . (isset($_GET[category]) ? "category=" . $_GET['category'] : "user="******"&add=1\">Add a Product</a></td></tr>"; if ($db->numrows()) { while ($db->loop()) { print "<tr><td align=\"left\"><a href=\"product.php?" . (isset($_GET[category]) ? "category={$_GET['category']}" : "user={$_GET['user']}") . "&mod=" . $db->result("id"); if (isset($_GET[user])) { print "&setsite=" . $db->result("product_category.site"); } print "\">" . substr($db->result("description"), 0, 60) . "</td><td align=\"right\"><a href=\"product.php?" . (isset($_GET[category]) ? "category=" . $_GET['category'] : "user={$_GET['user']}") . "&delete=" . $db->result("id") . "\">Delete?</a></td></tr>"; } } else { print "<tr><td colspan=\"2\" align=\"center\">No Products for that Category/User!</td></tr>"; } print "</table>"; } include "footer.inc"; ?> </body> </html>
<h1>Invoice for Order #<?php echo $db->result("id"); ?> </h1> <div style="text-align:center;margin:10px;"><a href="invoice.php?<?php echo $db->result("id"); ?> " target="_blank"><b>PRINT A COPY OF THIS INVOICE</b></a></div> <table width="95%" align="center" cellpadding="4" cellspacing="0" style="border:2px solid #000000;"> <tr class="bar"><td align="left" style="font-weight:bold;font-size:14px;" colspan="2">Shipping Information</td></tr> <tr><td colspan="2"> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr><td align="left" class="order_header">Item</td><td align="right" class="order_header">Quantity</td><td align="right" class="order_header">Price</td></tr> <?php $tdb->query("select description,quantity,price from order_items where order_id = '{$order_id}'"); while ($tdb->loop()) { print "<tr><td align=\"left\">" . $tdb->result("description") . "</td><td align=\"right\">" . $tdb->result("quantity") . "</td><td align=\"right\">\$" . sprintf("%0.2f", $tdb->result("price")) . "</td></tr>"; } ?> </table></td> <tr><td valign="top"><?php print_address($db->result("ship_address")); ?> </td><td valign="top"> <table align="right" cellpadding="2" cellspacing="0" border="0"> <tr><td align="right" class="order_header">SubTotal:</td><td align="right">$<?php echo sprintf("%0.2f", $db->result("subtotal")); ?> </td></tr> <tr><td align="right" class="order_header">Shipping & Handling(<?php echo $ship_type[$db->result("ship_method")];