function get_text($page) { require_once "db_wrapper.php"; $db_wrapper = new db_wrapper(); $connection = $db_wrapper->connect(); $db_wrapper->select_db("vs"); $query = "select pageText from pages where pageName = '{$page}'"; $result = $db_wrapper->do_query($query); $row = $db_wrapper->fetch_array($result); echo $row['pageText']; $db_wrapper->close(); }
<br /> <?php require_once "../php/check_login.php"; require_once "../php/db_wrapper.php"; $db_wrapper = new db_wrapper(); $db_wrapper->connect(); $db_wrapper->select_db(); $itemId = $_GET['itemId']; $do_delete = $_GET['do_delete']; if (!isset($do_delete)) { echo "Are you sure you want to delete this item?"; ?> <p> <form> <input class="button" type="button" onclick="history.back()" value="No - Go back"> </form> </p> <p> <input class="button" type="button" value="Yes - Delete item" onclick="location.href = 'admin.php?p=item_delete&itemId=<?php echo $itemId; ?> &do_delete=1'"> </form> </p> <?php } else { $catPathQuery = "\n select catName, itemThumb from items join categories where itemId = '{$itemId}' and items.catId = categories.catId\n order by items.catId, itemDateAdded desc\n ";
<?php ob_start("ob_gzhandler"); require_once "../php/db_wrapper.php"; $db_wrapper = new db_wrapper(); $db_wrapper->set_log("../php/errorlog.txt"); $db_wrapper->connect(); $db_wrapper->select_db(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html> <head> <title>Velvet Seahorse - Admin</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" type="text/css" href="../css/estilo.css"> </head> <body class="admin"> <?php require_once "../php/check_login.php"; include "head_admin.html"; ?> <!-- begin main --> <?php if (!isset($_GET['p'])) { include "admin_main.php"; } else { switch ($_GET['p']) { case "admin": include "admin_main.php";
<br /> <?php require_once "../php/check_login.php"; require_once "../php/db_wrapper.php"; $db_wrapper = new db_wrapper(); $db_wrapper->connect(); $db_wrapper->select_db(); $itemQuery = "select itemId, items.catId, catName, itemTitle, itemThumb, itemDesc, itemPrice, itemDateAdded " . "from items join categories on items.catId = categories.catId " . "order by items.catId, itemDateAdded desc"; $itemResult = $db_wrapper->do_query($itemQuery); $itemId = ''; $itemTitle = ''; $itemThumb = ''; $catPath = ''; $itemPrice = ''; $itemDesc = ''; $itemDateAdded = ''; while ($row = mysql_fetch_assoc($itemResult)) { $itemId = $row["itemId"]; $itemTitle = $row["itemTitle"]; $itemThumb = $row["itemThumb"]; $catPath = $row["catName"]; $itemPrice = $row["itemPrice"]; $itemDesc = $row["itemDesc"]; $itemDateAdded = $row["itemDateAdded"]; echo "<div class=\"left\">\n"; echo "<div class=\"galleryimg\"><img src=\"../img/shop/{$itemThumb}\" height=\"125\" width=\"125\" border=\"0\"></div>\n"; echo "</div>\n"; echo "<div class=\"right\">\n"; echo "<b>{$itemTitle}</b><br />\n"; echo strtoupper($catPath) . "<br />\n"; echo "\${$itemPrice}<br />\n";
<br /> <?php require_once "../php/check_login.php"; require_once "../php/db_wrapper.php"; $db_wrapper = new db_wrapper(); $db_wrapper->connect(); $db_wrapper->select_db(); $itemId = $_REQUEST['itemId']; $imageUrl = $_REQUEST['imageUrl']; $catPath = $_REQUEST['catPath']; $submit = $_REQUEST['submit']; $do_delete = $_GET['do_delete']; if ($submit != 'delete' && $do_delete != 1) { ?> <img src="../img/shop/<?php echo $imageUrl; ?> "> <form action="admin.php?p=image_delete&itemId=<?php echo $itemId; ?> &imageUrl=<?php echo $imageUrl; ?> &catPath=<?php echo $catPath; ?> " method="post"> <input class="button" type="submit" name="submit" value="delete"> </form> <?php
<br /> <?php require_once "../php/check_login.php"; require_once "../php/db_wrapper.php"; $db_wrapper = new db_wrapper(); $db_wrapper->connect(); $db_wrapper->select_db(); $mode = $_GET['mode']; $itemId = $_GET['itemId']; $itemTitle = ''; $itemDesc = ''; $itemPrice = ''; $catName = ''; $numExistingImages = 0; if ($mode == 'edit') { $itemQuery = "\n select items.catId, catName, itemTitle, itemDesc, itemPrice, itemDateAdded\n from items join categories on items.catId = categories.catId\n where items.itemId = '{$itemId}'\n "; $itemResult = $db_wrapper->do_query($itemQuery); while ($row = $db_wrapper->fetch_array($itemResult)) { $itemTitle = $row['itemTitle']; $itemDesc = $row['itemDesc']; $itemPrice = $row['itemPrice']; $catName = $row['catName']; } $imageQuery = "select count(imageUrl) from itemimage where itemId = '{$itemId}'"; $imageResult = $db_wrapper->do_query($imageQuery); while ($row = $db_wrapper->fetch_array($imageResult)) { $numExistingImages = $row[0]; } } ?> <form enctype="multipart/form-data" action="admin.php?p=item_modify" method="post">