inventory/products.php at main · ekanshul/inventory · 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
<?php

$servername = 'sql12.freemysqlhosting.net';
$database = 'sql12627224';
$username = 'sql12627224';
$password = 'VVgGyEIIG4';
$port = 3306;


$conn = new mysqli($servername, $username, $password, $database, $port);

if(!$conn){
    die("Connection Failed".mysqli_connect_error());
}

if(isset($_POST['insert'])){
    $id=$_POST['id'];
    $name=$_POST['name'];
    $level=$_POST['level'];
    $quantity=$_POST['quantity'];
    $cost=$_POST['cost'];

    $sql_query="INSERT INTO products(id,name,level,quantity,cost)VALUES('$id','$name','$level','$quantity','$cost')";
    if(mysqli_query($conn,$sql_query)){
        echo "Inserted Successfully";
    }
    else{
        echo "Error: ".$sql."".$mysqli_error($conn);
    }
    mysqli_close($conn);
}


if(isset($_POST['update'])) {
    $id=$_POST['id'];
    $name=$_POST['name'];
    $level=$_POST['level'];
    $quantity=$_POST['quantity'];
    $cost=$_POST['cost'];


$sql_query="UPDATE products SET quantity='$quantity' WHERE id='$id'";;
if(mysqli_query($conn,$sql_query)){
    echo "Updated successfully";
}
else{
    echo "Error:".$sql."<br>".mysqli_error($conn);
}
mysqli_close($conn);

}

if(isset($_POST['delete'])) {
    $id=$_POST['id'];
    $name=$_POST['name'];
    $level=$_POST['level'];
    $quantity=$_POST['quantity'];
    $cost=$_POST['cost'];


$sql_query="DELETE from products where id='$id'";
if(mysqli_query($conn,$sql_query)){
    echo "Deleted successfully";
}
else{
    echo "Error:".$sql."<br>".mysqli_error($conn);
}
mysqli_close($conn);

}
?>

<?php
if(isset($_POST['view'])) {
    $id=$_POST['id'];
    $name=$_POST['name'];
    $level=$_POST['level'];
    $quantity=$_POST['quantity'];
    $cost=$_POST['cost'];


$sql_query="SELECT * from products where id='$id'";

$result = mysqli_query($conn,$sql_query);

?>

<html>
<head>
    <title>products</title>
</head>
<body>
    <table width='80%' border=1>
    <tr>
        <th>Product ID</th> <th>Product Name</th> <th>Reorder Level</th> <th>Quantity</th> <th>Cost</th>
    </tr>
    <?php
    while($products = mysqli_fetch_array($result)) {

        echo "<tr>";
        echo "<td>".$products['id']."</td>";
        echo "<td>".$products['name']."</td>";
        echo "<td>".$products['level']."</td>";
        echo "<td>".$products['quantity']."</td>";
        echo "<td>".$products['cost']."</td>";
        echo "</tr>";
    }
}
    ?>
    </table>
</body>
</html>