forked from hsnmnr/Estore
-
Notifications
You must be signed in to change notification settings - Fork 0
/
updateproductprice.php
48 lines (48 loc) · 1.33 KB
/
updateproductprice.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
<!DOCTYPE>
<html>
<script type="text/javascript">
var store_name = 'E-Store Management System'
document.title=store_name;
document.write("<center><h1>",store_name,"<h1></center>");
</script>
<?php
//ini_set('error_reporting', 'E_COMPILE_ERROR|E_RECOVERABLE_ERROR|E_ERROR|E_CORE_ERROR');
include 'connection.php';
$conn = OpenCon();
session_start();
if($_SESSION["admin"] === false)
{
echo '<script>alert("You are not admin. Only admins can view this page.");</script>';
echo '<script>window.history.back();</script>';
exit;
}
$productid = $_GET['productid'];
$price = $_POST['update_pp'];
$query = 'SELECT * from products where product_id='.$productid;
$result= mysqli_query($conn,$query);
$num = $result->num_rows;
if($num == 1)
{
$query = 'UPDATE products SET price = '.$price.' WHERE product_id='.$productid;
$result= mysqli_query($conn,$query);
if($result == 1)
{
echo '<script>alert("Product Price Updated");</script>';
echo '<script>window.history.back();</script>';
exit;
}
else
{
echo '<script>alert("Unable to update Product Price");</script>';
echo '<script>window.history.back();</script>';
exit;
}
}
else
{
echo '<script>alert("No product found with this ID");</script>';
echo '<script>window.history.back();</script>';
exit;
}
?>
</html>