inventorywebsite/pdatabase-edit.php at master · rajghadi1/inventorywebsite · GitHub

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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
<?php
$con=mysqli_connect("localhost","root","","inventory")or die(mysqli_error());

$id=$_GET['id'];
$name="";
$type="";
$price="";
$quantity="";
$qll="";
$res=mysqli_query($con,"SELECT * FROM product WHERE id=$id ");
while($row=mysqli_fetch_array($res))
{
   $name=$row['item_name'];
   $type=$row['type'];
   $price=$row['price'];
   $quantity=$row['quantity'];
   $qll=$row['qll'];
}

?>


<!DOCTYPE html>
<html>
<head>
	<title>product</title>
	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
	<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
    <style>
    	.jumbotron{
    		width: 90%;
    		margin-left: 80px;
    		margin-top: 50px;
    	}
      body{
        background:#000000  ;


      }


    </style>
</head>
<body>

 <div class="container">
       <div class="row justify-content-center">


       <div class="jumbotron"><center><h1>Add Products to Sell Here</h1></center></div>

       <form action="" method="POST" enctype="multipart/form-data" style="margin-bottom: 15px ; width:500px">

       	<div  class="form-group">

       	<input type="text" placeholder="Enter product Name" name="name" class="form-control" style="border:none;
          border-bottom: 3px solid #00FF7F;background:none;padding-bottom: 15px;font-size: 25px"  value="<?php echo $name ?>"><br>
       </div>

       	<div class="form-group">

       	<input type="text" placeholder="Enter product type" name="type" class="form-control" style="border:none;
          border-bottom: 3px solid #00FF7F;background:none;padding-bottom: 15px;font-size: 25px"  value="<?php echo $type ?>"><br>
       </div>


       	<div class="form-group">

       	<input type="text" placeholder="Enter product amount" name="price" class="form-control" style="border:none;
          border-bottom: 3px solid #00FF7F; background:none;padding-bottom: 15px;font-size: 25px"  value="<?php echo $price ?>"><br>
       </div>

       <div class="form-group">

       	<input type="text" placeholder="Enter product quantity" name="quantity" class="form-control" style="border:none;
          border-bottom: 3px solid #00FF7F;background:none;padding-bottom: 15px;font-size: 25px"   value="<?php echo $quantity ?>"><br>
       </div>

       <div class="form-group">

       	<input type="text" placeholder="Enter product quantity lower limit" name="qll" class="form-control" style="border:none;
          border-bottom: 3px solid #00FF7F;background:none;padding-bottom: 15px;font-size: 25px"   value="<?php echo $qll ?>"><br>
       </div>

       <div class="form-group">

       	<input type="file" name="image" id="image" class="form-control" class="form-control" style="border:none;
          border-bottom: 3px solid #00FF7F;background:none;padding-bottom: 15px;font-size: 25px"><br>
       </div>

       <div>
            	<button type="submit" id="insert" name="update" class="btn btn-success">Update</button>
       </div>
       </form>
     </div>
  </div>
</body>
</html>


<?php
 if(isset($_POST['update'])){
          mysqli_query($con,"UPDATE product SET item_name='$_POST[name]',type='$_POST[type]',price='$_POST[price]',quantity='$_POST[quantity]',qll='$_POST[qll]' WHERE id=$id");

         ?>

                <script>
                    location.href ='pdatabase.php';
                    window.alert("Database updated");

               </script>

         <?php


   }


?>