-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathadd.php
More file actions
150 lines (128 loc) · 7.4 KB
/
add.php
File metadata and controls
150 lines (128 loc) · 7.4 KB
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
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" integrity="sha384-JcKb8q3iqJ61gNV9KGb8thSsNjpSL0n8PARn9HuZOnIxN0hoP+VmmDGMN5t9UJ0Z" crossorigin="anonymous">
<title>Library Managemant</title>
</head>
<body>
<nav class="navbar navbar-expand-sm navbar-light bg-light">
<a class="navbar-brand" href="#"></a>
<button class="navbar-toggler d-lg-none" type="button" data-toggle="collapse" data-target="#collapsibleNavId" aria-controls="collapsibleNavId"
aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="collapsibleNavId">
<ul class="navbar-nav mr-auto mt-2 mt-lg-0">
<li class="nav-item active">
<a class="nav-link" href="home.php">Home <span class="sr-only">(current)</span></a>
</li>
<li class="nav-item">
<a class="nav-link" href="add.php">Add book</a>
</li>
<li class="nav-item">
<a class="nav-link" href="borrow.php">Borrow</a>
</li>
<li class="nav-item">
<a class="nav-link" href="return.php">Return Book</a>
</li>
</ul>
</div>
</nav>
<form class="form-inline my-2 my-lg-0" action="" method="post">
<input class="form-control mr-sm-2" type="text" placeholder="Search">
<button class="btn btn-outline-success my-2 my-sm-0" type="submit" name="search" >Search Book</button>
</form>
<div class=" d-flex justify-content-center"><p class="pt-5 font-weight-bolder userfont">Delete Book Information</p></div>
<form action="" method="post">
<input class="form-control mr-sm-2" type="text" name="isbn" placeholder="Enter ISBN NUmber">
<button class="btn btn-outline-success my-2 my-sm-0" type="submit" name="delete" >Delete Book</button>
</form>
<form action="" method="post">
<div class="container box pb-3">
<div class=" d-flex justify-content-center"><p class="pt-5 font-weight-bolder userfont">ADD BOOK</p>
</div>
<div class="my-2 boxinfo ">
<input type="text" placeholder="Enter Your Book Name" name="bookName" id="userName" autocomplete="off">
<span id="userNameMess" class="text-danger"></span>
</div>
<div class="my-2 boxinfo ">
<input type="text" placeholder="Enter Publisher name" name="pbname" >
<span id="userEmailMess" class="text-danger"></span>
</div>
<div class=" my-2 boxinfo">
<input type="text" placeholder="Author Name" name="pbdate" >
<span id="userNumMess" class="text-danger"></span>
</div>
<div class=" my-2 boxinfo">
<input type="text" placeholder="Subject Name" name="sub" >
<span id="userNumMess" class="text-danger"></span>
</div>
<div class="my-2 boxinfo" >
<input type="text" placeholder="Enter editin" name="edition" id="" >
<span id="userpassMess" class="text-danger"></span>
</div>
<div class=" my-2 boxinfo">
<input type="text" placeholder="Enter ISBN number" name="isbn">
<span id="userNumMess" class="text-danger"></span>
</div>
<div class=" my-2 boxinfo">
<input type="text" placeholder="Enter Number of copieees" name="ncopy">
<span id="userNumMess" class="text-danger"></span>
</div>
<div class="my-2 d-flex" >
<input type="submit" class="btn btn-sm btn-outline-danger btnSin px-5 font-weight-bolder mt-3" value="ADD book" name="add" required>
</div>
</div>
</form>
<?php
$databaseHost='localhost';
$databaseName='test';
$databaseUsername='root';
$databasePassword='';
$cont=mysqli_connect($databaseHost,$databaseUsername,$databasePassword,$databaseName);
if(!$cont){
die("Connection failed: ".mysqli_connect_error());
}
if(isset($_POST['delete'])){
$on1=$_POST['isbn'];
$query1 = "DELETE FROM tbl_book WHERE isbn='$on1'";
$data=mysqli_query($cont,$query1);
if($data == TRUE)
{
echo "<script>alert('Data Deleted successfully..!');window.location='';</script>";
}
else{echo mysqli_error($cont);}
}
if(isset($_POST['add'])){
$name=$_POST['bookName'];
$pbname=$_POST['pbname'];
$pbdate=$_POST['pbdate'];
$sub=$_POST['sub'];
$edition=$_POST['edition'];
$isbn=$_POST['isbn'];
$ncopy=$_POST['ncopy'];
if($name=="" || $pbname=="" || $pbdate=="" || $edition=="" || $isbn=="" || $ncopy=="" || $sub=="" ){
echo "All fields should be filled.Either one or many fields are empty.";
}
else{
$inst="INSERT INTO tbl_book(name,pbname,pbdate,sub,edition,isbn,ncopy) VALUES('$name','$pbname','$pbdate','$sub','$edition','$isbn','$ncopy')";
$data=mysqli_query($cont,$inst);
if($data == TRUE)
{
echo "<script>alert('Data updated successfully..!');window.location='';</script>";
}
else{echo mysqli_error($cont);}
}
}
?>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<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.1/dist/umd/popper.min.js" integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js" integrity="sha384-B4gt1jrGC7Jh4AgTPSdUtOBvfO8shuf57BaghqFfPlYxofvL8/KUEfYiJOMMV+rV" crossorigin="anonymous"></script>
</body>
</html>