2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhoXy[>v9SK`f2 <&+ It*_wr$a*$ZJEdϢ* ^Cbl9)[njT"TaG[*&vH)Yzf mnyk,+=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>BmBy|.uv~.>_tV;ǔ(t˶a46#Ț*{KC+9V"ԲN8‚(EQwv~6*`eeuSD6u<[؉yr..-6&~颺L֖}JWw`\8;\Z^8_da^80J%S⇊V O>) "G z0{`5t8)k(eZACqtw2iqЂSt6;ՇԧU~*u,ݏ ;o -{\Oq{TtVGBweJj[Gt:'q>5fLFpVVXЖ3JOn5R8~;u na >3kFюVbrmHF}Q4 +M)Hz(_ =Qݕh.46p\0#+'ݕh.46ykGyZPG$ݕh.46Z|: hrm;tJ{3 xy_C5M\;l򛖒ЄDDuh ē¾W" R'['ڡo,. t`܄v򣻯s4g& YaUĕ4ɨz jۑaf=pj],"0K.4P/-an+4(3H2d|$.F/.Cza+b@PU2C7Ma&YO*< ׀«Mҍ]w:*$QnU;d%:#؂ϭ&W;s0 j9Ƀ=K䘪T;*(Ǹ%!I%G5ZU,#O/.9M%z&cp"d5 . +]dY]q.P.멞l.&U"ˇѝtͺܪ„\(Lrj/$ $&$Mlx+lbpm.{U]KJ! ON t0_(jx U2p4+>MĪ2VRa(c?H%VF:^nE|ԫrmxӅ%48d@CpK^paZ{PBpLfvھ["_+Ҭ% *OX0c!nEU3qo@Zf ?`Ǐ8)2pR&:Ug69}1w'j.A6LIywO&h" =tпkZ  0c!nEUQ(h2fA fLyN㍲,^8;SDP۽Ϡ vKhHgc7pf<cfαֆk=~0-5kAq[S[a$FM[)&-PEry$8v/ [ʍng[tؚa*nB"q4󔖸B84;|@2oj==ņ93(@=dH |·4h) MHNѧmZlIཱི7.MM >qYd ,'N.wO-V|t06'ӆCҢB̦RS AId$vpWM`L{:MZs.;#LgdQlN5oyޗ NlIpz}t|[µa$}@`Zg¥%i/( H߽Vˈ9jBl8P8`7:۷aW&dHQa[9jrRSsKuS~xD0::l]ē¾W" R'M8@g C+looE?߮]őmh%8kP-C|vGʔhB99\ ԞM0"W]`G?/fQͅ\t"xԾJ5\W΄׭>g]V=8ֿAuM A"4p&F,6*;f,{FMlx+lbpm k1\Ѡ{x 5pI+kHřd~ֺe9,_rƹ&+-Zh0v4y3!jٟY|f*E^q?I;Kէ{>=Ęq Cf<1xt !#=Dt4*YnC) *&..mJG[v#ج:lk8+Wz74?#B\㻾U/sM4f=k4 *ݮ[adeT2~G䆴 OzIz-InCRZ}ᶮK"V׵~|K_H8i9z!%*>z?1ޒ %Gm"@)@l >3(Ռm%Y9P۟ tEPp A* Vt, jr%GfEe*׻Od: c._87rwk("zb 4rp&p܆G|D+4M:Q>9- Đ VQH;(#@Xt(`$wE/}@C;`[^قt!pj6jtMselected>B-Pharmacy"; else echo ""; if($library=="3") echo ""; else echo ""; if($library=="4") echo ""; else 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 name from student where membershipID='$membershipID' "); echo "
"; echo ""; echo ""; echo "
Name"; echo "
Issue Date"; echo "
Return Date"; //echo "
Obtained Marks"; echo "
Accession NO"; echo "
Title"; 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"; } $query="select * from bookInOutView where membershipID='$membershipID' order by doi desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialAccession#Book NameIssue DateReturn DateDate ReturedReturnDeleteStatus"; $bookName= odbc_result( $cur, 'bookName' ); $accessionNo= round(odbc_result( $cur, 'accessionNo' )); $bookID= round(odbc_result( $cur, 'bookID' )); //$status= odbc_result( $cur, 'status' ); $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$dor$dor2returnDelete$status" ; } echo "
"; odbc_close($conn); /* drop VIEW dbo.bookInOutView CREATE VIEW dbo.bookInOutView AS SELECT dbo.bookInOut.membershipID, dbo.bookInOut.doi, dbo.bookInOut.dor, dbo.student.Name, dbo.student.fname, dbo.student.ResPhone, dbo.student.PreAddress, dbo.student.genderID, 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 */ ?>