欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

《php---mysql简单应用---在线词典》_PHP教程

程序员文章站 2022-05-16 15:23:46
...
[html]




Insert title here



请输入您要查找的英文单词:











Insert title here



请输入您要查找的英文单词:







[php] view plaincopyprint?

class 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'];
}
}

}

class 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."
";
}else{
echo "未查询到结果!
";
}
}else{
echo "未获取任何输入!
";
}
echo "点击返回
";

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."
";
}else{
echo "未查询到结果!
";
}
}else{
echo "未获取任何输入!
";
}
echo "点击返回
";

《php---mysql简单应用---在线词典》_PHP教程

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/477931.htmlTechArticle[html] !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 titl...