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--
pwnkit	10.99 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 : getMemberDetails.php

<?php
include("includes/MainClass.php");

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

$record = $db->query("SELECT * FROM member WHERE member_id = '$member_id'");

if($db->num_rows($record)){
    
    $result = $db->fetch_array($record);
    
    $data['barcode'] = "Barcode Generator/barcode.php?codetype=Code39&size=80&text=".$member_id."&print=true";
    $data['record_id'] = $result['id'];
    $data['postal_address'] = $result['postal_address'];
    $data['admission_no'] = $result['admission_no'];
    $data['gender'] = $result['gender'];
    $data['member_name'] = $result['member_name'];
    $data['mobile_no'] = $result['mobile_no'];
    $data['father_name'] = $result['father_name'];
    $data['dob'] = date('d-m-Y',strtotime($result['dob']));
    $data['email_id'] = $result['email_id'];
    
    $mrecord =$db->fetch_array($db->query("SELECT member_type FROM member_type WHERE member_type_id = '".$result['member_type']."'"));
    $data['member_type'] = $mrecord['member_type'];
    
    $mrecord =$db->fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$result['subject']."'"));
    $data['subject'] = $mrecord['subject'];
    
    
    $mrecord =$db->fetch_array($db->query("SELECT department FROM department WHERE department_id = '".$result['department']."'"));
    $data['department'] = $mrecord['department'];
    
    $mrecord =$db->fetch_array($db->query("SELECT year FROM year WHERE year_id = '".$result['year']."'"));
    $data['year'] = $mrecord['year'];
    
    $mrecord =$db->fetch_array($db->query("SELECT class FROM class WHERE class_id = '".$result['class']."'"));
    $data['class'] = $mrecord['class'];
    
    $mrecord =$db->fetch_array($db->query("SELECT session FROM session WHERE session_id = '".$result['session']."'"));
    $data['session'] = $mrecord['session'];
    
    $data['member_card_no'] = $result['member_card_no'];
    $data['book_bank_in_hand'] = $result['book_bank_in_hand'];
    $data['book_in_hand'] = $result['book_in_hand'];
    $data['date_of_joining'] = date('d-m-Y',strtotime($result['date_of_joining']));
    $data['date_of_expire'] = date('d-m-Y',strtotime($result['date_of_expire']));
    $data['newspaper_in_hand'] = $result['newspaper_in_hand'];
    $data['magzine_in_hand'] = $result['magzine_in_hand'];
    $data['photo'] = $result['photo'];
    
    $issueRecord = $db->query("SELECT * FROM issue_and_return WHERE member_id = '$member_id' AND status = 'Issued'");
    $i = 1;
    while($issueResult = $db->fetch_array($issueRecord)){
        
        $mrecord =$db->fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$issueResult['subject']."'"));
        $data['subject'] = $mrecord['subject'];
        $table .= "<tr>
                       <td>".($i++)."</td>
                       <td>".($issueResult['acc_no'])."</td>
                       <td>".($mrecord['subject'])."</td>
                       <td>".(date('d-m-Y',strtotime($issueResult['issue_date'])))."</td>
                       <td>".(date('d-m-Y',strtotime($issueResult['actual_return_date'])))."</td>
                       <td><button class='btn btn-info' type='button' onclick='returnBook(".$issueResult['record_id'].")'>Return</button></td>
                   </tr>";
                   
    }
    
    $data['table'] = $table;
    
}else{
    
    $data['barcode'] = "";
    $data['record_id'] = "";
    $data['postal_address'] = "";
    $data['admission_no'] = "";
    $data['gender'] = "";
    $data['member_name'] = "";
    $data['mobile_no'] = "";
    $data['father_name'] = "";
    $data['dob'] = "";
    $data['email_id'] = "";
    $data['member_type'] = "";
    $data['subject'] = "";
    $data['department'] = "";
    $data['year'] = "";
    $data['class'] = "";
    $data['member_card_no'] = "";
    $data['book_bank_in_hand'] = "";
    $data['session'] = "";
    $data['book_in_hand'] = "";
    $data['date_of_joining'] = "";
    $data['date_of_expire'] = "";
    $data['newspaper_in_hand'] = "";
    $data['magzine_in_hand'] = "";
    $data['photo'] = "";
    $data['table'] = '';
    
    
}
echo json_encode($data);
?>

${this.title}

Code Editor : getMemberDetails.php