$selectSql = "SELECT huaweiId FROM " . $tableName . " WHERE lottery='0'"; $selectRes = $dbModel->selectFromTable($selectSql); if (!empty($selectRes)) { while ($row = mysql_fetch_assoc($selectRes)) { array_push($guestList, $row['huaweiId']); } //计算数组长度 $allPeople = count($guestList); if (shuffle($guestList)) { $key = rand(0, $allPeople - 1); //取得健名的随机数 $lotteryNo = $guestList[$key]; //获取中奖用户工号 //更新数据库lottery字段为中奖情况 $updateSql = "UPDATE " . $tableName . " SET lottery='" . $giftLever . "' WHERE huaweiId=" . $lotteryNo; $updateRes = $dbModel->updateTable($updateSql); //查询出用户相关信息 $selectPickedSql = "SELECT * FROM " . $tableName . " WHERE huaweiId=" . $lotteryNo; $selectPickedRes = $dbModel->selectFromTable($selectPickedSql); if (!empty($selectPickedRes)) { while ($row = mysql_fetch_assoc($selectPickedRes)) { //array_push($pickedDate[$i],$row['name']);//姓名 //array_push($pickedDate[$i],$row['huaweiId']);//工号 //array_push($pickedDate[$i],$row['avatar']);//头像,$row['avatar'] $pickedDate[$i] = array($row['name'], $row['huaweiId'], $tableName); } } else { echo "未取到中奖用户信息"; } } else { echo "打乱失败";