real_escape($_POST['from_date'])));
$to_date = date("Y-m-d",strtotime($db->real_escape($_POST['to_date'])));
$member_id = $db->real_escape($_POST['member_id']);
$acc_no = $db->real_escape($_POST['acc_no']);
$subject = $db->real_escape($_POST['subject']);
if(!empty($_POST['from_date']) && !empty($_POST['to_date'])){
$where .= " AND return_date BETWEEN '$from_date' AND '$to_date'";
}
if(!empty($member_id)){
$where .= " AND member_id = '$member_id'";
}
if(!empty($subject)){
$where .= " AND subject IN (SELECT subject_id FROM subject WHERE subject LIKE '$subject%')";
}
if(!empty($acc_no)){
$where .= " AND acc_no = '$acc_no'";
}
?>
Books Listing
| # |
Acc. No |
Book Title |
Subject |
Member Id |
Member Name |
Issue Date |
Actual Return Date |
Return Date |
Status |
query("SELECT * FROM issue_and_return WHERE status = 'Returned' $where ORDER BY record_id DESC");
$count = $db->num_rows($record);
while($result = $db->fetch_array($record)){
$book = $db->fetch_array($db->query("SELECT book_title, subject FROM book_record WHERE acc_no = '".$result['acc_no']."'"));
$subject = $db->fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$book['subject']."'"));
$member = $db->fetch_array($db->query("SELECT member_name FROM member WHERE member_id = '".$result['member_id']."'"));
?>
|
|
|
|
|
|
|
|
|
|