Library-Management-System/book2.php at main · Shigal/Library-Management-System · 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
<?php
	session_start();
	$db = mysqli_connect('localhost', 'root', '', 'lms');

	// initialize variables
	$isbn = "";
	$title = "";
	$author = "";
	$edition = "";
	$publisher = "";
	$year = "";
	$status = "";
	$book_id = 0;
	$update = false;

	if (isset($_POST['save'])) {
		$isbn = $_POST['isbn'];
		$title = $_POST['title'];
		$author = $_POST['author'];
		$edition = $_POST['edition'];
		$publisher = $_POST['publisher'];
		$year = $_POST['year'];
		$status = $_POST['status'];

		mysqli_query($db, "INSERT INTO book (isbn,title,author,edition,publisher,year,status) VALUES ('$isbn', '$title', '$author', '$edition', '$publisher', '$year', '$status')");
		$_SESSION['message'] = "Book saved";
		header('location: book.php');
	}
	if (isset($_POST['update'])) {
		$book_id = $_POST['book_id'];
		$isbn = $_POST['isbn'];
		$title = $_POST['title'];
		$author = $_POST['author'];
		$edition = $_POST['edition'];
		$publisher = $_POST['publisher'];
		$year = $_POST['year'];
		$status = $_POST['status'];

		mysqli_query($db, "UPDATE book SET isbn='$isbn', title='$title', author='$author', edition='$edition', publisher='$publisher', year='$year', status='$status' WHERE book_id= '$book_id'");
		$_SESSION['message'] = "Book updated!";
		header('location: book.php');
}
	if (isset($_GET['del'])) {
	$book_id = $_GET['del'];
	mysqli_query($db, "DELETE FROM book WHERE book_id=$book_id");
	$_SESSION['message'] = "Book deleted!";
	header('location: book.php');
}
	if(isset($_POST['issue'])){
		$issue_id = $_POST['issue_id'];
		$isbn = $_POST['isbn'];
		$issued_book_name = $_POST['issued_book_name'];
		$issued_mem = $_POST['issued_mem'];
		$mem_name = $_POST['mem_name'];
		$issued_date = $_POST['issued_date'];
		$return_date = $_POST['return_date'];

		mysqli_query($db, "SELECT book.isbn,book.title,member.mem_id,member.mem_name,issue_status.issued_date,return_status.return_date FROM issue_status INNER JOIN member ON issued_mem=mem_id INNER JOIN book ON issued_book_name=title WHERE issue_id='$issue_id'");
		$_SESSION['message'] = "Book is Issued!";
		header('location: issue_book.php');
	}

?>