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 : add-member.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</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' />

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

$edit = false;
$val = $db->real_escape($_GET['val']);

if(!empty($val) && $val == "edit"){
	
	$id = $db->real_escape($_GET['id']);
	$record = $db->fetch_array($db->query("SELECT * FROM member WHERE id = '$id'"));
	$edit = true;
}

if(isset($_POST['save']) || isset($_POST['update'])){

$member_id = $db->real_escape($_POST['member_id']);
$postal_address = $db->real_escape($_POST['postal_address']);
$admission_no = $db->real_escape($_POST['admission_no']);
$member_name = $db->real_escape($_POST['member_name']);
$father_name = $db->real_escape($_POST['father_name']);
$mobile_no = $db->real_escape($_POST['mobile_no']);
$dob = date("Y-m-d",strtotime($db->real_escape($_POST['dob'])));
$email_id = $db->real_escape($_POST['email_id']);
$gender = $db->real_escape($_POST['gender']);

$member_type = $db->real_escape($_POST['member_type']);

$grecord = $db->fetch_array($db->query("SELECT member_type_id FROM member_type WHERE member_type = '$member_type'"));
$member_type_id = $grecord['member_type_id'];

$subject = $db->real_escape($_POST['subject']);

$grecord = $db->fetch_array($db->query("SELECT subject_id FROM subject WHERE subject = '$subject'"));
$subject_id = $grecord['subject_id'];
$department = $db->real_escape($_POST['department']);

$grecord = $db->fetch_array($db->query("SELECT department_id FROM department WHERE department = '$department'"));
$department_id = $grecord['department_id'];

$year = $db->real_escape($_POST['year']);

$grecord = $db->fetch_array($db->query("SELECT year_id FROM year WHERE year = '$year'"));
$year_id = $grecord['year_id'];

$class = $db->real_escape($_POST['class']);

$grecord = $db->fetch_array($db->query("SELECT class_id FROM class WHERE class = '$class'"));
$class_id = $grecord['class_id'];

$member_card_no = $db->real_escape($_POST['member_card_no']);
$book_bank_in_hand = $db->real_escape($_POST['book_bank_in_hand']);
$session = $db->real_escape($_POST['session']);

$grecord = $db->fetch_array($db->query("SELECT session_id FROM session WHERE session = '$session'"));
$session_id = $grecord['session_id'];

$book_in_hand = $db->real_escape($_POST['book_in_hand']);
$date_of_joining = date("Y-m-d",strtotime($db->real_escape($_POST['date_of_joining'])));

$newspaper_in_hand = $db->real_escape($_POST['newspaper_in_hand']);
$date_of_expire = date("Y-m-d",strtotime($db->real_escape($_POST['date_of_expire'])));
$magzine_in_hand = $db->real_escape($_POST['magzine_in_hand']);

if(!empty($_FILES['photo']['name'])){
    $photo = "uploads/photo/".time().$_FILES['photo']['name'];
}else{
    $photo = NULL;
}

if(isset($_POST['save'])){
	
      $query = "INSERT INTO member SET member_id = '$member_id', postal_address = '$postal_address', admission_no = '$admission_no', member_name = '$member_name',
	            father_name = '$father_name', mobile_no = '$mobile_no', dob = '$dob', email_id = '$email_id', member_type = '$member_type_id', subject = '$subject_id',
                department = '$department_id', year = '$year_id', class = '$class_id', member_card_no = '$member_card_no', book_bank_in_hand = '$book_bank_in_hand',
			    session = '$session_id', book_in_hand = '$book_in_hand', date_of_joining = '$date_of_joining', newspaper_in_hand = '$newspaper_in_hand',
			    date_of_expire = '$date_of_expire', photo = '$photo', create_date = NOW(), gender = '$gender', magzine_in_hand = '$magzine_in_hand'";
					   
	  if($db->query($query)){
          
          if(!empty($_FILES['photo']['name'])){
              move_uploaded_file($_FILES['photo']['tmp_name'],$photo);
          }
          
		  $msg = " record successfully Inserted";
		  
	  }	else{
	    
	   $error = "Error";
	   
   }
}elseif(isset($_POST['update'])){
	
	$record_id = $db->real_escape($_POST['record_id']);
	$rec = $db->fetch_array($db->query("SELECT * FROM member WHERE id = '$record_id'"));
if(!empty($_FILES['photo']['name'])){
    $photo = "uploads/photo/".time().$_FILES['photo']['name'];
    unlink($rec['photo']);
}else{
    $photo = $rec['photo'];
}

$query = "UPDATE member SET member_id = '$member_id', postal_address = '$postal_address', admission_no = '$admission_no', member_name = '$member_name',
	            father_name = '$father_name', mobile_no = '$mobile_no', dob = '$dob', email_id = '$email_id', member_type = '$member_type_id', subject = '$subject_id',
                department = '$department_id', year = '$year_id', class = '$class_id', member_card_no = '$member_card_no', book_bank_in_hand = '$book_bank_in_hand',
			    session = '$session_id', book_in_hand = '$book_in_hand', date_of_joining = '$date_of_joining', newspaper_in_hand = '$newspaper_in_hand',
			    date_of_expire = '$date_of_expire', photo = '$photo', create_date = NOW(), gender = '$gender', magzine_in_hand = '$magzine_in_hand' WHERE id = '$record_id'";
					   
	if($db->query($query)){
	    
          if(!empty($_FILES['photo']['name'])){
              move_uploaded_file($_FILES['photo']['tmp_name'],$photo);
          }
          
		$msg = "Record Updated Successfully";
	}else{
		
		$error = "Error";
		
	}
}
   
  }

?>

    <div class="content-wra">
    <div class="content-wrapper">
         <div class="container">
             
             <?php if(!empty($msg)){?>
             
        <div class="row pad-botm">
		   <?php if(!empty($msg)){?>
			<div class="col-md-12">
				     <div class="alert alert-success" >
                           <strong>Success :</strong> <?php echo htmlentities($msg);?>
                     </div>
            </div>
		<?php }elseif(!empty($error)){?>
		    <div class="col-md-12">
				     <div class="alert alert-danger" >
                           <strong>Error :</strong> <?php echo htmlentities($error);?>
                     </div>
            </div>
		<?php }?>
          
        </div>
        
        <?php }?>
        
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="panel panel-info">
<div class="panel-heading">
Add Member
</div>
<div class="panel-body">
<form role="form" id="book_record" method="post" enctype="multipart/form-data">

<fieldset>
<legend style="font-weight:bold;font-size:20px">Member Info</legend>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Member Id<span style="color:red;">*</span></label>
<div style="display:flex;">
    <input type="hidden" name="record_id" id="record_id" value="<?php echo $record['id']?>">
<input class="form-control" type="text" name="member_id" id="member_id" oninput="getBarcode()" value="<?php echo $record['member_id'];?>" autocomplete="off"  required />
&nbsp;&nbsp;&nbsp;<button type="button" name="show" id="show" class="btn btn-info">Show</button>
<p class="help-block"></p>
</div>
</div>

<div class="form-group col-md-4 col-sm-6 col-xs-12">
<label>Postal Address<span style="color:red;">*</span></label>
<textarea class="form-control" name="postal_address" id="postal_address" autocomplete="off" ><?php echo $record['postal_address']?></textarea>
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label> &nbsp;</label>
<img src="<?php echo $record['photo']?>" alt="Member Photo" style="min-height:100px;width:100px;height:100px;border:1px solid" id="image">
</div>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label>Admission No.<span style="color:red;">*</span></label>
<input class="form-control" type="text" name="admission_no" id="admission_no" value="<?php echo $record['admission_no'];?>" autocomplete="off" />
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label>Gender<span style="color:red;">*</span></label>
<select class="form-control" type="text" name="gender" id="gender" autocomplete="off" />
<option value="">Select</option>
<option value="Male" <?php if($record['gender'] == "Male"){echo "selected";}?>>Male</option>
<option value="Female" <?php if($record['gender'] == "Female"){echo "selected";}?>>Female</option>
</select>              
<p class="help-block"></p>
</div>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Member Name<span style="color:red;">*</span></label>
<input class="form-control" type="text" name="member_name" id="member_name" value="<?php echo $record['member_name'];?>" autocomplete="off" />
<p class="help-block"></p>
</div>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Father Name<span style="color:red;">*</span></label>
<input class="form-control" type="text" name="father_name" id="father_name" value="<?php echo $record['father_name'];?>" autocomplete="off" />
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label>Date Of Birth<span style="color:red;">*</span></label>
<input class="form-control datepicker" type="text" name="dob" id="dob" value="<?php echo $record['dob'];?>" autocomplete="off" />
<p class="help-block"></p>
</div>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Email<span style="color:red;">*</span></label>
<input class="form-control" type="text" name="email_id" id="email_id" value="<?php echo $record['email_id'];?>" autocomplete="off" />
<p class="help-block"></p>
</div>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Mobile No<span style="color:red;">*</span></label>
<input class="form-control" type="text" name="mobile_no" id="mobile_no" value="<?php echo $record['mobile_no'];?>" autocomplete="off" />
<p class="help-block"></p>
</div>

</fieldset>

<fieldset>
<legend style="font-weight:bold;font-size:20px">Member Type</legend>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Member Type<span style="color:red;">*</span></label>
<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT member_type FROM member_type WHERE member_type_id = '".$record['member_type']."'"));
}?>
<input class="form-control" type="text" name="member_type" id="member_type" value="<?php echo $mrecord['member_type'];?>" autocomplete="off" 
               list="member_type_list" onkeyup="checkMasterValue(this,'member_type')" required="required">
<datalist id="member_type_list">
   <?php $srecord = $db->query("SELECT * FROM member_type ORDER BY member_type");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['member_type']?>">
	  <?php }?>
</datalist>
<p class="help-block"></p>
</div>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Subject<span style="color:red;">*</span></label>
<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$record['subject']."'"));
}?>
<input class="form-control" type="text" name="subject" id="subject" value="<?php echo $mrecord['subject'];?>" autocomplete="off" 
               list="subject_list" onkeyup="checkMasterValue(this,'subject')" required="required">
<datalist id="subject_list">
   <?php $srecord = $db->query("SELECT * FROM subject ORDER BY subject");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['subject']?>">
	  <?php }?>
</datalist>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Department<span style="color:red;">*</span></label>
<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT department FROM department WHERE department_id = '".$record['department']."'"));
}?>
<input class="form-control" type="text" name="department" id="department" value="<?php echo $mrecord['department'];?>" autocomplete="off" 
               list="department_list" onkeyup="checkMasterValue(this,'department')" required="required">
<datalist id="department_list">
   <?php $srecord = $db->query("SELECT * FROM department ORDER BY department");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['department']?>">
	  <?php }?>
</datalist>
<p class="help-block"></p>
</div>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Class<span style="color:red;">*</span></label>
<div>

<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT class FROM class WHERE class_id = '".$record['class']."'"));
}?>
<input class="form-control" type="text" name="class" id="class" value="<?php echo $mrecord['class'];?>" placeholder="Class" autocomplete="off" 
               list="class_list" onkeyup="checkMasterValue(this,'class')" required="required">
<datalist id="class_list">
   <?php $srecord = $db->query("SELECT * FROM class ORDER BY class");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['class']?>">
	  <?php }?>
</datalist>
</div>
<p class="help-block"></p>
</div>

</fieldset>

<fieldset>
<legend style="font-weight:bold;font-size:20px">Library Info</legend>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label> Member Card No<span style="color:red;">*</span></label>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label> Session<span style="color:red;">*</span></label>
<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT session FROM session WHERE session_id = '".$record['session']."'"));
}?>
<input type="text" class="form-control" name="session" id="session" value="<?php echo $mrecord['session']?>"
list="session_list" onkeyup="checkMasterValue(this,'session')" required="required">
<datalist id="session_list">
   <?php $srecord = $db->query("SELECT * FROM session ORDER BY session");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['session']?>">
	  <?php }?>
</datalist>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label> Date Of Joining<span style="color:red;">*</span></label>
<input type="text" class="form-control datepicker" name="date_of_joining" id="date_of_joining" value="<?php echo $record['date_of_joining']?>">
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label> Date Of Expire<span style="color:red;">*</span></label>
<input type="text" class="form-control datepicker" name="date_of_expire" id="date_of_expire" value="<?php echo $record['date_of_expire']?>">

<fieldset>
<legend style="font-weight:bold;font-size:20px">Controller</legend>

<div class="form-group col-md-1 col-sm-6 col-xs-12">
     <button type="submit" name="update" id="update" class="btn btn-primary" <?php if(!$edit){echo "disabled";}?>>Update</button>
</div>

</div>

</fieldset>

</form>
                            </div>
                        </div>
                            </div>

</div>
   
    </div>
    </div>
     
  <?php include('includes/footer.php');?>
      
    
    
    <script src="assets/js/jquery.js"></script>
    
    <script src="assets/js/bootstrap.js"></script>
      
    <script src="assets/js/custom.js"></script>
	
	<script>
	
	    function getBarcode(){
	        
	        var member_id = $("#member_id").val();
	        
	        if($("#member_id").val() == ""){
	            return false;
	        }
	        
	        $.ajax({
	            type:"POST",
	            url:"getBarcode.php",
	            data:{text:member_id},
	            dataType:"html",
	            success:function(res){
	                
	                $("barcode").attr("src","");
	                $('#barcode').attr("src",res);
	                
	            }
	        });
	      
	    }
	
	    function checkMasterValue(elem,table){
			
			var name = $(elem).val();
			var msg = $(elem).next().attr("class","help-block");

$.ajax({
				type:"POST",
				url:"checkMasterValue.php",
				data:{name:name,val:table},
				dataType:"json",
				success:function(res){
					msg.text(res['msg']);
					$(elem).append(res['data']);
				}
			});
			
		}
	
	</script>
	
	<script>
	
	$(function(){
	    
	    $("#show").click(function(){
	        
	        var member_id = $("#member_id").val();
	        
	        if($("#member_id").val() == ""){
	            return false;
	        }
	        
	        $.ajax({
	            type:"POST",
	            url:"getMemberDetails.php",
	            data:{member_id:member_id},
	            dataType:"JSON",
	            success:function(res){
	                
	                $('#record_id').val(res['record_id']);
	                $('#postal_address').val(res['postal_address']);
                    $('#admission_no').val(res['admission_no']);
                    $('#gender').val(res['gender']);
                    $('#member_name').val(res['member_name']);
                    $('#mobile_no').val(res['mobile_no']);
                    $('#father_name').val(res['father_name']);
                    $('#dob').val(res['dob']);
                    $('#email_id').val(res['email_id']);
                    $('#member_type').val(res['member_type']);
                    $('#subject').val(res['subject']);
                    $('#department').val(res['department']);
                    $('#year').val(res['year']);
                    $('#class').val(res['class']);
                    $('#member_card_no').val(res['member_card_no']);
                    $('#book_bank_in_hand').val(res['book_bank_in_hand']);
                    $('#session').val(res['session']);
                    $('#book_in_hand').val(res['book_in_hand']);
                    $('#date_of_joining').val(res['date_of_joining']);
                    $('#date_of_expire').val(res['date_of_expire']);
                    $('#newspaper_in_hand').val(res['newspaper_in_hand']);
                    $('#magzine_in_hand').val(res['magzine_in_hand']);
                    $('#image').attr("src",res['photo']);
                    $("barcode").attr("src","");
	                $('#barcode').attr("src",res['barcode']);
	                $("#save").prop("disabled",true);
	                $("#update").prop("disabled",false);
	                
	            }
	        });
	        
	    });
	    
	$("#subject").next().attr("class","help-block").text("");
	$("#session").next().attr("class","help-block").text("");
	$("#department").next().attr("class","help-block").text("");
	$("#class").next().attr("class","help-block").text("");
	$("#year").next().attr("class","help-block").text("");
	$("#member_type").next().attr("class","help-block").text("");
	
	     $("#book_record").submit(function(event){
			 
			 if($("#subject").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for subject");
			 }else if($("#session").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for session");
			 }else if($("#department").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for department");
			 }else if($("#class").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for class");
			 }else if($("#year").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for year");
			 }else if($("#member_type").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for member_type");
			 }
			 
		 });
	
		 $(document).keydown(function(e) {
               if ((e.keyCode == 82 || e.keyCode ==116) && e.ctrlKey) {
                   window.location.href="add-member.php";
                    }
              });
		
	});

</script>
	
	
</body>
</html>

${this.title}

Code Editor : add-member.php