从数据库中获取数据并按日期排序，然后按用户在 HTML 表中排序

Question

我有一些记录，我想按日期排序，然后按服务器端或客户端的用户排序。这是我的代码。    if (isset($_POST['work_report']) && $_POST['work_report'] == 'SAVE') {        $from_date = $_POST['from_date'];        $to_date   = $_POST['to_date'];        $users      = isset($_POST['users']) ? $_POST['users'] : array();        if (empty($users)) {            header("location: work_dairy_report");        } else {            $reports = array();            foreach ($users as $key => $user) {                if ($user == 0) {                    $work_report = "SELECT * FROM " . WORK_REPORT_TABLE . " WHERE work_date BETWEEN '$from_date' AND '$to_date'";                } else {                    $work_report = "SELECT * FROM " . WORK_REPORT_TABLE . " WHERE work_date BETWEEN '$from_date' AND '$to_date' AND staff_id = $user";                }                $result_work_report = $db->execute_query($work_report);                while ($report = mysqli_fetch_assoc($result_work_report)) {                    $reports[] = $report;                }            }        }    }任何解决方案表示赞赏！

Answer 1

看起来最简单的选择是添加ORDER BY work_date, staff_id到 SELECT 语句中，如下所示：

"SELECT * FROM " . WORK_REPORT_TABLE . " WHERE work_date BETWEEN '$from_date' AND '$to_date' ORDER BY work_date";

"SELECT * FROM " . WORK_REPORT_TABLE . " WHERE work_date BETWEEN '$from_date' AND '$to_date' AND staff_id = $user ORDER BY work_date, staff_id";

关于ORDER BY使用的更多信息在这里