Code: Select all
<?php
include("connection.inc.php");
$connection = connect();
$txtUsername = "";
$txtPassword = "";
if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
{
if (!isset($_POST["Submit"]))
{
$id = $_GET["id"];
$sql = "SELECT * FROM inventory WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
?>
<form action="edit.php" method="POST">
<input type=hidden name="id" value="<?php echo $myrow["id"] ?>">
<div id="content1">
<div class="">
<h2>Edit stock:</h2><p><table align="left">
<td nowrap="nowrap" align="right">Title:</td>
<td><input type="text" name="title" value="<?php echo $myrow["title"] ?>" size=30></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Description:</td>
<td><textarea name="desc" rows=10 cols=30><?php echo $myrow["stockword"] ?></textarea></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Product Code:</td>
<td><input type="text" name="prod_code" value="<?php echo $myrow["prod_code"] ?>" size=30></td>
</tr>
<td nowrap="nowrap" align="right">Brand:</td>
<td><input type="text" name"brand" value="<?php echo $myrow["brand"] ?>" size="30" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Colour:</td>
<td><input type="text" name="colour" value="<?php echo $myrow["colour"] ?>" size="30" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Guarantee details:</td>
<td><input type="text" name="guarantee" value="<?php echo $myrow["guarantee"] ?>" size="30" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Material:</td>
<td> <input type="text" name="material" value="<?php echo $myrow["material"] ?>" size="30" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Product Type:</td>
<td><input type="text" name="prod_type" value="<?php echo $myrow["prod_type"] ?>" size="30" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Style:</td>
<td><input type="text" name="style" value="<?php echo $myrow["style"] ?>" size="30" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Price:</td>
<td><input type="text" name="price" value="<?php echo $myrow["price"] ?>" size=30></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Quantity</td>
<td><input type="text" name="qty" value="<?php echo $myrow["qty"] ?>" size=30></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Main Category:</td>
<td><input type="text" name="main" value="<?php echo $myrow["main_cator"] ?>" size=30></td>
</tr>
<td nowrap="nowrap" align="right">Sub Category:</td>
<td ><input type="text" name="sub" value="<?php echo $myrow["second"] ?>" size=30></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Special Offer:</td>
<td><input type="text" name="special" value="<?php echo $myrow["special"] ?>" size=30></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Special offer info:</td>
<td><input type="text" name="special_deal_info" value="<?php echo $myrow["special_deal_info"] ?>" size=30 /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Additional Infomation:</td>
<td><textarea name="additional_info" rows="10" cols="30"><?php echo $myrow["additional_info"] ?></textarea></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="center">Insert</td>
<td> <input type="hidden" name="cmd" value="edit">
<input type="Submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>
<? } ?>
<?
if ($_POST["Submit"])
{
$title = $_POST["title"];
$desc = $_POST["stockword"];
$prod_code = $_POST["prod_code"];
$brand = $_POST["brand"];
$colour = $_POST["colour"];
$guarantee = $_POST["guarantee"];
$material = $_POST["material"];
$prod_type = $_POST["prod_type"];
$style = $_POST["style"];
$main = $_POST["main_cator"];
$sub = $_POST["second"];
$price = $_POST["price"];
$qty = $_POST["qty"];
$special = $_POST["special"];
$special_deal_info = $_POST["special_deal_info"];
$additional_info = $_POST["additional_info"];
$sql = "UPDATE inventory SET title='$title',stockword='$desc',prod_code='$prod_code',brand='$brand',colour='$colour',guarentee='$guarentee',material='$material',prod_type='$prod_type',style='$style',main='$main',second='$sub',price='$price',qty='$qty',special='$special',special_deal_info='$special_deal_info',additional_info='$additional_info' WHERE id=$id)";
echo "Thank you! Information updated.";
print $sql;
}
}
?>
cheers