我在 php 編碼方面遇到了一些問題。我想做的是：創(chuàng)建一個(gè)數(shù)組 ($rows) 并用 mysqli_query ($query1) 的結(jié)果填充它 --> OK對(duì)于該數(shù)組中的每個(gè)元素，將某個(gè)鍵 (pilot_rule_id) 的值替換為另一個(gè) mysqli_query ($query2) 的結(jié)果。（第二個(gè)查詢將返回一行，因?yàn)?Pilot 表的 id 是主鍵）。到目前為止我已經(jīng)$id = "96707ac6-ecae-11ea-878d-005056bbb446";$rows = array();$query1 = mysqli_query($con, "SELECT * FROM pilot_time_schedule WHERE pilot_id='$id'");while($r = mysqli_fetch_assoc($query1)) { $rows[] = $r;}foreach($rows as $pilotRuleId) { $pilotRuleId->$pilot_rule_id; $query2 = mysqli_query($con, "SELECT name FROM pilot_rule WHERE id='$piloteRuleId'"); while($r = mysqli_fetch_assoc($query2)) { $result[] = $r; }// Don't know how to continue from here
1 回答
aluckdog
TA貢獻(xiàn)1847條經(jīng)驗(yàn) 獲得超7個(gè)贊
你可以這樣：
$id = "96707ac6-ecae-11ea-878d-005056bbb446";
$stmt = $con->prepare('SELECT * FROM pilot_time_schedule WHERE pilot_id=?');
$stmt->bind_param('s', $id);
$stmt->execute();
$rows = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
foreach ($rows as $row) {
$stmt = $con->prepare('SELECT name FROM pilot_rule WHERE id=?');
$stmt->bind_param('s', $row['pilot_rule_id']);
$stmt->execute();
// replace with the `name` returned from the above statement.
$row['pilot_rule_id'] = $stmt->get_result()->fetch_row()[0] ?? null;
}
然而，您確實(shí)應(yīng)該了解 SQL 連接。使用 SQL 連接，您可以避免對(duì)數(shù)據(jù)庫(kù)進(jìn)行 N+1 查詢。
$id = "96707ac6-ecae-11ea-878d-005056bbb446";
$stmt = $con->prepare('SELECT pilot_time_schedule.*, pilot_rule.name
FROM pilot_time_schedule
JOIN pilot_rule ON pilot_rule.id=pilot_time_schedule.pilot_rule_id
WHERE pilot_id=?');
$stmt->bind_param('s', $id);
$stmt->execute();
$rows = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
foreach ($rows as $row) {
echo $row['name']; // contains the name from pilot_rule
}
- 1 回答
- 0 關(guān)注
- 188 瀏覽
添加回答
舉報(bào)
0/150
提交
取消