LibraryManagmentSystem/Insert_book.php at master · harshil206/LibraryManagmentSystem · 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
<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>Insert record</title>
    <link rel="stylesheet" href="Insert_book.css">
    <style type="text/css">
      body{
        background-image: url("1.jpg");
        background-repeat: no-repeat;
        background-position: center;
        background-size: cover;
        height: 100vh;
      }
      #padd{
        padding: 0px;
        float: right;
      }
      .form{
        margin-right: 55px;
      }
    </style>
  </head>
  <body>
    <ul>
      <li><a href="Home.php">Home</a></li>
      <li><a href="Search_book.php">Find a Book</a></li>
      <li><a href="Update_book.php" >Update Book's record</a></li>
      <li><a href="Insert_book.php" class="home">Add Book in record</a></li>
      <li><a href="Delete_book.php">Delete book from record</a></li>
      <li id="padd">  <form class="" action="" method="post">
          <a href=""><input id="button" type="submit" name="logout" value="Logout"></a>
        </form></li>
    </ul>
    <div class="heading">
      <header>
        <h1>Insert Book</h1>
      </header>
    </div>
    <div class="form">
      <form class="" action="" method="post" name="insert">
        Book-id <br><br><input class="edit" type="text" name="bookid" placeholder="Enter book id"><br><br>
        Book-name <br><br><input  class="edit" type="text" name="bookname" placeholder="Enter book name"><br><br>
        Author-name <br><br><input  class="edit" type="text" name="authorname" placeholder="Enter Author name"><br><br>
        Publisher <br><br><input  class="edit" type="text" name="pubname" placeholder="Enter Publisher name"><br><br>
        Quantity <br><br><input  class="edit" type="text" name="quan" placeholder="Enter Quantity"><br><br>
        Cost <br><br><input  class="edit" type="text" name="price" placeholder="Enter price"><br><br>
        <input  class="button" type="submit" name="insert" value="Insert">
      </form>
    </div>
  </body>
</html>


<?php
  if(isset($_REQUEST["insert"]))
  {
      $id=$_POST["bookid"];
      $name=$_POST["bookname"];
      $Aname=$_POST["authorname"];
      $pub=$_POST["pubname"];
      $quan=$_POST["quan"];
      $price=$_POST["price"];
      $con=new mysqli("localhost","root","Harshil479","library_project");
      // if($con)
      // {
      //   echo "connected";
      // }
      $sql="INSERT INTO `books` (`id`, `name`, `author`, `publisher`, `cost`, `quantity`) VALUES ('$id', '$name', '$Aname', '$pub', '$price', '$quan')";
      $ins=mysqli_query($con,$sql);
      if($ins)
      {
        echo "<script>
              alert('Data is Inserted in Record');
              </script>";
      }
      else {
        echo "string";
      }
  }
  session_start();
  if(isset($_REQUEST["logout"]))
  {
    session_unset();
    session_destroy();
    echo "<script>
           location.href='admin.html';
           </script>";
  }
 ?>