"); } function lib2() { error_reporting(0); $lim = 20; $title =$_POST['title']; $ntitle =$title; $enc = mb_detect_encoding($title); if($enc != 'SJIS') { $title = mb_convert_encoding($title, 'EUC-JP', $enc); } $auth =$_POST['auth']; $nauth =$auth; $enc = mb_detect_encoding($auth); if($enc != 'SJIS') { $auth = mb_convert_encoding($auth, 'EUC-JP', $enc); } $y =$_POST['y']; $ny =$y; $journal =$_POST['journal']; $njournal =$journal; $enc = mb_detect_encoding($journal); if($enc != 'SJIS') { $journal = mb_convert_encoding($journal, 'EUC-JP', $enc); } $pub1 =$_POST['pub1']; $npub1 =$pub1; $enc = mb_detect_encoding($pub1); if($enc != 'SJIS') { $pub1 = mb_convert_encoding($pub1, 'EUC-JP', $enc); } $kind =$_POST['kind']; $nkind =$kind; $enc = mb_detect_encoding($kind); if($enc != 'SJIS') { $kind = mb_convert_encoding($kind, 'EUC-JP', $enc); } $op =$_POST['op']; $p=$_POST['p']; $sv = 'localhost'; $dbname = 'lib'; $user = 'geolib'; mb_language("uni"); mb_internal_encoding("utf-8"); //内部文字コードを変更 mb_http_input("auto"); mb_http_output("ujis"); $conn = mysql_connect($sv, $user) or die('接続エラー'); mysql_query("SET NAMES ujis",$conn); //クエリの文字コードを設定 mysql_select_db($dbname) or die('接続エラー'); $result = mysql_query('select * from ref'); $allrows = mysql_num_rows($result); if ($title=='' && $auth=='' && $y=='' && $journal=='' && $pub1=='' && $kind==''){ $ans=' 検索項目を入力して下さい

Back

'; } else{ if ($auth==''){ $auth='%';} if ($title==''){ $title='%';} if ($journal==''){ $jurnal='%';} if ($pub1==''){ $pub1='%';} if ($kind==''){ $kind='%';} if ($op=='e'){ $comp='=';} if ($op=='b'){ $comp='<=';} if ($op=='a'){ $comp='>=';} if ($op=='n'){ $comp='!=';} if ($y==''){$y=strftime('%Y')+1; $comp='<';} $result2 = mysql_query("select * from ref where title like '%$title%' and kind like '%$kind%' and auth like '%$auth%' and journal like '%$journal%' and pub1 like '%$pub1%' and y $comp '$y' "); $rows2 = mysql_num_rows($result2); $ans='該当件数は'.$rows2.'件'; if ($p<1) {$p=1;} $st=($p-1)*$lim; $prev=$p-1; if ($prev<1) {$prev=1;} $next=$p+1; if ($p>1){ $pre="

"; $pre .= ""; $pre .= ""; $pre .= ""; $pre .= ""; $pre .= ""; $pre .= ""; $pre .= ""; $pre .= ""; $pre .= ""; $pre .= ""; $pre .= "

"; } else {$pre='　';} if (($next-1)*$lim < $rows2){ $fwd= "

"; $fwd .= ""; $fwd .= ""; $fwd .= ""; $fwd .= ""; $fwd .= ""; $fwd .= ""; $fwd .= ""; $fwd .= ""; $fwd .= ""; $fwd .= ""; $fwd .= "

"; } else {$fwd = '　';} $result3 = mysql_query("select * from ref where title like '%$title%' and kind like '%$kind%' and auth like '%$auth%' and journal like '%$journal%' and pub1 like '%$pub1%' and y $comp '$y' ORDER BY y desc LIMIT $st, $lim; "); while ($rr = mysql_fetch_array ($result3, MYSQL_ASSOC)){ $rTitle = $rr['title']; $rAuthor = $rr['auth']; $rY = $rr['y']; $rJournal = $rr['journal']; $rVol = $rr['vol']; $rPage = $rr['page']; $rPub1 = $rr['pub1']; $rPub2 = $rr['pub2']; $rKind = $rr['kind']; $rMemo = $rr['memo']; $rID = $rr['ID']; $ans .= "

".$rAuthor." (".$rY."): ".$rTitle." ". $rJournal.", ".$rVol.", ".$rPage.". (".$rKind.")

"; } $ans .= "

".$pre."

".$fwd."

"; mysql_close($conn); } return("