real_escape($_POST['session']);
$subject = $db->real_escape($_POST['subject']);
$from_date = date("Y-m-d",strtotime($db->real_escape($_POST['from_date'])));
$to_date = date("Y-m-d",strtotime($db->real_escape($_POST['to_date'])));
if(!empty($session)){
$where .= " AND session = '$session'";
}
if(!empty($subject)){
$where .= " AND subject = '$subject'";
}
if(!empty($_POST['from_date']) && !empty($_POST['to_date'])){
$where .= " AND date_of_entry BETWEEN '$from_date' AND '$to_date'";
}
?>
Success :
Error :
Search
Author Listing
#
Acc. No.
Book Title
Author
Publication
Subject
Call No.
Almirah No.
Shelf No.
Status
Language
query("SELECT * FROM book_record WHERE 1 $where ORDER BY acc_no ASC");
$count = $db->num_rows($record);
while($result = $db->fetch_array($record)){
$getSubject = $db->fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$result['subject']."'"));
$getLanguage = $db->fetch_array($db->query("SELECT language FROM language WHERE language_id = '".$result['language']."'"));
$getStatus = $db->fetch_array($db->query("SELECT status FROM status WHERE status_id = '".$result['status']."'"));
?>