real_escape($_GET['val']); if(!empty($val) && $val == "edit"){ $id = $db->real_escape($_GET['id']); $record = $db->fetch_array($db->query("SELECT * FROM member WHERE id = '$id'")); $edit = true; } if(isset($_POST['save'])){ $book_type = $db->real_escape($_POST['book_type']); $issue_date = date("Y-m-d",strtotime($db->real_escape($_POST['issue_date']))); $actual_return_date = date("Y-m-d",strtotime($db->real_escape($_POST['actual_return_date']))); $member_id = $db->real_escape($_POST['member_id']); $acc_no = $db->real_escape($_POST['acc_no']); $activeSession = $db->fetch_array($db->query("SELECT session FROM session WHERE status = 'Active'")); $session = $activeSession['session']; $query = "INSERT INTO issue_and_return SET book_type = '$book_type', issue_date = '$issue_date', actual_return_date = '$actual_return_date', return_date = NULL,member_id = '$member_id', acc_no = '$acc_no', session = '$session'"; if($db->query($query)){ $db->query("UPDATE book_record SET status = '3' WHERE acc_no = 'acc_no'"); $msg = " Record successfully Inserted"; } else{ $error = "Error"; } } ?>
Success :
Error :
Issue Book
Member Information

fetch_array($db->query("SELECT member_type FROM member_type WHERE member_type_id = '".$record['member_type']."'")); }?> query("SELECT * FROM member_type ORDER BY member_type"); while($sresult = $db->fetch_array($srecord)){?>

fetch_array($db->query("SELECT class FROM class WHERE class_id = '".$record['class']."'")); }?> query("SELECT * FROM class ORDER BY class"); while($sresult = $db->fetch_array($srecord)){?>

fetch_array($db->query("SELECT department FROM department WHERE department_id = '".$record['department']."'")); }?> query("SELECT * FROM department ORDER BY department"); while($sresult = $db->fetch_array($srecord)){?>

Book Info

fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$record['subject']."'")); }?> query("SELECT * FROM subject ORDER BY subject"); while($sresult = $db->fetch_array($srecord)){?>

fetch_array($db->query("SELECT status FROM status WHERE status_id = '".$record['status']."'")); }?> query("SELECT * FROM status ORDER BY status"); while($sresult = $db->fetch_array($srecord)){?>

Issue Book Record
S.No Acc No. Subject Issue Date Return Date Action
Controller
Refresh