我有一個(gè)腳本，它會在執(zhí)行時(shí)檢查 3 個(gè)隨機(jī)行，我需要這 3 行有自己定義的值以供進(jìn)一步使用。我編寫的腳本可以正常工作，除了我為行變量獲取了 Undefined offset: 1 和 Undefined offset: 2 。如果不是因?yàn)檫@些錯(cuò)誤，我可以忽略它，但是我讓腳本在設(shè)定的時(shí)間通過任務(wù)管理器運(yùn)行，并且錯(cuò)誤導(dǎo)致它無法完成。我已經(jīng)在研究并試圖找到相關(guān)信息，但也許我沒有在尋找正確的術(shù)語。$query1 = mysqli_query($db, "SELECT szName, ip, dwRoleID FROM log_item, gamedata, `user` WHERE dwParam3 = '667287791' and gamedata.dwID = log_item.dwRoleID and gamedata.szName = `user`.`Name` GROUP BY `user`.ip ORDER BY RAND() LIMIT 3") or die(mysqli_error($db));while ($row[] = mysqli_fetch_array($query1, MYSQLI_ASSOC)){$id1 = $row[0]['dwRoleID'];$id2 = $row[1]['dwRoleID'];$id3 = $row[2]['dwRoleID'];$Winner1 = $row[0]['szName'];$Winner2 = $row[1]['szName'];$Winner3 = $row[2]['szName'];$query2 = mysqli_query($db, "DELETE FROM log_item WHERE dwRoleID IN ('$id1', '$id2', '$id3') and dwParam3 = '667287791'") or die(mysqli_error($db));}$msg = "Congratulations$Winner1, $Winner2 and $Winner3 have won the giveaway.Winners have 12 hours to claim their reward or a new winner will be picked.";$curl = curl_init('https://');curl_setopt($curl, CURLOPT_POST, 1);curl_setopt($curl, CURLOPT_POSTFIELDS, json_encode(array('content' => $msg)));curl_exec($curl);我知道它的行輸出格式是錯(cuò)誤的，但除了錯(cuò)誤之外，它完全按照我的意愿行事。
1 回答
慕村225694
TA貢獻(xiàn)1880條經(jīng)驗(yàn) 獲得超4個(gè)贊
你做的 while 循環(huán)錯(cuò)了。在第一次迭代時(shí)，數(shù)組 $row 中索引 0 處將只有一個(gè)元素。這就是索引 1 和 2 缺失的原因。
嘗試這個(gè)：
while ($row[] = mysqli_fetch_array($query1, MYSQLI_ASSOC)){
// empty
}
$id1 = $row[0]['dwRoleID'];
$id2 = $row[1]['dwRoleID'];
$id3 = $row[2]['dwRoleID'];
$Winner1 = $row[0]['szName'];
$Winner2 = $row[1]['szName'];
$Winner3 = $row[2]['szName'];
$query2 = mysqli_query($db, "DELETE FROM log_item WHERE dwRoleID IN ('$id1', '$id2', '$id3') and dwParam3 = '667287791'") or die(mysqli_error($db));
更新 2018-08-10：改用 fetch_all（感謝 Dharman）
$row = mysqli_fetch_all($query1, MYSQLI_ASSOC));
- 1 回答
- 0 關(guān)注
- 132 瀏覽
添加回答
舉報(bào)
0/150
提交
取消