代码 4-38 用于高亮显示查询结果的“result.php” 代码
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>