Gecko [ www.jdcpatala.org ]

Name	Size	Permission
Barcode Generator	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
datatable	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
uploads	[ DIR ]	drwxr-xr-x
add-almirah.php	4.21 KB	-rw-r--r--
add-author.php	4.19 KB	-rw-r--r--
add-book.php	27.85 KB	-rw-r--r--
add-category.php	2.53 KB	-rw-r--r--
add-class.php	4.03 KB	-rw-r--r--
add-currency.php	4.25 KB	-rw-r--r--
add-department.php	4.27 KB	-rw-r--r--
add-language.php	4.25 KB	-rw-r--r--
add-material.php	4.25 KB	-rw-r--r--
add-member-type.php	4.16 KB	-rw-r--r--
add-member.php	21.16 KB	-rw-r--r--
add-publication.php	4.39 KB	-rw-r--r--
add-session.php	4.63 KB	-rw-r--r--
add-shelf.php	4.17 KB	-rw-r--r--
add-source.php	4.21 KB	-rw-r--r--
add-status.php	4.19 KB	-rw-r--r--
add-subject.php	4.09 KB	-rw-r--r--
add-user.php	7.87 KB	-rw-r--r--
add-year.php	3.99 KB	-rw-r--r--
addBookRecord.php	2.25 KB	-rw-r--r--
book-report.php	13.17 KB	-rw-r--r--
change-password.php	3.95 KB	-rw-r--r--
checkMasterValue.php	984 B	-rw-r--r--
dashboard.php	7.4 KB	-rw-r--r--
edit-author.php	2.22 KB	-rw-r--r--
edit-book.php	3.05 KB	-rw-r--r--
edit-category.php	2.81 KB	-rw-r--r--
getBarcode.php	176 B	-rw-r--r--
getBookDetails.php	2.23 KB	-rw-r--r--
getBookRecord.php	3.34 KB	-rw-r--r--
getMemberDetails.php	4.03 KB	-rw-r--r--
get_book.php	826 B	-rw-r--r--
get_student.php	946 B	-rw-r--r--
index.php	2.08 KB	-rw-r--r--
issue-book.php	15.69 KB	-rw-r--r--
issue-report.php	10.43 KB	-rw-r--r--
issued-books-record.php	10.23 KB	-rw-r--r--
logout.php	498 B	-rw-r--r--
manage-almirah.php	5.22 KB	-rw-r--r--
manage-author.php	5.21 KB	-rw-r--r--
manage-books.php	9.87 KB	-rw-r--r--
manage-categories.php	6.69 KB	-rw-r--r--
manage-class.php	5.09 KB	-rw-r--r--
manage-currency.php	5.25 KB	-rw-r--r--
manage-department.php	5.25 KB	-rw-r--r--
manage-issued-books.php	6.43 KB	-rw-r--r--
manage-language.php	5.25 KB	-rw-r--r--
manage-material.php	5.25 KB	-rw-r--r--
manage-member-type.php	5.16 KB	-rw-r--r--
manage-publication.php	5.29 KB	-rw-r--r--
manage-session.php	5.26 KB	-rw-r--r--
manage-shelf.php	5.2 KB	-rw-r--r--
manage-source.php	5.23 KB	-rw-r--r--
manage-status.php	5.21 KB	-rw-r--r--
manage-subject.php	5.24 KB	-rw-r--r--
manage-year.php	5.06 KB	-rw-r--r--
member-report.php	11.48 KB	-rw-r--r--
member-summary.php	9.42 KB	-rw-r--r--
opac.php	17.53 KB	-rw-r--r--
reg-students.php	4.6 KB	-rw-r--r--
return-book.php	17.45 KB	-rw-r--r--
return-books-record.php	10.44 KB	-rw-r--r--
returnBook.php	382 B	-rw-r--r--
update-issue-bookdeails.php	5.36 KB	-rw-r--r--

Code Editor : update-issue-bookdeails.php

<?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['alogin'])==0)
    {   
header('location:index.php');
}
else{

if(isset($_POST['return']))
{
$rid=intval($_GET['rid']);
$fine=$_POST['fine'];
$rstatus=1;
$sql="update tblissuedbookdetails set fine=:fine,RetrunStatus=:rstatus where id=:rid";
$query = $dbh->prepare($sql);
$query->bindParam(':rid',$rid,PDO::PARAM_STR);
$query->bindParam(':fine',$fine,PDO::PARAM_STR);
$query->bindParam(':rstatus',$rstatus,PDO::PARAM_STR);
$query->execute();

$_SESSION['msg']="Book Returned successfully";
header('location:manage-issued-books.php');

}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
    <meta name="description" content="" />
    <meta name="author" content="" />
    <title>Online Library Management System | Issued Book Details</title>
    
    <link href="assets/css/bootstrap.css" rel="stylesheet" />
    
    <link href="assets/css/font-awesome.css" rel="stylesheet" />
    
    <link href="assets/css/style.css" rel="stylesheet" />
    
    <link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />
<script>
// function for get student name
function getstudent() {
$("#loaderIcon").show();
jQuery.ajax({
url: "get_student.php",
data:'studentid='+$("#studentid").val(),
type: "POST",
success:function(data){
$("#get_student_name").html(data);
$("#loaderIcon").hide();
},
error:function (){}
});
}

//function for book details
function getbook() {
$("#loaderIcon").show();
jQuery.ajax({
url: "get_book.php",
data:'bookid='+$("#bookid").val(),
type: "POST",
success:function(data){
$("#get_book_name").html(data);
$("#loaderIcon").hide();
},
error:function (){}
});
}

</script> 
<style type="text/css">
  .others{
    color:red;
}

</style>

</head>
<body>
      
<?php include('includes/header.php');?>

    <div class="content-wra
    <div class="content-wrapper">
         <div class="container">
        <div class="row pad-botm">
            <div class="col-md-12">
                <h4 class="header-line">Issued Book Details</h4>
                
                            </div>

</div>
<div class="row">
<div class="col-md-10 col-sm-6 col-xs-12 col-md-offset-1"">
<div class="panel panel-info">
<div class="panel-heading">
Issued Book Details
</div>
<div class="panel-body">
<form role="form" method="post">
<?php 
$rid=intval($_GET['rid']);
$sql = "SELECT tblstudents.FullName,tblbooks.BookName,tblbooks.ISBNNumber,tblissuedbookdetails.IssuesDate,tblissuedbookdetails.ReturnDate,tblissuedbookdetails.id as rid,tblissuedbookdetails.fine,tblissuedbookdetails.RetrunStatus from  tblissuedbookdetails join tblstudents on tblstudents.StudentId=tblissuedbookdetails.StudentId join tblbooks on tblbooks.id=tblissuedbookdetails.BookId where tblissuedbookdetails.id=:rid";
$query = $dbh -> prepare($sql);
$query->bindParam(':rid',$rid,PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{               ?>

<div class="form-group">
<label>Student Name :</label>
<?php echo htmlentities($result->FullName);?>
</div>

<div class="form-group">
<label>Book Name :</label>
<?php echo htmlentities($result->BookName);?>
</div>

<div class="form-group">
<label>ISBN :</label>
<?php echo htmlentities($result->ISBNNumber);?>
</div>

<div class="form-group">
<label>Book Issued Date :</label>
<?php echo htmlentities($result->IssuesDate);?>
</div>

<div class="form-group">
<label>Book Returned Date :</label>
<?php if($result->ReturnDate=="")
                                            {
                                                echo htmlentities("Not Return Yet");
                                            } else {

echo htmlentities($result->ReturnDate);
}
                                            ?>
</div>

<?php }else {
echo htmlentities($result->fine);
}
?>
</div>
 <?php if($result->RetrunStatus==0){?>

<button type="submit" name="return" id="submit" class="btn btn-info">Return Book </button>

</div>

<?php }}} ?>
                                    </form>
                            </div>
                        </div>
                            </div>

</div>
   
    </div>
    </div>
     
  <?php include('includes/footer.php');?>
      
    
    
    <script src="assets/js/jquery-1.10.2.js"></script>
    
    <script src="assets/js/bootstrap.js"></script>
      
    <script src="assets/js/custom.js"></script>

</body>
</html>
<?php } ?>

${this.title}

Code Editor : update-issue-bookdeails.php