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