我有一些記錄,我想按日期排序,然后按服務(wù)器端或客戶端的用戶排序。這是我的代碼。 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; } } } }任何解決方案表示贊賞!
從數(shù)據(jù)庫中獲取數(shù)據(jù)并按日期排序,然后按用戶在 HTML 表中排序
慕無忌1623718
2021-11-26 15:33:23