通知设置 新通知
代码 4-42 用于代码共享的“head.php”代码
韩林涛 发表了文章 • 0 个评论 • 874 次浏览 • 2020-07-06 15:09
head.php
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>STITERM</title>
</head>
<body>
代码 4-38 用于高亮显示查询结果的“result.php” 代码
韩林涛 发表了文章 • 0 个评论 • 1018 次浏览 • 2020-07-06 15:07
result.php
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>STITERM</title>
</head>
<body>
<table width="89%" border="1">
<tbody>
<tr>
<td width="21%">
<strong>序号</strong>
</td>
<td width="31%">
<strong>中文</strong>
</td>
<td width="46%">
<strong>英文</strong>
</td>
</tr>
<?php
$dbhost = "localhost"; //数据库所在主机地址
$dbuser = "root"; //登录数据库所用的用户名
$dbpass = ""; //登录数据库所用的用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(!$conn )
{
die("无法连接服务器,错误代码为: " . mysqli_connect_error());
}
// else
// {
// echo "服务器连接成功!";
// }
mysqli_select_db( $conn,"stiterm" );
$query =$_POST["query"];
$sql = "SELECT ID, zh_CN, en_US FROM termdata";
mysqli_query($conn,"set names 'utf8'");
$getterm = mysqli_query($conn,$sql);
if(! $getterm )
{
echo "无法获取术语数据,请检查问题";
}
else
{
while ($row = mysqli_fetch_array($getterm, MYSQLI_ASSOC))
{
$row['zh_CN']=preg_replace("/$query/i", "<font color=red><b>$query</b></font>",$row['zh_CN']);
$row['en_US']=preg_replace("/$query/i", "<font color=red><b>$query</b></font>",$row['en_US']);
echo "<tr>
<td width='21%'>
{$row["ID"]}
</td>
<td width='31%'>
{$row["zh_CN"]}
</td>
<td width='46%'>
{$row["en_US"]}
</td>
</tr>";
}
}
mysqli_close($conn);
?>
</tbody>
</table>
</body>
</html>
代码 4-36 用于执行SQL查询语句的代码
韩林涛 发表了文章 • 0 个评论 • 1053 次浏览 • 2020-07-06 11:51
result.php
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>STITERM</title>
</head>
<body>
<table width="89%" border="1">
<tbody>
<tr>
<td width="21%">
<strong>序号</strong>
</td>
<td width="31%">
<strong>中文</strong>
</td>
<td width="46%">
<strong>英文</strong>
</td>
</tr>
<?php
$dbhost = "localhost"; //数据库所在主机地址
$dbuser = "root"; //登录数据库所用的用户名
$dbpass = ""; //登录数据库所用的用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(!$conn )
{
die("无法连接服务器,错误代码为: " . mysqli_connect_error());
}
// else
// {
// echo "服务器连接成功!";
// }
mysqli_select_db( $conn,"stiterm" );
$sql = "SELECT zh_CN, en_US FROM termdata";
mysqli_query($conn,"set names 'utf8'");
$getterm = mysqli_query($conn,$sql);
if(! $getterm )
{
echo "无法获取术语数据,请检查问题";
}
else
{
while ($row = mysqli_fetch_array($getterm, MYSQLI_ASSOC))
{
echo "<tr>
<td width='21%'>
{$row["ID"]}
</td>
<td width='31%'>
{$row["zh_CN"]}
</td>
<td width='46%'>
{$row["en_US"]}
</td>
</tr>";
}
}
mysqli_close($conn);
?>
</tbody>
</table>
</body>
</html>
代码 4-35 添加代码用于创建搜索框
韩林涛 发表了文章 • 0 个评论 • 793 次浏览 • 2020-06-02 15:10
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>STITERM</title>
</head>
<body>
<form action="result.php" method="POST">
<table>
<tr>
<td>
<input type="text" name="query" placeholder="请输入检索词" >
</td>
<td>
<button type="submit">搜索</button>
</td>
</tr>
</table>
</form>
</body>
</html>
代码 4-34 添加代码用于以表格形式呈现术语表
韩林涛 发表了文章 • 0 个评论 • 836 次浏览 • 2020-06-02 15:08
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>STITERM</title>
</head>
<body>
<table width="89%" border="1">
<tbody>
<tr>
<td width="21%">
<p><strong>序号</strong></p>
</td>
<td width="31%">
<p><strong>中文</strong></p>
</td>
<td width="46%">
<p><strong>英文</strong></p>
</td>
</tr>
<?php
$dbhost = "localhost"; //数据库所在主机地址
$dbuser = "root"; //登录数据库所用的用户名
$dbpass = ""; //登录数据库所用的用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(!$conn )
{
die("无法连接服务器,错误代码为: " . mysqli_connect_error());
}
// else
// {
// echo "服务器连接成功!";
// }
mysqli_select_db( $conn,"stiterm" );
$sql = "SELECT ID, zh_CN, en_US FROM termdata";
mysqli_query($conn,"set names 'utf8'");
$getterm = mysqli_query($conn,$sql);
if(! $getterm )
{
echo "无法获取术语数据,请检查问题";
}
else
{
while ($row = mysqli_fetch_array($getterm, MYSQLI_ASSOC))
{
echo "<tr>
<td width='21%'>
<p>{$row["ID"]}</p>
</td>
<td width='31%'>
<p>{$row["zh_CN"]}</p>
</td>
<td width='46%'>
<p>{$row["en_US"]}</p>
</td>
</tr>";
}
}
mysqli_close($conn);
?>
</tbody>
</table>
</body>
</html>
代码 4-32 获取键值
韩林涛 发表了文章 • 0 个评论 • 747 次浏览 • 2020-06-02 15:05
<?php
$servant_cat = array("luning"=>"naonao","baibai"=>"catti","liangshuang"=>"titi"); //$servant_cat为关联数组
$cat = array("naonao","catti","titi"); // $cat为索引数组
echo $servant_cat["baibai"];
echo $cat[1];
?
代码 4-30 查看关联数组键的值
韩林涛 发表了文章 • 0 个评论 • 633 次浏览 • 2020-06-02 15:04
<?php
$catofbaibai = $servant_cat["baibai"];
?>
代码 4-29 定义关联数组$servant_cat
韩林涛 发表了文章 • 0 个评论 • 653 次浏览 • 2020-06-02 15:02
<?php
$servant_cat = array("luning"=>"naonao","baibai"=>"catti","liangshuang"=>"titi");
?>
代码 4-28 定义索引数组$servant
韩林涛 发表了文章 • 0 个评论 • 671 次浏览 • 2020-06-02 15:01
<?php
$servant = array("luning","baibai","liangshuang");
?>
代码 4-27 定义索引数组$cat
韩林涛 发表了文章 • 0 个评论 • 637 次浏览 • 2020-06-02 14:59
<?php
$cat = array("naonao","catti","titi");
?>