real_escape($_GET['val']); $maxAcc = $db->fetch_array($db->query("SELECT MAX(CAST(acc_no as UNSIGNED)) as acc_no FROM book_record")); $acc_no = $maxAcc['acc_no']; if(!empty($val) && $val == "edit"){ $id = $db->real_escape($_GET['id']); $record = $db->fetch_array($db->query("SELECT * FROM book_record WHERE record_id = '$id'")); $acc_no = $record['acc_no']; $edit = true; } if(isset($_POST['save']) || isset($_POST['update'])){ $acc_no = $db->real_escape($_POST['acc_no']); if($db->num_rows($db->query("SELECT acc_no FROM book_record WHERE acc_no = '$acc_no'"))>0){ $maxAcc = $db->fetch_array($db->query("SELECT MAX(CAST(acc_no as UNSIGNED)) as acc_no FROM book_record")); $acc_no = $maxAcc['acc_no']; } $copies = $db->real_escape($_POST['copies']); $date_of_entry = date("Y-m-d H:i:s",strtotime($db->real_escape($_POST['date_of_entry']))); $book_title = $db->real_escape($_POST['book_title']); $rem_of_title = $db->real_escape($_POST['rem_of_title']); $pages = $db->real_escape($_POST['pages']); $year = $db->real_escape($_POST['year']); $publication_id = $db->real_escape($_POST['publication']); $subject = $db->real_escape($_POST['subject']); $grecord = $db->fetch_array($db->query("SELECT subject_id FROM subject WHERE subject = '$subject'")); $subject_id = $grecord['subject_id']; $bill_no = $db->real_escape($_POST['bill_no']); $currency = $db->real_escape($_POST['currency']); $grecord = $db->fetch_array($db->query("SELECT currency_id FROM currency WHERE currency = '$currency'")); $currency_id = $grecord['currency_id']; $source_id = $db->real_escape($_POST['source']); $language_id = $db->real_escape($_POST['language']); $bill_date = date("Y-m-d",strtotime($db->real_escape($_POST['bill_date']))); $price = $db->real_escape($_POST['price']); $author_id = $db->real_escape($_POST['author']); $material_id = $db->real_escape($_POST['material']); $call_no = $db->real_escape($_POST['call_no']); $co_author = $db->real_escape($_POST['co_author']); $edition = $db->real_escape($_POST['edition']); $book_no = $db->real_escape($_POST['book_no']); $volume = $db->real_escape($_POST['volume']); $issbn_no = $db->real_escape($_POST['issbn_no']); $issn = $db->real_escape($_POST['issn']); $department = $db->real_escape($_POST['department']); $grecord = $db->fetch_array($db->query("SELECT department_id FROM department WHERE department = '$department'")); $department_id = $grecord['department_id']; $status = $db->real_escape($_POST['status']); $grecord = $db->fetch_array($db->query("SELECT status_id FROM status WHERE status = '$status'")); $status_id = $grecord['status_id']; $almirah_id = $db->real_escape($_POST['almirah_no']); $shelf_id = $db->real_escape($_POST['shelf_no']);; if(isset($_POST['save'])){ $k = 0; for($i = 1;$i <= $copies ; $i++){ $query = "INSERT INTO book_record SET acc_no = '$acc_no', copies = '$copies', date_of_entry = '$date_of_entry', book_title = '$book_title', rem_of_title = '$rem_of_title', pages = '$pages', year = '$year', publication = '$publication_id', subject = '$subject_id', bill_no = '$bill_no', currency = '$currency_id', source = '$source_id', language = '$language_id', bill_date = '$bill_date', price = '$price', author = '$author_id', material = '$material_id', call_no = '$call_no', co_author = '$co_author', edition = '$edition', book_no = '$book_no', volume = '$volume', issbn_no = '$issbn_no', issn = '$issn', department = '$department_id', status = '$status_id', almirah_no = '$almirah_id', shelf_no = '$shelf_id', update_date = NULL"; if($db->query($query)){ ++$k; $msg = $k." record successfully Inserted"; } $acc_no++; } if($k == 0){ $error = "Error"; } }elseif(isset($_POST['update'])){ $record_id = $db->real_escape($_POST['record_id']); $query = "UPDATE book_record SET acc_no = '$acc_no', copies = '$copies', date_of_entry = '$date_of_entry', book_title = '$book_title', rem_of_title = '$rem_of_title', pages = '$pages', year = '$year', publication = '$publication_id', subject = '$subject_id', bill_no = '$bill_no', currency = '$currency_id', source = '$source_id', language = '$language_id', bill_date = '$bill_date', price = '$price', author = '$author_id', material = '$material_id', call_no = '$call_no', co_author = '$co_author', edition = '$edition', book_no = '$book_no', volume = '$volume', issbn_no = '$issbn_no', issn = '$issn', department = '$department_id', status = '$status_id', almirah_no = '$almirah_id', shelf_no = '$shelf_id', update_date = NOW() WHERE record_id = '$record_id'"; if($db->query($query)){ $msg = "Record Updated Successfully"; }else{ $error = "Error"; } } } /* $sampleBookRecord = $db->query("SELECT * FROM sample_book_record ORDER BY record_id ASC"); while($sampleBookResult = $db->fetch_array($sampleBookRecord)){ $Oldsubject = $db->fetch_array($db->query("SELECT subject_id FROM subject WHERE subject = '".$sampleBookResult['subject']."'")); $Oldlanguage = $db->fetch_array($db->query("SELECT language_id FROM language WHERE language = '".$sampleBookResult['language']."'")); $Oldcurrency = $db->fetch_array($db->query("SELECT currency_id FROM currency WHERE currency = '".$sampleBookResult['currency']."'")); $Oldstatus = $db->fetch_array($db->query("SELECT status_id FROM status WHERE status = '".$sampleBookResult['status']."'")); $dateEntry = $sampleBookResult['date_of_entry']=="0000-00-00"?NULL:$sampleBookResult['date_of_entry']; $db->query("INSERT INTO book_record SET acc_no = '".$sampleBookResult['acc_no']."', copies = '".$sampleBookResult['copies']."', date_of_entry = '$dateEntry', book_title = '".$sampleBookResult['book_title']."', rem_of_title = '', pages = '".$sampleBookResult['pages']."', year = '".$sampleBookResult['year']."', publication = '".$sampleBookResult['publication']."', subject = '".$Oldsubject['subject_id']."', bill_no = '".$sampleBookResult['bill_no']."', currency = '".$Oldcurrency['currency_id']."', source = '".$sampleBookResult['source']."', language = '".$Oldlanguage['language_id']."', bill_date = '".$sampleBookResult['bill_date']."', price = '".$sampleBookResult['price']."', author = '".$sampleBookResult['author']."', material = '', call_no = '".$sampleBookResult['call_no']."', co_author = '".$sampleBookResult['co_author']."', edition = '".$sampleBookResult['edition']."', book_no = '', volume = '".$sampleBookResult['volume']."', issbn_no = '".$sampleBookResult['isbn']."', issn = '', department = '', status = '".$Oldstatus['status_id']."', almirah_no = '".$sampleBookResult['almirah']."', shelf_no = '".$sampleBookResult['shelf']."', update_date = '".$sampleBookResult['edit_date']."', price_submitted = '".$sampleBookResult['price_submitted']."', price_submitted_date = '".$sampleBookResult['price_submitted_date']."', price_submitted_amount = '".$sampleBookResult['price_submitted_amount']."'"); } */ ?>
Success :
Error :
Add Book
AccInfo
   

value="" autocomplete="off" />

value="" autocomplete="off" />

Book Information

query("SELECT DISTINCT publication FROM book_record ORDER BY publication"); while($sresult = $db->fetch_array($srecord)){?>

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 currency FROM currency WHERE currency_id = '".$record['currency']."'")); }?> query("SELECT * FROM currency ORDER BY currency"); while($sresult = $db->fetch_array($srecord)){?>

query("SELECT DISTINCT source FROM book_record ORDER BY source"); while($sresult = $db->fetch_array($srecord)){?>

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

" autocomplete="off" />

query("SELECT DISTINCT author FROM book_record ORDER BY author"); while($sresult = $db->fetch_array($srecord)){?>

query("SELECT DISTINCT material FROM book_record ORDER BY material"); while($sresult = $db->fetch_array($srecord)){?>

Status
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)){?>

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)){?>

query("SELECT DISTINCT almirah_no FROM book_record ORDER BY almirah_no"); while($sresult = $db->fetch_array($srecord)){?>

query("SELECT DISTINCT shelf_no FROM book_record ORDER BY shelf_no"); while($sresult = $db->fetch_array($srecord)){?>

Controller