real_escape($_POST['val']);
$recode_id = $db->real_escape($_POST['id']);
if(!empty($val) && $val == "del"){
$query = $db->query("DELETE FROM book_record WHERE recode_id = '$recode_id'");
if($db->query($query)){
$msg = "Record Deleted Successfully";
}else{
$error = "Network Error.";
}
}
$book_title = $db->real_escape($_POST['book_title']);
$subject = $db->real_escape($_POST['subject']);
$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($acc_no)){
$where .= " AND acc_no LIKE '%$acc_no%'";
}
/*
$bookRecord = $db->query("SELECT * FROM new_data ORDER BY id ASC");
while($bookResult = $db->fetch_array($bookRecord)){
$language = $db->fetch_array($db->query("SELECT language_id FROM language WHERE language = '".$bookResult['language']."'"));
$subject = $db->fetch_array($db->query("SELECT subject_id FROM subject WHERE subject = '".$bookResult['subject']."'"));
$db->query("UPDATE book_record SET subject = '".$subject['subject_id']."', call_no = '".$bookResult['call_no']."', almirah_no = '".$bookResult['almirah']."',
shelf_no = '".$bookResult['shelf']."', language = '".$language['language_id']."' WHERE acc_no = '".$bookResult['acc_no']."'");
}
*/
?>
Success :
Error :
Search
Books Listing
#
Acc. No
Book Title
Subject
Author
ISBN
Status
Action
query("SELECT * FROM book_record WHERE 1 $where ORDER BY record_id DESC");
$count = $db->num_rows($record);
while($result = $db->fetch_array($record)){
$subject = $db->fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$result['subject']."'"));
$author = $db->fetch_array($db->query("SELECT author FROM author WHERE author_id = '".$result['author']."'"));
$status = $db->fetch_array($db->query("SELECT status FROM status WHERE status_id = '".$result['status']."'"));
?>