real_escape($_POST['advance_search']);
if(!empty($advance_search)){
$book_title = $db->real_escape($_POST['book_title']);
$subject = $db->real_escape($_POST['subject']);
$author = $db->real_escape($_POST['author']);
$publication = $db->real_escape($_POST['publication']);
$source = $db->real_escape($_POST['source']);
$issbn_no = $db->real_escape($_POST['issbn_no']);
$issn = $db->real_escape($_POST['issn']);
$acc_no = $db->real_escape($_POST['acc_no']);
if(!empty($book_title)){
$where .= " AND book_title LIKE '%$book_title%'";
}
if(!empty($subject)){
$where .= " AND subject IN (SELECT subject_id FROM subject WHERE subject LIKE '$subject%')";
}
if(!empty($author)){
$where .= " AND author LIKE '%$author%'";
}
if(!empty($publication)){
$where .= " AND publication LIKE '%$publication%'";
}
if(!empty($source)){
$where .= " AND source LIKE '%$source%'";
}
if(!empty($issbn_no)){
$where .= " AND issbn_no LIKE '%$issbn_no%'";
}
if(!empty($issn)){
$where .= " AND issn LIKE '%$issn%'";
}
if(!empty($acc_no)){
$where .= " AND acc_no LIKE '%$acc_no%'";
}
}else{
$search_by = $db->real_escape($_POST['search_by']);
$search_value = $db->real_escape($_POST['search_value']);
if($search_by == "subject"){
$where = " AND subject IN (SELECT subject_id FROM subject WHERE subject LIKE '%$search_value%')";
}else{
$where = " AND $search_by LIKE '%$search_value%'";
}
}
?>
Success :
Error :
Search Advance 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']."'"));
?>