sqlks/listtrans.php at master · nikissXI/sqlks · 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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<html>
<? session_start();
header("Content-Type: text/html; charset=gb2312"); ?>

<head>
    <title>转岗信息</title>
    <link href="menu.css" type="text/css" rel="stylesheet" />
</head>
<h2 align="center" style="color:rgb(158, 216, 216);">转岗信息</h2>

<?
require("warn.php");
require("sql.php");
$sql = "select * from listtrans order by 员工编号";
$sql2 = " where ";

if (isset($_GET['kw'])) {
    $sql = $sql . " where " . $_GET['kw'] . " order by 员工编号";
}
@$result = odbc_exec($conn, $sql);
if (!$result) {
    if (odbc_errormsg($conn) != "[Microsoft][ODBC SQL Server Driver][SQL Server]“where”附近有语法错误。") {
?>
        <B>
            <p style="text-align:center;color:red"><?= odbc_errormsg($conn) ?></p>
        </B>
<? }
    $sql = "select * from listtrans order by 员工编号";
    $result = odbc_exec($conn, $sql);
}
?>

<form action="listtrans.php" method="get">
    <p align="center" class="where">条件过滤(SQL语句): WHERE
        <input name="kw" type="text" size="100" />
        <input type="submit" name="submit" class="sm" value="提交" /></p>
</form>

<!-- 员工编号,员工姓名,转岗日期,转岗原因,新部门,新岗位,旧部门,旧岗位 -->
<table border="3" align="center" cellpadding="2">
    <tr align="center">
        <td>员工编号</td>
        <td width="80">员工姓名</td>
        <td width="80">转岗日期</td>
        <td width="80">转岗原因</td>
        <td width="80">新部门</td>
        <td width="80">新岗位</td>
        <td width="80">旧部门</td>
        <td width="80">旧岗位</td>
    </tr>
    <?
    while ($row = odbc_fetch_array($result)) { ?>
        <tr align="center">
            <td><?= $row['员工编号'] ?></td>
            <td><?= $row['员工姓名'] ?></td>
            <td><?= $row['转岗日期'] ?></td>
            <td><?= $row['转岗原因'] ?></td>
            <td><?= $row['新部门'] ?></td>
            <td><?= $row['新岗位'] ?></td>
            <td><?= $row['旧部门'] ?></td>
            <td><?= $row['旧岗位'] ?></td>
        </tr>
    <? } ?>
</table>

<br />
<table align="center">
    <tr>
        <td><a href="menu.php" style="color:white">返回主菜单</a></td>
    </tr>
</table>

</html>