示例#1
0
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();
}
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">
<input type="hidden" name="MAX_FILE_SIZE" value="8000000" />
<input type="hidden" name="mode" value="<?php