<?php
ini_set("display_errors", 1);
include_once 'function.php';
is_admin();
$id = $_GET['id'];
if (isset($_POST['submit'])) {
updateproduct();
}
$qwe = $db->prepare("select * from `product` where `id`=?");
$qwe->execute(array($id));
$res = $qwe->fetch();
$x = getcategory();
?>
<html>
<head>
<link rel="stylesheet" href="css/styles.css">
<link rel="stylesheet" href="css/style1.css">
<!-- TinyMCE -->
<script src="js/jquery-1.10.2.min.js" type="text/javascript"></script>
<script src="js/setup.js" type="text/javascript"></script/>
<script src="js/tiny-mce/jquery.tinymce.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
setupTinyMCE();
});
</script>
<?php
include_once 'dbconfig.php';
//get the name
$name;
if ($_SERVER["REQUEST_METHOD"] == "GET") {
$x = $_GET['id'];
//this name is used to display filled form in first part and
// to update the required row in the second part.
displayform($x);
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$productname = $_POST["productname"];
$productcategory = $_POST["productcategory"];
$productprice = $_POST["productprice"];
$hiddenname = $_POST["hiddenname"];
updateproduct($hiddenname, $productname, $productcategory, $productprice);
}
function updateproduct($hiddenname, $productname, $productcategory, $productprice)
{
//$name=$GLOBALS['name'];
$sql = "UPDATE products SET product_name='{$productname}',product_category='{$productcategory}', product_price='{$productprice}' WHERE product_id='{$hiddenname}'";
if ($GLOBALS['con']->query($sql) === TRUE) {
echo "Record updated successfully";
header('Location: index.php');
} else {
echo "Error updating record: " . $GLOBALS['con']->error;
}
}
function displayform($x)
{
$id = $x;
