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