《php---mysql简单应用---在线词典》
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body><form action="search.php" method="post">请输入您要查找的英文单词：<br/><input type="text" name="enword"/><br/><input type="submit" value="提交"/><br/></form></body></html>
<?phpclass DicTool{private $conn;private $host = "localhost";private $user = "root";private $password = "123";private $db = "test";//构造函数，初始化数据，连接数据库function __construct(){$this->conn = mysql_connect($this->host, $this->user, $this->password);if (!$this->conn){die("连接数据库失败".mysql_error());}//选择数据库mysql_select_db($this->db,$this->conn);mysql_query("set names utf8");}function findchword($enword){$sql = "select * from words where enword ='".$enword."'limit 0,10";$res = mysql_query($sql,$this->conn) or die(mysql_error());if (!$res){return 0;//失败}else{$row = mysql_fetch_assoc($res);return $row['chword'];}}}<?php header("Content-Type: text/html; charset=UTF-8");include_once 'DicTool.class.php';$dicTool = new DicTool();if (isset($_POST['enword'])){$chword = $dicTool->findchword($_POST['enword']);if ($chword){echo $_POST['enword']."对应的中文意思是：".$chword."<br/>";}else{echo "未查询到结果！<br/>";}}else{echo "未获取任何输入！<br/>";}echo "<a href='find.html'>点击返回<a/><br/>";