return_book.php

<?php 
	function get_title(){
		echo "bookstogo | Return Book";
	}

	function display_content() {
		require_once('connection.php');

		$id = $_GET['bt-id'];

		// $sql = "SELECT * FROM borrow_trans WHERE id='$id'";

		$sql = "SELECT sr.student_number,sr.student_name,br.book_code,br.book_title,br.author,br.stocks,bt.date_borrowed,bt.due_date,br.id br_id,bt.id bt_id, bt.book_record_id bt_br_id FROM borrowed_trans bt JOIN students_record sr ON bt.student_number_id = sr.student_number JOIN books_record br ON bt.book_record_id=br.id WHERE bt.id='$id'";

		// WHERE id='$bt_id'
		//WHERE bt.id='$id'

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

		if (mysqli_num_rows($result)>0) {
			while ($row=mysqli_fetch_assoc($result)) {
				extract($row);
			}

			//---------------for return book button-------------------
			if (isset($_POST['return_btn'])) {

				// $sql2 = "UPDATE borrow_trans, books_record 
				// 	SET borrow_trans.stock_id=borrow_trans.stock_id+1, books_record.stocks=books_record.stocks+1 
				// 	WHERE borrow_trans.book_record_id=books_record.id";

				$sql2 = "UPDATE books_record 
					SET books_record.stocks=books_record.stocks+1 
					WHERE books_record.id='$bt_br_id'";

				mysqli_query($conn, $sql2);	



				$save = "INSERT INTO returned_trans (student_number_id,book_record_id,date_borrowed,date_returned)
					VALUES ('$student_number','$br_id','$date_borrowed', NOW())";
				mysqli_query($conn, $save);



				// $sql = "DELETE FROM borrow_trans WHERE id = '$id'";

				$sql = "DELETE FROM borrowed_trans WHERE borrowed_trans.id = '$bt_id'";
				
				mysqli_query($conn, $sql);

				// if (mysqli_num_rows($result) > 0) {
				// 	while ($row = mysqli_fetch_assoc($result)) {
				// 		extract($row);
				// 	}
				// }
				

				if ($sql && $sql2 && $save == true) {
					echo "<div class='alert alert-success'> Deleted from Borrowed List. Will redirect to Transaction Page in 4 seconds... </div>
						<meta http-equiv='refresh' content='4;url=transaction.php'/>
						";
				}  else {
					echo "<div class='alert alert-danger'> Some error occured in your queries :( </div>";
				}
			}  //end of if isset

			echo "
			<div class='container-fluid'>
				<div class='container-fluid rtn-div'>
					<h1>Return Book</h1>

					<form method='POST' action=''>
						<div class='input-group'>
							<span class='input-group-addon'>
								Student Number
							</span>

							<input type='text' class='form-control' name='stud_num' value='$student_number' readonly>
						</div>
						<br>

						<div class='input-group'>
							<span class='input-group-addon'>
								Student Name
							</span>

							<input type='text' class='form-control' name='stud_name' value='$student_name' readonly>
						</div>
						<br>

						<div class='input-group'>
							<span class='input-group-addon'>
								Book Code
							</span>

							<input type='text' class='form-control' name='book_code' value='$book_code' readonly>
						</div>
						<br>

						<div class='input-group'>
							<span class='input-group-addon'>
								Book Title
							</span>

							<input type='text' class='form-control' name='book_title' value='$book_title' readonly>
						</div>
						<br>

						<div class='input-group'>
							<span class='input-group-addon'>
								Author
							</span>

							<input type='text' class='form-control' name='author' value='$author' readonly>
						</div>
						<br>

						<div class='input-group'>
							<span class='input-group-addon'>
								Stock
							</span>

							<input type='text' class='form-control' name='stock' value='$stocks' readonly>
						</div>
						<br>

						<div class='input-group'>
							<span class='input-group-addon'>
								Date Borrowed
							</span>

							<input type='text' class='form-control' name='date_borrowed' value='$date_borrowed' readonly>
						</div>
						<br>

						<div class='input-group'>
							<span class='input-group-addon'>
								Due Date
							</span>

							<input type='text' class='form-control' name='due_date' value='$due_date' readonly>
						</div>
						<br>
						<hr>
						<div class='form-group'>
							<input type='submit' class='btn btn-default' name='return_btn' value='Return Book'>
							
							<a href='transaction.php' class='btn btn-default'> Cancel</a>
						</div>

					</form>
				</div>
			</div>";


		}  //end of if num rows

// $sql = "SELECT * FROM books_record br JOIN borrow_trans bt ON br.stocks = bt.stock_id WHERE $search_col_bk LIKE '%$search_bk%'";

		echo "this is return book page";
	}  //end of display_content function

	require_once('template.php');
 ?>