馆3:图书检索
1 編碼形式
UTF-8格式
tsg2b0.csv
圖書館2的0號(hào)書架
2 圖書檢索
s.php
<?php echo '圖書檢索系統(tǒng)'; echo '<br>';echo '<br>';$key = $_GET['key']; $lib= $_GET['lib']; $key1 = $_GET['key1'];if($lib==0) { $lib=2; } if(strlen($key)==0) { $key="小王子"; } if(strlen($key1)==0) { $key1="#"; }include "p/csv.php";echo '<form action="s.php" method="get">'; echo '關(guān)鍵字1: <input type=text name=key value="'.$key.'" οnchange=this.form.submit()>(書名、作者、出版社名、定位碼、編號(hào))<br>'; echo '關(guān)鍵字2: <input type=text name=key1 value="'.$key1.'" οnchange=this.form.submit()>(書名、作者、出版社名、定位碼、編號(hào))<br>'; echo '圖書館: <input type=text name=lib value='.$lib.' οnchange=this.form.submit()>(1桂花圖書館,2功偉書屋)<br>'; echo '<input type="submit"></form>';$lib_ =array(1 => "桂花圖書館",2=> "功偉書屋", );echo $lib_[$lib].'與 {'.$key.'} 相關(guān)的書籍如下:'; echo '<br>';$b_n = 0; for($y=0;$y<50;$y++) {$bb =$y ;$bfile="upload/tsg".$lib."b".$bb.".csv"; //echo '<br>$bfile<br>'; //echo $bfile;//var_dump($bfile); $data = csvread($bfile);//echo $data[0][1][1]; $r = $data['r']; //var_dump($data[0][3]); //echo $r;for($x=3;$x<$r;$x++) { $bloc = $data[0][$x][0]; $bid = $data[0][$x][1]; $bnm = $data[0][$x][3]; $anm = $data[0][$x][4]; $pnm = $data[0][$x][5]; if($lib==2){ //$finfo = $bloc.$bid.$bnm.$anm.$pnm; $finfo1 = '>'.$bloc.'>'.$bid.'>'.$bnm.'>'.$anm.'>'.$pnm; } else { //$finfo = $bloc.$bid.$bnm; $finfo1 = '>'.$bloc.'>'.$bid.'>'.$bnm;}if(stristr($finfo1,$key1) && stristr($finfo1,$key) && strlen($key)>0) { echo '<br>'; echo $finfo1; //echo $bfile; $b_n = $b_n+1; } } } echo '<hr>'; echo "總計(jì):".$b_n;?>csv.php
<?php//first row: $row = 0; first column: $col = 0 function csvwrite($file_name,$mstr,$row,$col) {$fp = fopen($file_name, 'r+');if ($fp) {$i = 1;while (!feof($fp)){if ($i == $row+1) {fseek($fp, $col, SEEK_CUR);fwrite($fp, $mstr);break;}fgets($fp);$i++;}fclose($fp);} }function csvread($file_name) {$row = 1; $data = array(); //define the main array.if (($handle = fopen($file_name, "r")) !== FALSE) {while (($line = fgetcsv($handle, 1000, ",")) !== FALSE) {$num = count($line);$row++;$data[] = $line; //add the row to the main array.}fclose($handle); }$r=sizeof($data); $c=sizeof($data[0]);$out=array(0=>$data,'r'=>$r,'c'=>$c,'nm'=>$file_name );return $out; }?>總結(jié)
- 上一篇: JAVA EE程序员必读书籍大全
- 下一篇: 数据生命周期管理