feebee-intern/edit_record.php at master · eoleedi/feebee-intern · 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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
<?php
    session_start();
    if ($_SESSION["account"] != TRUE){
        header("location:index.php");
    }
?>
<!doctype html>
<html>

    <head>
        <meta charset="UTF-8">
        <title>記錄</title>
        <link rel=stylesheet type="text/css" href="bootstrap.css">
        <link rel=stylesheet type="text/css" href="css.css?v=1323">
    </head>

    <body>

        <nav class="navbar navbar-expand-sm navbar-dark">
            <a class="navbar-brand" href="派發系統.php">派發系統</a>

            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>

            <div class="collapse navbar-collapse" id="navbarSupportedContent">
                <ul class="navbar-nav mr-auto">
                    <li class="nav-item">
                        <a class="nav-link" href="edit_record.php">記錄</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="search.php">搜尋</a>
                    </li>
                </ul>
                <ul class="navbar-nav">
                    <li class="nav-item">
                        <h4><a class="nav-link" href="#"><?php
                            echo $_SESSION['account'];
                        ?></a></h4>
                    </li>
                </ul>
                <form class="form-inline my-2 my-lg-0" action="logOut.php">
                    <button class="btn btn-outline-success my-2 my-sm-0" type="submit" name="user_id">登出</button>
                </form>
            </div>
        </nav>

        <br>

        <div>
            <h3 align="center">編輯記錄</h3>
            <br>
            <div style="background-color:white" align="center">
                <form method="post">
                    <div style="width: 630px;">
                        <div class="form-group row">
                            <button id="search_btn" class="btn btn-outline-info my-2 my-sm-0" type="submit" name="search_btn" value="1">搜尋</button>
                            <div class="col-sm-10">
                                <input type="test" class="form-control" id="search_user" placeholder="搜尋使用者" name="search_user" value="ALL">
                            </div>
                        </div>
                    </div>
                </form>
            </div>

            <br>

            <table class="table">
                <thead class="thead-light">
                    <tr>
                        <th scope="col" class="sbs_user">編輯者</th>
                        <th scope="col" class="sbs_title">關鍵字</th>
                        <th scope="col" class="sbs_cat">類別</th>
                        <th scope="col" class="sbs_time">編輯時間</th>
                    </tr>
                </thead>
                <tbody>
                    <?php

                        $search_user = 0;

                        if(isset($_POST['search_btn'])){
                            $search_user = $_POST['search_user'];
                            if($search_user == 'all' or $search_user == 'ALL' or $search_user == 'All'){
                                $link = mysqli_connect(
                                    'localhost',
                                    'root',
                                    'root',
                                    'sbs_distribution'
                                );


                                $sql = "SELECT * FROM product WHERE product_status = 2 ORDER BY product_edit_time DESC;";
                                $result = mysqli_query($link, $sql);
                                $data = mysqli_fetch_all($result);

                                for($i=0; $i < count($data); $i++){
                                    echo'<tr id='.'tr_id_'.$i.'>
                                            <th scope="col">'.$data[$i][3].'</th>
                                            <th scope="col">'.$data[$i][0].'</th>
                                            <th scope="col">'.$data[$i][1].'</th>
                                            <th scope="col">'.date("Y-m-d H:i:s", strtotime($data[$i][4])).'</th>
                                    </tr>';
                                }

                                mysqli_close($link);
                            }
                            else{
                                $link = mysqli_connect(
                                    'localhost',
                                    'root',
                                    'root',
                                    'sbs_distribution'
                                );


                                $sql = "SELECT * FROM product WHERE product_status = 2 AND product_editor LIKE \"$search_user"."%"."\" ORDER BY product_edit_time DESC";
                                $result = mysqli_query($link, $sql);
                                $data = mysqli_fetch_all($result);

                                for($i=0; $i < count($data); $i++){
                                    echo'<tr id='.'tr_id_'.$i.'>
                                            <th scope="col">'.$data[$i][3].'</th>
                                            <th scope="col">'.$data[$i][0].'</th>
                                            <th scope="col">'.$data[$i][1].'</th>
                                            <th scope="col">'.date("Y-m-d H:i:s", strtotime($data[$i][4])).'</th>
                                    </tr>';
                                }

                                mysqli_close($link);
                            }
                        }

                    ?>
                </tbody>
            </table>

        </div>

        <!--Script區-->
        <script src="https://code.jquery.com/jquery-3.5.1.js" integrity="sha256-QWo7LDvxbWT2tbbQ97B53yJnYU3WhH/C8ycbRAkjPDc=" crossorigin="anonymous"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.6/umd/popper.min.js" integrity="sha384-wHAiFfRlMFy6i5SRaxvfOCifBUQy1xHdJ/yoi7FRNXMRBu5WHdZYu1hA6ZOblgut" crossorigin="anonymous"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/js/bootstrap.min.js" integrity="sha384-B0UglyR+jN6CkvvICOB2joaf5I4l3gm9GU6Hc1og6Ls7i6U/mkkaduKaBhlAXv9k" crossorigin="anonymous"></script>
        <script type="text/javascript" src="js.js?v=114" charset="UTF-8"></script>
    </body>

</html>