translatorscanprogram/代码 4-46.php at master · zenglz-lang/translatorscanprogram · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<?php include "shared/head.php"; ?>

<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 include "shared/conn.php"; ?>

<?php
    mysqli_select_db( $conn,"stiterm" );
    $query =$_POST["query"];
    $sql = "SELECT ID, zh_CN, en_US FROM termdata WHERE zh_CN LIKE '%$query%' or en_US LIKE '%$query%'";
    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%'>
                        <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>
<?php include "shared/foot.php"; ?>