-
Notifications
You must be signed in to change notification settings - Fork 0
/
soldptadd.php
130 lines (115 loc) · 3.21 KB
/
soldptadd.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
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
128
129
130
<?php
// Initialize the session
session_start();
// Check if the user is logged in, if not then redirect him to login page
if(!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] !== true){
header("location: login.php");
exit;
}
?>
!doctype html>
<html>
<head>
<title>
Salesdetails
</title>
<style>
body {
margin: 0;
font-family: Arial, Helvetica, sans-serif;
background: #484848;
}
.topnav {
overflow: hidden;
background-color: rgba(249, 105, 14, 1);
height: 70px;
border: 3px solid #e69500;
}
.topnav a {
float: left;
color: #f2f2f2;
text-align: center;
padding: 14px 16px;
text-decoration: none;
font-size: 35px;
font-weight: bold;
}
.topnav-right {
float: right;
}
fieldset { max-width: 450px;
background: #FAFAFA;
padding: 30px;
margin: 50px auto;
box-shadow: 1px 1px 25px rgba(0, 0, 0, 0.35);
border-radius: 10px;
border: 6px solid rgba(249, 105, 14, 1);
}
legend {
padding: 0.2em 0.5em;
border:2px solid rgba(249, 105, 14, 1);
color:green;
font-size:90%;
text-align:center;
}
</style>
</head>
<body>
<div class="topnav">
<a class="active" href="index.php"><img src="ic_add_pet.png"></a>
<a href="sales.php">Sales details</a>
<div class="topnav-right">
<a href="logout.php">logout</a>
</div>
</div>
<form>
<button type="submit" formaction="soldpets.php" style="margin:15px;height: 30px;width: 100px;
border-radius:15px;
border: 3px solid #e69500;background-color: rgba(249, 105, 14, 1);color:#f2f2f2;font-size:15px;cursor:pointer;">Back</button>
</form>
<form method="post" action="soldptadd.php">
<fieldset>
<input type="text" name="id" placeholder="Enter sales details id" style="width:100%;height:30px;
border: 2px solid rgba(249, 105, 14, 1); border-radius:5px; background:transparent;" required>
<br><br>
<input type="text" name="pp" placeholder="Enter pet id" style="width:100%;height:30px;
border: 2px solid rgba(249, 105, 14, 1); border-radius:5px; background:transparent;" required>
<br><br>
<input type="submit" name="submit" value="ADD" style="width:100%;height:30px;
border: 2px solid rgba(249, 105, 14, 1); border-radius:5px; cursor:pointer;background-color: rgba(249, 105, 14, 1)"> 
</fieldset>
</form>
</body>
</html>
<?php
if(isset($_POST["submit"]))
{
// define variables and set to empty values
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "Petshop_management";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
//echo " CONNECTION ESTABLISHED \r\n";
//echo " INSERTION IN PROCESS";
$id = $_POST["id"];
$pet_id = $_POST["pp"];
$sql = "INSERT INTO sold_pets( sd_id,pet_id)
VALUES ('$id','$pet_id')";
if ($conn->query($sql) == TRUE) {
echo'<div>
<h1 style="color:#f2f2f2;font-size:20px; font-family: "Roboto", sans-serif;margin:auto;">New record of sales_id='
.$id.'and pet_id='.$pet_id. ' inserted successfully</h1>
</div>';
$conn->query("call calculations_for_pets('$pet_id','$id')");
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
}
?>