m*!ub}r]oP0̰Mc{8 i-齗Y؞::6p[.K{,-,__ HW|" H]{dZyh`n S7zeZZ:SB|~ 6I8pOS(f(e^W O_Nww%‹遬svśF/̿ T$I%XB[+vsJA/I3{X0ȰznM; |mI݄H ɿGKUӥRU~D逝]y@=f:A07x: S F/bqɫ'jJgNr${@-kOp\nGY)vGy9eO ᓛw-+qc.zhC?'Cf\&h!g kO=3qNHSakr/ɴDAS IjۖKE0Op[ۨدY')&" Z=Mƺ͕YUr JM(!a+ {9O5V䐓cl%L']4_̎F[;=veVʮps  ZY 1?1VڼTĤO2zRHK mDD/6-33:[dps  ZY 1?1VWB?[n@ ! jQJ6ˆ7b5υ#DxIQkkٰZr}W3PEbtˤx=vVxp$bVx㴐u:I<κȺ r_kHP#W5ru:I0,\`j^DD]a2ȸށUD(if2G!2jZLB^}̡VﻟTyp;ﻟTyp;ﻟTyp;8Jw5\xԸˠW:D`ha3ݎ<-?# wѪ?hf@'i5/*>,Bdo RɃnO-w'd]kFY]uem d|X1kv,_ꀗ]s )gAVZ;q 5"]bhPˬ̉C2WV^nv1z*p+> Gݨ?X`よ;SɃSUEf"ZE"?JV Vd!L#bܓ_ \5_4h'W> C';5ɡ)7>5`͢fx|c}KD{o;]ĥ%6xM@9pNCQzopOaZdI 5hV[AMmq !HcÒF4i Xxo\ZGA>!pn$\OO5Y-rȟ _gB'F7#1't+ jZJ s^qM6G˴AW&yzAŠcj3{Y*P`3׏ߡ eo:f(}7"EF$5$e!Cҍ ̛!y#.tHp׏ߡ eo:f(})Eqw ׏ߡ eo:f(}G==IYb7ehDve%]^~U[yt(cL~;85-Gk Z7=9gObO4yo!6߿}o?" SVJf4]Es>үPb uUw/o T,)b yڻJz,$'c+6SN(T,#LWkV(g?)ړHq:%؃Gv㕢ƯkY[qm^%6jUG3Bhr fZǓ0[ ׊ae6 9jrRSsZ(kDN~ cd8*m }/;Mk+hE>Bm>`%fRnV;DhLԮ3}tqXj*oxJݺSwوxxbZÙP1Tqknݡ3/?vl f298n Г.\0[wSUzZ ,@P-6&~颺L֖}JWw`\8;\e=̴睠4.t+[9" S>HA kA𴏂An*v,p4x"~[[UPu㞿.ױ X\B2|h*gS Qdp(a"C bco{+OmYFDv1"QaGI FTC7!~1@h%&uA(_#lNkq6 -Ē K};muar.)n3[k^t 탚ZitD7U{˾8[O}~ptf?n FQh(F.tE׌= AeLM <>~Pa:D{hW9= AeLM <>~Pat5~VڻSsGtRh岞L2C?'vVDu7M!,_ Vd6]WuI C4rCEsj$[3 ePԝٗDZM&d!>79LޢuRb-SU˩\'Ego=ޡU\Q 7) Poz=҃O1C*=2x3_?CrWGϝ!̒]`f5 (~o{FN S(!q=ԓfuC;EE5L( V;ǗdqI*i{+3Y;ؿd!dqy~! Df #v!A alert('Sorry! this book is not available')"; } echo ""; } if(isset($_POST['find'])){ $keyword= $_POST['keyword']; $membershipID= $_POST['membershipID']; $library= $_POST['library']; $searchType= $_POST['searchType']; } echo "
"; echo "
"; echo ""; echo ""; echo "
"; echo ""; echo " "; echo " "; echo "
"; echo "
"; if(isset($_GET['selectbookID'])){ $membershipID = $_GET['membershipID']; $bookID = $_GET['selectbookID']; $query="select * from bookTable where bookID2='$bookID' "; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur )) { $bookName= odbc_result( $cur, 'bookName' ); $accessionNo= round(odbc_result( $cur, 'accessionNo' )); } } $empName=getName($conn,"select stdName from student where ID='$membershipID' "); echo "
"; echo ""; echo ""; echo "
Name"; echo "
Issue Date"; echo "
Return Date"; //echo "
Obtained Marks"; echo "
Accession NO"; echo "
Book Name/Title"; echo "
Description"; echo "
"; echo "
"; //echo ""; if($keyword!=""){ if($searchType!="") $query= "select * from bookTable where library='$library' and $searchType like'%$keyword%' order by accessionNo asc"; else $query= "select * from bookTable where library='$library' and (bookName like'%$keyword%' or author like'%$keyword%' or accessionNo like'%$keyword%') order by accessionNo asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialAcc #BookAuthorPublisherPlaceEditionselectImage"; $bookName= odbc_result( $cur, 'bookName' ); $bookID= odbc_result( $cur, 'bookID2' ); $edition= odbc_result( $cur, 'edition' ); $author= odbc_result( $cur, 'author' ); $accessionNo= round(odbc_result( $cur, 'accessionNo' )); $publisher= odbc_result( $cur,'publisher'); $publicationPlace= odbc_result( $cur,'publicationPlace'); $isbn= odbc_result( $cur,'isbn'); if(odbc_result( $cur,'status')==0) echo "
$cnt$accessionNo$bookName$author$publisher$publicationPlace$editionselect" ; else echo "
$cnt$accessionNo$bookName$author$publisher$publicationPlace$editionNot Available" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; } /* drop VIEW dbo.bookInOutView CREATE VIEW dbo.bookInOutView AS SELECT dbo.bookInOut.membershipID, dbo.bookInOut.doi, dbo.bookInOut.dor, dbo.student.stdName, dbo.student.fname, dbo.student.contacts, dbo.student.address, dbo.student.gender, dbo.student.email, dbo.student.nic, dbo.bookTable.bookName, dbo.bookInOut.bookID, dbo.bookTable.author, dbo.bookTable.qty, dbo.bookTable.isbn, dbo.bookTable.edition, dbo.bookTable.publisher, dbo.bookTable.publicationPlace, dbo.bookTable.publicationDate, dbo.bookTable.date_, dbo.bookTable.subTitle, dbo.bookTable.subAuthor, dbo.bookTable.pages, dbo.bookTable.year_, dbo.bookTable.volume, dbo.bookTable.ddc_no, dbo.bookTable.auth_mark, dbo.bookTable.remarks, dbo.bookTable.[language], dbo.bookTable.keywords, dbo.bookTable.subject, dbo.bookTable.library, dbo.bookTable.accessionNo, dbo.bookInOut.returnDate FROM dbo.bookInOut INNER JOIN dbo.student ON dbo.bookInOut.membershipID = dbo.student.membershipID INNER JOIN dbo.bookTable ON dbo.bookInOut.bookID = dbo.bookTable.bookID2 */ ?>
Issued Books Detail

#Acc#Book NameIssue DateDate ReturedReturnStatusImage"; $bookName= odbc_result( $cur, 'bookName' ); $accessionNo= round(odbc_result( $cur, 'accessionNo' )); $bookID= round(odbc_result( $cur, 'bookID' )); //$description= round(odbc_result( $cur, 'description' )); $doi = date('d-m-Y',strtotime( odbc_result( $cur, 'doi' ))); $doi2 = date('Y-m-d',strtotime( odbc_result( $cur, 'doi' ))); $dor = date('d-m-Y',strtotime( odbc_result( $cur, 'dor' ))); $dor2 = date('d-m-Y',strtotime( odbc_result( $cur, 'returnDate' ))); if(is_null(odbc_result($cur, 'returnDate') )) $dor2 =""; echo "
". $cnt++ . "$accessionNo$bookName$doi$dor2return"; echo ""; if(odbc_result($cur,'returnDate')!="") echo "Returned"; else echo "$status"; //echo ""; echo "Photo"; } echo "
"; ?>