translatorscanprogram/代码 5-22.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
<?php include "shared/head.php"; ?>
<table width="100%" border="1">
  <tbody>
    <tr>
      <td width="10%">
        <p><strong>序号</strong></p>
      </td>
      <td width="35%">
        <p><strong>中文</strong></p>
      </td>
      <td width="35%">
        <p><strong>英文</strong></p>
      </td>
      <td width="10%">
        <p><strong>删除</strong></p>
      </td>
      <td width="10%">
        <p><strong>编辑</strong></p>
      </td>
    </tr>
<?php include "shared/conn.php"; ?>
<?php
    mysqli_select_db( $conn,"myterm" );
    $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='10%'>
						<p>{$row["ID"]}</p>
						</td>
						<td width='35%'>
						<p>{$row["zh_CN"]}</p>
						</td>
						<td width='35%'>
						<p>{$row["en_US"]}</p>
						</td>
						<td width='10%'>
						<p><a href='delete.php?tid={$row['ID']}'>删除</a></p>
						</td>
					</tr>";
            }
        }
    mysqli_close($conn);
?>
  </tbody>
</table>
<?php include "shared/foot.php"; ?>