bbsdict.php
来自「bbs server linux平台下软件源码」· PHP 代码 · 共 206 行
PHP
206 行
<?php require("funcs.php"); $hostname=bbs_sysconf_str("MYSQLHOST"); $username=bbs_sysconf_str("MYSQLUSER"); $password=bbs_sysconf_str("MYSQLPASSWORD"); $dbname=bbs_sysconf_str("MYSQLDATABASE"); if($loginok !=1) html_nologin(); else { //登陆成功 html_init("gb2312"); check_php_setting("magic_quotes_gpc", 0); //检查权限 if($currentuser["userlevel"]&BBS_PERM_BMAMANGER) $hasperm=true; else $hasperm=false;//转换单词属性function meaningofWord($arg){ for($i=0;$i<strlen($arg);$i++) { switch(ord($arg{$i})) { case 1: $meaning.="n.";break; case 2: $meaning.="v.";break; case 3: $meaning.="a.";break; case 4: $meaning.="ad.";break; case 5: $meaning.="vi.";break; case 6: $meaning.="vt.";break; case 8: $meaning.="vbl.";break; case 9: $meaning.="int.";break; case 10: $meaning.="art.";break; case 11: $meaning.="aux.";break; case 12: $meaning.="num.";break; case 13: $meaning.="conj.";break; case 14: $meaning.="prep.";break; case 15: $meaning.="pron.";break; case 16: $meaning.="st.";break; case 17: $meaning.="adj.";break; case 18: $meaning.="adv.";break; case 19: $meaning.="pr.";break; case 20: $meaning.="abbr.";break; case 21: break; case 22: break; case 25: break;//insound case 26: break; case 30: break; case 31: $i++; $i++; break; case 59: $meaning.="<br>"; break; default: $meaning.=$arg{$i}; } } return $meaning;} $db=mysql_connect($hostname,$username,$password) or die(mysql_error()); mysql_select_db($dbname,$db) or die(mysql_error()); if(isset($_GET["add"]) && $hasperm) { $word=addslashes(trim($_GET["word"])); if(strlen($word)>0) { if(ord($word{0})>128){ $tablename="cedict"; $dictname=addslashes($_GET["cedictname"]); }else{ $tablename="ecdict"; $dictname=addslashes($_GET["ecdictname"]); } //增加单词 if($_GET["cixing"]>0) { $meaning=chr(addslashes($_GET["cixing"])).addslashes($_GET["meaning"]); }else $meaning=addslashes($_GET["meaning"]); //检查是不是已经有了这个词条 $result=mysql_query("select * from ".$tablename." where word='".$word."' and dictid=$dictname") or die(mysql_error()); if($result_rows=mysql_fetch_array($result)) { $meaning=$result_rows["meaning"].chr(59).$meaning; $id=$result_rows["id"]; $result=mysql_query("update ".$tablename." set meaning='$meaning' where id=$id"); }else { $result=mysql_query("insert into ".$tablename." (word,meaning,dictid) values('$word','$meaning','$dictname')") or die(mysql_error()); } //add a new word; } } if($_GET["delete"]){ $id=addslashes($_GET["id"]); $mysql="delete from ".addslashes($_GET["tablename"])." where id=$id"; $result=mysql_query($mysql) or die(mysql_error()); } ?><body><center>辞典</center><hr><form action="<?php echo $_SERVER['PHP_SELF']?>">请输入:<input type=text name=inputword value="" size=24 maxlength=20><input type="submit" value="查询"></form><br><?php//显示查询的结果//显示查到的单词if(isset($_GET["inputword"])) { $inputword=addslashes(trim($_GET["inputword"])); if(ord($inputword{0})>128) $tablename="cedict"; else $tablename="ecdict"; $result=mysql_query("select * from ".$tablename." where word='".$inputword."'") or die(mysql_error()); echo "辞典:".$tablename."<br>"; echo "查询结果<br>"; echo trim($_GET["inputword"])."的意思<br>"; if(mysql_num_rows($result)==0) echo "没有这个词<br>"; while($result_rows=mysql_fetch_array($result)) { echo MeaningofWord($result_rows["meaning"]); $dictname=$tablename."name"; echo "<br />>>>>"; if($result_rows[3]>0) { $dictid=$result_rows[3]; $dict_result2=mysql_query("select * from ".$dictname." where id='$dictid'") or die(mysql_error()); $myrows=mysql_fetch_row($dict_result2); echo "(词典:".$myrows[1].")"; } else echo "默认词典"; if($hasperm) printf("<a href=\"%s?id=%d&tablename=%s&delete=yes\">(delete)</a><br>",$_SERVER['PHP_SELF'],$result_rows["id"],$tablename); } }?><p><?phpif($hasperm){?><form action="<?php echo $_SERVER['PHP_SELF']?>"><input type=hidden name=add value="yes">加入新词或修改:<input type=text name=word value="<?php echo $inputword;?>" size=24 maxlength=20>词性<select name="cixing"><option value=1>n.</option><option value=2>v.</option><option value=3>a.</option><option value=4>ad.</option><option value=5>vi.</option><option value=6>vt.</option><option value=8>vbl.</option><option value=9>int.</option><option value=10>art.</option><option value=11>aux.</option><option value=12>num.</option><option value=13>conj.</option><option value=14>prep.</option><option value=15>pron.</option><option value=16>st.</option><option value=17>adj.</option><option value=18>adv.</option><option value=19>pr.</option><option value=20>abbr.</option> <option value=0>词组</option></select><br>解释<input type name=meaning value="" size=24><br>中英词典<select name="cedictname"><option value=0>默认</option><?php$result=mysql_query("select * from cedictname") or die(mysql_error());while($myrows=mysql_fetch_array($result)){ echo "<option value=$myrows[0]>$myrows[1]</option>";} ?></select>英中词典<select name="ecdictname"><option value=0>default</option><?php$result=mysql_query("select * from ecdictname") or die(mysql_error());while($myrows=mysql_fetch_array($result)){ echo "<option value=$myrows[0]>$myrows[1]</option>";} ?></select><input type="submit" value="加入"></form><?php}//end of haspermhtml_normal_quit();}//end of 登陆?>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?