我有這兩個 while 回圈。
環形。左側螢屏。顯示附加到任務的用戶。
$getcurrentusers = $conn->prepare("SELECT u.userid, u.username, u.Fname, u.inactive, r.userid, r.job_id FROM users AS u INNER JOIN job_responsible AS r ON u.userid = r.userid WHERE u.inactive = 0 AND r.job_id = $getPostID ORDER BY u.Fname"); $getcurrentusers->execute(); $resultgetcurrentusers = $getcurrentusers->get_result(); $getcurrentusers->close(); if ($resultgetcurrentusers->num_rows > 0) { while($row = $resultgetcurrentusers->fetch_assoc()) { echo $row["username"]." (".$row["Fname"].")<br />"; } } else { echo "Der er ikke valgt nogle ansvarlige til denne opgave."; }環形。右側螢屏。列出可以添加到任務的所有可能用戶
$getdepartmentview = $SetDepartmentView; $explodegetdepartmentview = explode(",",$getdepartmentview); $implodegetdepartmentview = "'".implode("','",$explodegetdepartmentview)."'"; $getusers = $conn->prepare("SELECT userid, username, Fname, inactive FROM users WHERE departmentid IN ($implodegetdepartmentview) AND inactive = 0 ORDER BY Fname"); $getusers->execute(); $resultgetusers = $getusers->get_result(); $getusers->close(); if ($resultgetusers->num_rows > 0) { while($row = $resultgetusers->fetch_assoc()) { echo "<input type=\"checkbox\" name=\"choose_responsible[]\" value=\"".$row["userid"].",\" />".$row["Fname"]."<br />"; } }
問題是，我真的很想，當左側有匹配項時，輸入復選框在右側被“選中” 1. 回圈。
所以..
Loop 1 | Loop 2
name3 | name1
name5 | name2
name7 | name3 - Inputbox checked
name8 | name4
| name5 - Inputbox checked
| name6
| name7 - Inputbox checked
| name8 - Inputbox checked
| name9
| name10
uj5u.com熱心網友回復：
在第一個回圈中，您可以將 user_id 存盤在陣列中
$user_ids[] = $row["userid"]
在第二個回圈中，您檢查當前用戶 id 是否存在于先前保存的 $user_ids 陣列中
$checked = false;
if (in_array($row["userid"], $user_ids)) {
$checked = true;
}
uj5u.com熱心網友回復：
此任務要求在單個查詢中進行 LEFT JOIN，以避免多次訪問資料庫并避免結果集上的低效 php 行程。
$sql = <<<SQL
SELECT u.userid,
u.username,
u.Fname,
u.inactive,
r.userid responsibleUserId,
r.job_id
FROM users AS u
LEFT JOIN job_responsible AS r
ON u.userid = r.userid
AND r.job = ?
WHERE u.inactive = 0
ORDER BY u.Fname
SQL;
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $getPostID);
$result = $stmt->execute();
$users = $result->fetch_all(MYSQLI_ASSOC);
現在您擁有所需的所有資料，因此沒有更多理由訪問資料庫。
要列出分配給目標作業的用戶，請迭代關聯陣列的陣列并顯示job_id不為空的用戶。
foreach ($users as $user) {
if ($user['job_id']) {
printf('%s (%s)<br />', $user['username'], $user['Fname']);
}
}
要顯示所有用戶并有條件地檢查已經“負責”的名稱旁邊的復選框，請再次迭代陣列并依靠job_id來確定復選框。
foreach ($users as $user) {
printf(
'<input type="checkbox" name="choose_responsible[]" value="%d"%s/>%s<br />',
$user['userid'],
$user['job_id'] ? ' checked' : '',
$user['Fname']
);
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/439345.html